Re: [HACKERS] [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL

2006-07-21 Thread Sven Geisler
Hi, Tom Lane schrieb: > Robert Lor <[EMAIL PROTECTED]> writes: >> I ran pgbench and fired up a DTrace script using the lwlock probes we've >> added, and it looks like BufMappingLock is the most contended lock, but >> CheckpointStartLocks are held for longer duration! > > Those numbers look a b

Re: [HACKERS] patch postgresql for AMD64 (Opteron)

2006-07-03 Thread Sven Geisler
DualCore and we get 15+ context switches/sec. We have around 30 clients. We use RHEL 4 in 32-bit (i368) mode. I didn't use the patch for the Opteron-specific behavior. Cheers Sven. Tom Lane schrieb: > Sven Geisler <[EMAIL PROTECTED]> writes: >> I created a patch fo

[HACKERS] patch postgresql for AMD64 (Opteron)

2006-06-09 Thread Sven Geisler
Hi all, I created a patch for PostgreSQL and x86 architecture. This patch address a Opteron-specific behavior regarding some assembler statements. The patch based on a patch to PostgreSQL 8.0.3 which was worked out by RedHat. Tom did change src/include/storage/s_lock.h for PostgreSQL 8.1.x. Th

Re: [PERFORM] [HACKERS] qsort again

2006-02-16 Thread Sven Geisler
Martijn van Oosterhout schrieb: Last time around there were a number of different algorithms tested. Did anyone run those tests while getting it to count the number of actual comparisons (which could easily swamp the time taken to do the actual sort in some cases)? The last time I did such te