From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Insert slow down on empty database
Date: Fri, 03 Jun 2005 21:20:08 -0400
Message-ID: <m3br6msyt3.fsf@knuth.cbbrowne.com> (raw)
References: <d7qo6e$fq$1@news.hub.org>
In an attempt to throw the authorities off his trail, "Morgan" <mkita@verseon.com> transmitted:
> At first I was using straight insert statments, and although they
> were a bit slower than the prepared statments(after the restablished
> connection) they never ran into this problem with the database being
> initially empty. I only changed to the prepared statements because
> it was suggested in the documentation for advice on bulk data loads
> =).
I remember encountering this with Oracle, and the answer being "do
some loading 'til it slows down, then update statistics and restart."
I don't know that there's an obvious alternative outside of perhaps
some variation on pg_autovacuum...
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne; rate me
http://linuxdatabases.info/info/spreadsheets.html
So long and thanks for all the fish.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Insert slow down on empty database
In-Reply-To: <m3br6msyt3.fsf@knuth.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox