On Mon, Dec 8, 2008 at 11:56 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > Greg Stark <[EMAIL PROTECTED]> writes: >> That might only be the case when the pg_statistic record is in shared >> buffers. > > Yeah, it seems unlikely that disabling compression is a good idea in the > bigger scheme of things.
Is there any way to figure out what sort of compression ratios we're typically getting? The only way compression can really be a win is if it's saving us having to read in additional pages. Even then, I'm not sure we should worry about needing to read in additional pages in this case. I would sure expect statistics to stay in shared buffers, or at least in the operating system cache. Sure, if the table is accessed VERY infrequently, that might not be the case, but is that really what we want to optimize for? ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
