Re: Insert slow down on empty database - Mailing list pgsql-performance

From Christopher Browne
Subject Re: Insert slow down on empty database
Date
Msg-id m3br6msyt3.fsf@knuth.cbbrowne.com
Whole thread Raw
In response to Insert slow down on empty database  ("Morgan" <mkita@verseon.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Query plan for very large number of joins
Next
From: Junaili Lie
Date:
Subject: Re: Forcing use of specific index