Re: [ SOLVED ] select count(*) very slow on an already

Поиск
Список
Период
Сортировка
От Mark Lubratt
Тема Re: [ SOLVED ] select count(*) very slow on an already
Дата
Msg-id E5FA669D-8F0A-11D8-A629-000A9579AF50@indeq.com
обсуждение исходный текст
Ответ на Re: [ SOLVED ] select count(*) very slow on an already  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
On Apr 15, 2004, at 12:44 PM, Richard Huxton wrote:

> On Thursday 15 April 2004 17:19, Rajesh Kumar Mallah wrote:
>> Bill Moran wrote:
>
>> BTW
>>
>> is there any way to disable checks and triggers on
>> a table temporarily while loading data (is updating
>> reltriggers in pg_class safe?)
>
> You can take a look at pg_restore and copy how it does it.
>
>

Does SET CONSTRAINT take care of checks within the transaction?
Triggers would be a different matter...

Mark


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

Предыдущее
От: "J. Andrew Rogers"
Дата:
Сообщение: Re: linux distro for better pg performance
Следующее
От: Bill Moran
Дата:
Сообщение: Re: [ SOLVED ] select count(*) very slow on an already