Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?

On 02/25/2012 06:16 PM, Stefan Keller wrote:
>
> 1. How can I warm up or re-populate shared buffers of Postgres?
> 2. Are there any hints on how to tell Postgres to read in all table
> contents into memory?
>
> Yours, Stefan
>

How about after you load the data, vacuum freeze it, then do something like:

SELECT count(*) FROM osm_point WHERE tags @> 'tourism=>junk'

-Andy