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

Re: Slow performance when querying millions of rows

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow performance when querying millions of rows
Date: 2011-06-29 00:51:50
Message-ID: 4E0A7726.2040809@2ndQuadrant.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 06/28/2011 07:26 PM, Craig McIlwee wrote:
> Yes, the data import is painfully slow but I hope to make up for that 
> with the read performance later.

You can probably improve that with something like this:

shared_buffers=512MB
checkpoint_segments=64

Maybe bump up maintenance_work_mem too, if the vacuum part of that is 
the painful one.

-- 
Greg Smith   2ndQuadrant US    greg(at)2ndQuadrant(dot)com   Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
http://www.2ndquadrant.us/postgresql-training/


In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2011-06-29 01:01:53
Subject: Re: Slow performance when querying millions of rows
Previous:From: Tomas VondraDate: 2011-06-29 00:10:48
Subject: Re: Slow performance when querying millions of rows

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