Re: [ SOLVED ] select count(*) very slow on an already - Mailing list 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