Re: Caching by Postgres - Mailing list pgsql-performance

From Tom Lane
Subject Re: Caching by Postgres
Date
Msg-id 4587.1124825023@sss.pgh.pa.us
Whole thread Raw
In response to Re: Caching by Postgres  (Donald Courtney <Donald.Courtney@Sun.COM>)
List pgsql-performance
Donald Courtney <Donald.Courtney@Sun.COM> writes:
> I am not alone in having the *expectation* that a database should have
> some cache size parameter and the option to skip the file system.  If
> I use oracle, sybase, mysql and maxdb they all have the ability to
> size a data cache and move to 64 bits.

And you're not alone in holding that opinion despite having no shred
of evidence that it's worthwhile expanding the cache that far.

However, since we've gotten tired of hearing this FUD over and over,
8.1 will have the ability to set shared_buffers as high as you want.
I expect next we'll be hearing from people complaining that they
set shared_buffers to use all of RAM and performance went into the
tank ...

            regards, tom lane

pgsql-performance by date:

Previous
From: John Mendenhall
Date:
Subject: Re: complex query performance assistance request
Next
From: Josh Berkus
Date:
Subject: Re: Caching by Postgres