Skip site navigation (1) Skip section navigation (2)

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

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, Stephen Frost <sfrost(at)snowman(dot)net>
Subject: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Date: 2012-02-26 15:20:54
Message-ID: 4F4A4DD6.6090904@squeakycode.net (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

Responses

pgsql-performance by date

Next:From: Venkat BalajiDate: 2012-02-26 17:14:51
Subject: Re: : Cost calculation for EXPLAIN output
Previous:From: Mark HillsDate: 2012-02-26 14:16:47
Subject: Index condition in a Nested Loop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group