Re: [HACKERS] 8.3beta1 testing on Solaris

2007-10-25 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > "Jignesh K. Shah" <[EMAIL PROTECTED]> writes: >> CLOG data is >> not cached in any PostgreSQL shared memory segments > > The above statement is utterly false, so your trace seems to indicate > something broken. Are you sure these were the only reads of pg

Re: [HACKERS] 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

Re: [HACKERS] 8.3beta1 testing on Solaris

2007-10-25 Thread Tom Lane
"Jignesh K. Shah" <[EMAIL PROTECTED]> writes: > CLOG data is > not cached in any PostgreSQL shared memory segments The above statement is utterly false, so your trace seems to indicate something broken. Are you sure these were the only reads of pg_clog files? Can you extend the tracing to deter