Re: INSERT extremely slow with large data sets (fwd)

From: George Essig <george_essig(at)yahoo(dot)com>
To: Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>
Cc: Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: INSERT extremely slow with large data sets (fwd)
Date: 2003-11-15 13:13:38
Message-ID: 20031115131338.90329.qmail@web80208.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


--- Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au> wrote:
> Does VACUUM ANALYZE help with the analysis or it also speeds up the
> process. I know i could try that before I ask but experiment is running
> now and I am too curious to wait :),
>
> Anyway thanks for the hint,
> Slavisa
>

VACUUM ANALYZE will reclaim disk space and update statistics used by the optimizer to help execute
queries faster. This could speed up your inserts. See
http://www.postgresql.org/docs/7.3/static/sql-vacuum.html.

George Essig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message radha.manohar 2003-11-15 14:52:45 Re: Error in transaction processing
Previous Message Dennis Bjorklund 2003-11-15 10:21:09 Re: Help with count(*)