Re: pg_rewarm status
От
Jeff Janes
Тема
Re: pg_rewarm status
Дата
Msg-id
CAMkU=1xOWa5iHQ0hP+5xTDVm3=75RXNB1UG=Qe_oYJF5hXkZGg@mail.gmail.com
Ответ на
Re: pg_rewarm status (Jim Nasby)
Список
Дерево обсуждения
pg_rewarm status Jeff Amiel <becauseimjeff@yahoo.com>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status Jeff Janes <jeff.janes@gmail.com>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status Amit Kapila <amit.kapila16@gmail.com>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status "MauMau" <maumau307@gmail.com>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status Kevin Grittner <kgrittn@ymail.com>
Re: pg_rewarm status Jim Nasby <jim@nasby.net>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status Cédric Villemain <cedric@2ndquadrant.fr>
Re: pg_rewarm status Jeff Janes <jeff.janes@gmail.com>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_rewarm status Amit Kapila <amit.kapila16@gmail.com>
Re: pg_rewarm status Robert Haas <robertmhaas@gmail.com>
Re: pg_rewarm status Andres Freund <andres@2ndquadrant.com>
Re: pg_rewarm status Jeff Janes <jeff.janes@gmail.com>
On Tue, Dec 17, 2013 at 8:02 AM, Jim Nasby <jim@nasby.net> wrote:
On 12/17/13, 8:34 AM, Robert Haas wrote: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.On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila <amit.kapila16@gmail.com> 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?
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.
Since it doesn't use directIO, you can't warm the PG buffers without also warming FS cache as a side effect. That is why I like 'buffer' as the default--if the data fits in shared_buffers, it warm those, otherwise it at least warms the FS. If you want to only warm the FS cache, you can use either the 'prefetch' or 'read' modes instead.
Cheers,
Jeff
В списке pgsql-hackers по дате отправления
