Re: [PERFORM] locking/performance, Solaris performance discovery

2003-10-06 Thread Jeff
On Mon, 6 Oct 2003, Tom Lane wrote: > > Does Solaris have Posix semaphores? You could try using those instead. > > regards, tom lane Yep. It does. I learned them quick enough (using posix_sema.c as a guide) and found out that at least on Sol 2.6 they are slower than sysv -

Re: [PERFORM] locking/performance, Solaris performance discovery

2003-10-06 Thread Tom Lane
Jeff <[EMAIL PROTECTED]> writes: > I've started profiling and running tests... currently it is leaning > towards the sysv semaphores. I see in src/backend/port/ that pg_sema.c is > linked to the sysv implementation. Does Solaris have Posix semaphores? You could try using those instead.

[PERFORM] locking/performance, Solaris performance discovery

2003-10-06 Thread Jeff
On Mon, 6 Oct 2003, Andrew Sullivan wrote: > There's plenty of academic work which purports to show that LRU is > far from the best choice. Just in principle, it seems obvious that a > single-case seqscan-type operation (such as vacuum does) is a good > way to lose your cache for no real gain. >