Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Dec 2006 13:22:51 -0500
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
- References:
- slow speeds after 2 million rows inserted
- From: James Neff
- Re: slow speeds after 2 million rows inserted
- From: Joshua D. Drake
- slow speeds after 2 million rows inserted
- Prev by Date: Re: slow speeds after 2 million rows inserted
- Next by Date: Re: slow speeds after 2 million rows inserted
- Previous by thread: Re: slow speeds after 2 million rows inserted
- Next by thread: Re: slow speeds after 2 million rows inserted
- Indexes: