Re: 7.0.2 -> 7.1 performance drop

Поиск
Список
Период
Сортировка
От Brent R. Matzelle
Тема Re: 7.0.2 -> 7.1 performance drop
Дата
Msg-id 20011112184843.21237.qmail@web13006.mail.yahoo.com
обсуждение исходный текст
Ответ на 7.0.2 -> 7.1 performance drop  (Frank Bax <fbax@sympatico.ca>)
Ответы Re: 7.0.2 -> 7.1 performance drop  (Frank Bax <fbax@sympatico.ca>)
Список pgsql-general
--- Frank Bax <fbax@sympatico.ca> wrote:
> The script just deletes all rows in
> tables, imports
> data as seperate inserts for each row, then does vaccum
> analyse on the
> tables.  I've read that delete/rebuild of indexes will likely
> improve
> performance of this script, but the runtime itself is not
> really a concern
> here, just the change in runtime between releases.  I'm
> curious what
> changed between releases to cause the slower processing?

Your script performs 3 separate actions.  Do you know which one
(delete, import, vacuum analyze) is slower when using the new
version of PG?  That will help pinpoint the problem so that we
can more easily solve the problem.

Brent

Brent

__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: 7.0.2 -> 7.1 performance drop
Следующее
От: Keary Suska
Дата:
Сообщение: Is data storage secure?