On Tue, Dec 17, 2013 at 11:02 AM, Jim Nasby <[email protected]> wrote: > On 12/17/13, 8:34 AM, Robert Haas wrote: >> >> On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila <[email protected]> >> wrote: >>> >>> I have used pg_prewarm during some of work related to Buffer Management >>> and >>> other performance related work. It is quite useful utility. >>> +1 for reviving this patch for 9.4 >> >> >> Any other votes? > > > We've had to manually code something that runs EXPLAIN ANALYZE SELECT * from > a bunch of tables to warm our caches after a restart, but there's numerous > flaws to that approach obviously. > > Unfortunately, what we really need to warm isn't the PG buffers, it's the FS > cache, which I suspect this won't help. But I still see where just > pg_buffers would be useful for a lot of folks, so +1.
It'll do either one. For the FS cache, on Linux, you can also use pgfincore. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
