| From: | Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au> |
|---|---|
| To: | George Essig <george_essig(at)yahoo(dot)com> |
| 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 01:20:20 |
| Message-ID: | Pine.GSO.4.10.10311151218510.12776-100000@bruce.csse.monash.edu.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
On Fri, 14 Nov 2003, George Essig wrote:
> Slavisa Garic wrote:
>
> > Hi Everyone,
>
> > I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x
> > onwards)
> > and with all of them I noticed same problem with INSERTs when there is
> > a
> > large data set. Just to so you guys can compare time it takes to insert
> > one row into a table when there are only few rows present and when
> > there
> > are thousands:
>
> Try running VACUUM ANALYZE periodically during inserts. I found this to help.
>
> George Essig
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-11-15 03:35:46 | Re: Query question |
| Previous Message | Tom Lane | 2003-11-14 22:12:27 | Re: n_distinct way off, but following a pattern. |