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'
In response to
pgsql-performance by date
|Next:||From: Venkat Balaji||Date: 2012-02-26 17:14:51|
|Subject: Re: : Cost calculation for EXPLAIN output|
|Previous:||From: Mark Hills||Date: 2012-02-26 14:16:47|
|Subject: Index condition in a Nested Loop|