Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow sequential scans on one DB but not another; fragmentation? - Mailing list pgsql-general

From Joseph S
Subject Re: Slow sequential scans on one DB but not another; fragmentation?
Date
Msg-id 460C1588.6070301@selectacast.net
Whole thread Raw
In response to Re: Slow sequential scans on one DB but not another; fragmentation?  (Stephen Harris <lists@spuddy.org>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timestamp precision
Next
From: Bruce Momjian
Date:
Subject: Re: COPY command details