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

Re: Slow sequential scans on one DB but not another; fragmentation?

From: Joseph S <jks(at)selectacast(dot)net>
To: Stephen Harris <lists(at)spuddy(dot)org>
Subject: Re: Slow sequential scans on one DB but not another; fragmentation?
Date: 2007-03-29 19:37:44
Message-ID: 460C1588.6070301@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-general
Stephen Harris wrote:

> I'm vacuuming every night after the inserts are done.
> 
You should vacuum after the deletes and before the inserts, so the 
inserts can go into the just reclaimed space.

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2007-03-29 19:41:20
Subject: Re: COPY command details
Previous:From: Tom LaneDate: 2007-03-29 19:31:56
Subject: Re: Timestamp precision

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