Postgres Pro
Downloads
Home   >   mailing lists

Re: slow speeds after 2 million rows inserted - Mailing list pgsql-general

From James Neff
Subject Re: slow speeds after 2 million rows inserted
Date
Msg-id 45955CFB.5080404@tethyshealth.com
Whole thread Raw
In response to Re: slow speeds after 2 million rows inserted  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
Joshua D. Drake wrote:
> You need to vacuum during the inserts :)
>
> Joshua D. Drake
>

I ran the vacuum during the INSERT and it seemed to help a little, but
its still relatively slow compared to the first 2 million records.

Any other ideas?

Thanks,
James

pgsql-general by date:

Previous
From: Frank Finner
Date:
Subject: Re: slow speeds after 2 million rows inserted
Next
From: "Joshua D. Drake"
Date:
Subject: Re: slow speeds after 2 million rows inserted