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

From: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [ SOLVED ] select count(*) very slow on an already
Date: 2004-04-15 18:29:57
Message-ID: E5FA669D-8F0A-11D8-A629-000A9579AF50@indeq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2004-04-15 18:48:41 Re: [ SOLVED ] select count(*) very slow on an already
Previous Message J. Andrew Rogers 2004-04-15 18:28:26 Re: linux distro for better pg performance