Re: Insert slow down on empty database

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Insert slow down on empty database
Дата
Msg-id m3br6msyt3.fsf@knuth.cbbrowne.com
обсуждение исходный текст
Ответ на Insert slow down on empty database  ("Morgan" <mkita@verseon.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Query plan for very large number of joins
Следующее
От: Junaili Lie
Дата:
Сообщение: Re: Forcing use of specific index