Re: [PERFORM] 8.3beta1 testing on Solaris

2007-10-26 Thread Jignesh K. Shah
Hi George, I have seen the 4M/sec problem first actually during an EAStress type run with only 150 connections. I will try to do more testing today that Tom has requested. Regards, Jignesh Gregory Stark wrote: "Jignesh K. Shah" <[EMAIL PROTECTED]> writes: CLOG data is not cached in a

Re: [PERFORM] 8.3beta1 testing on Solaris

2007-10-25 Thread Gregory Stark
"Jignesh K. Shah" <[EMAIL PROTECTED]> writes: > CLOG data is not cached in any PostgreSQL shared memory segments and hence > becomes the bottleneck as it has to constantly go to the filesystem to get > the read data. This is the same bottleneck you discussed earlier. CLOG reads are cached in the

[PERFORM] 8.3beta1 testing on Solaris

2007-10-25 Thread Jignesh K. Shah
Update on my testing 8.3beta1 on Solaris. * CLOG reads * Asynchronous Commit benefit * Hot CPU Utilization Regards, Jignesh __Background_:_ We were using PostgreSQL 8.3beta1 testing on our latest Sun SPARC Enterprise T5220 Server using Solaris 10 8/07 and Sun Fire X4200 using Solaris 10 8/07.