Re: [PERFORM] [HACKERS] 8.3beta1 testing on Solaris

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Thu Oct 25 2007 - 16:54:01 EDT

"Jignesh K. Shah" <J.K.Shah@Sun.COM> 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 determine which page of the file got read? I am wondering if your (unspecified) test load was managing to touch more pages of the clog than there is room for in shared memory.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org Received on Thu Oct 25 16:55:33 2007