Re: pg_prewarm - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_prewarm
Date
Msg-id CA+TgmoYSUgrnd_28AK7qfb=vP+CSDxVeZxnm3jEfjh0ONHH=Tw@mail.gmail.com
Whole thread Raw
In response to Re: pg_prewarm  (Stefan Keller <sfkeller@gmail.com>)
Responses Re: pg_prewarm  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-hackers
On Sat, Mar 10, 2012 at 4:35 PM, Stefan Keller <sfkeller@gmail.com> wrote:
> The main conclusion was:
> * Do a "tar cf /dev/zero $PG_DATA/base either shortly before or
> shortly after the database is created"
> * Do a seq scan "SELECT * FROM osm_point".
>
> Is your tool a replacement of those above?

It can be used that way, although it is more general.

(The patch does include documentation...)

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Creager
Date:
Subject: Re: pg_crypto failures with llvm on OSX
Next
From: Robert Haas
Date:
Subject: wal_buffers, redux