Re: Query taking a long time...

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Philip Warner" <pjw(at)rhyme(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Query taking a long time...
Date: 2002-01-24 05:10:06
Message-ID: GNELIHDDFBOCMGBFGEFOGECNCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-01-24 05:28:16 Re: RFD: schemas and different kinds of Postgres objects
Previous Message Philip Warner 2002-01-24 04:51:27 Re: Query taking a long time...