On 2016-04-13 06:57:15 -0400, Robert Haas wrote: > You will eventually, because each scan will pick a new ring buffer, > and gradually more and more of the relation will get cached. But it > can take a while.
You really don't need much new data to make that an unobtainable goal ... :/ > I'd be more inclined to try to fix this by prewarming the buffers that > were in shared_buffers at shutdown. That doesn't solve the problem of not reacting to actual new data? It's not that uncommon to regularly load new data with copy and drop old partitions, just to keep the workload memory resident... Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers