Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock

#1

Tom Lane wrote:

Quote:

"John Weekley" <weekleyj (AT) foobarlabs (DOT) net> writes:
Platform is 64 bit Solaris x86.
...
"../../../../src/include/storage/s_lock.h", line 814: #error: PostgreSQL
does not have native spinlock support on this platform. To continue the
compilation, rerun configure using --disable-spinlocks. However,
performance will be poor. Please report this to pgsql-bugs (AT) postgresql (DOT) org.

It looks like s_lock.h currently has coverage for amd64 using gcc, or
sparc64 using either compiler, but not for amd64 using Sun's cc.
Please feel free to send a patch, or you could pester Sun to send us
one (Josh?)

amd64 support for Sun compilers will be in 8.2. It is already in CVS.

--
Bruce Momjian bruce (AT) momjian (DOT) us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2

Zdenek Kotala wrote:

Quote:

Tom Lane wrote:
"John Weekley" <weekleyj (AT) foobarlabs (DOT) net> writes:
Platform is 64 bit Solaris x86.
...
"../../../../src/include/storage/s_lock.h", line 814: #error: PostgreSQL
does not have native spinlock support on this platform. To continue the
compilation, rerun configure using --disable-spinlocks. However,
performance will be poor. Please report this to pgsql-bugs (AT) postgresql (DOT) org.

It looks like s_lock.h currently has coverage for amd64 using gcc, or
sparc64 using either compiler, but not for amd64 using Sun's cc.
Please feel free to send a patch, or you could pester Sun to send us
one (Josh?)

SunStudio is supported on the HEAD (8.2). Spin lock problem is know
issue in version 8.1.4. I don't know if latest 8.1 branch contains
backport.

No, we did not backport because of concern that not enough people
reviewed the changes.

--
Bruce Momjian bruce (AT) momjian (DOT) us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#3

John Weekley wrote:

Quote:

On Mon, 2006-07-24 at 21:47 -0400, Bruce Momjian wrote:
Zdenek Kotala wrote:
Tom Lane wrote:
"John Weekley" <weekleyj (AT) foobarlabs (DOT) net> writes:
Platform is 64 bit Solaris x86.
...
"../../../../src/include/storage/s_lock.h", line 814: #error: PostgreSQL
does not have native spinlock support on this platform. To continue the
compilation, rerun configure using --disable-spinlocks. However,
performance will be poor. Please report this to pgsql-bugs (AT) postgresql (DOT) org.

It looks like s_lock.h currently has coverage for amd64 using gcc, or
sparc64 using either compiler, but not for amd64 using Sun's cc.
Please feel free to send a patch, or you could pester Sun to send us
one (Josh?)

SunStudio is supported on the HEAD (8.2). Spin lock problem is know
issue in version 8.1.4. I don't know if latest 8.1 branch contains
backport.

No, we did not backport because of concern that not enough people
reviewed the changes.

Wow, you guys are really,really good.
Many thanks!

John

P.S. May I ask when we can expect 8.2? Or is is possible to beat on an
alpha/beta?

You can download a snapshot now from our ftp server and test it.

--
Bruce Momjian bruce (AT) momjian (DOT) us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#4

On Mon, 2006-07-24 at 21:47 -0400, Bruce Momjian wrote:

Quote:

Zdenek Kotala wrote:
Tom Lane wrote:
"John Weekley" <weekleyj (AT) foobarlabs (DOT) net> writes:
Platform is 64 bit Solaris x86.
...
"../../../../src/include/storage/s_lock.h", line 814: #error: PostgreSQL
does not have native spinlock support on this platform. To continue the
compilation, rerun configure using --disable-spinlocks. However,
performance will be poor. Please report this to pgsql-bugs (AT) postgresql (DOT) org.

It looks like s_lock.h currently has coverage for amd64 using gcc, or
sparc64 using either compiler, but not for amd64 using Sun's cc.
Please feel free to send a patch, or you could pester Sun to send us
one (Josh?)

SunStudio is supported on the HEAD (8.2). Spin lock problem is know
issue in version 8.1.4. I don't know if latest 8.1 branch contains
backport.

No, we did not backport because of concern that not enough people
reviewed the changes.

Wow, you guys are really,really good.
Many thanks!

John

P.S. May I ask when we can expect 8.2? Or is is possible to beat on an
alpha/beta?

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock - 07-24-2006 , 08:45 PM

Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock - 07-24-2006 , 08:49 PM

Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock - 07-24-2006 , 09:52 PM

Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock - 07-25-2006 , 06:41 AM