Re: slow speeds after 2 million rows inserted

From: James Neff <jneff(at)tethyshealth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: slow speeds after 2 million rows inserted
Date: 2006-12-29 18:22:51
Message-ID: 45955CFB.5080404@tethyshealth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-12-29 18:28:39 Re: slow speeds after 2 million rows inserted
Previous Message James Neff 2006-12-29 18:21:12 Re: slow speeds after 2 million rows inserted