Default Performance between 8.0 and 8.1

От: Ted Jordan
Тема: Default Performance between 8.0 and 8.1
Дата: ,
Msg-id: 20070804203549.A5EA486C6B@mail.phase.net.nz
(см: обсуждение, исходный текст)
Ответы: Re: Default Performance between 8.0 and 8.1  ("Merlin Moncure")
Список: pgsql-performance

Hi

 

We currently have some databases running under 8.0 and 8.1.  I have noticed a significant difference in the time taken to restore dumps between the two versions, with 8.0 being much faster.  For example a dump of a few MB will take just seconds to load under 8.0 but the same dump will take several minutes to load under 8.1.  Currently we’re just using the default parameter settings when installed via apt on Ubuntu Linux.

 

I would just like to know if this is a well known issue and if there is a quick fix, or should I be digging deeper and seeing if the default settings are mismatched to certain linux kernel settings etc.

 

Any help would be most appreciated.

 

Thanks,

Ted


В списке pgsql-performance по дате сообщения:

От: Adriaan van Os
Дата:
Сообщение: Re: TRUNCATE TABLE
От: Heikki Linnakangas
Дата:
Сообщение: Re: Performance problems with large telemetric datasets on 7.4.2