Re: Query taking a long time... - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Query taking a long time...
Date
Msg-id GNELIHDDFBOCMGBFGEFOGECNCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Query taking a long time...  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> >I've just added a new column to a table, and I am updating it to have a
> >value.  The table has only 18000 rows, and yet the query takes
> in the order
> >of 10 minutes to complete.  This is the process running:
>
> No triggers or FK constraints etc?

Gah!  I just remembered that I have a trigger on the table that updates the
full text index on another table!

Sorry...

Chris



pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Query taking a long time...
Next
From: Peter Eisentraut
Date:
Subject: Re: RFD: schemas and different kinds of Postgres objects