Re: [GENERAL] My Slow query.

2005-08-24 Thread Dann Corbit
nal Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Jason > Sent: Wednesday, August 24, 2005 11:38 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] My Slow query. > > Hi: > > I have a query that uses one table with a

[GENERAL] My Slow query.

2005-08-24 Thread Jason
Hi: I have a query that uses one table with about 1 million rows. So far it has been running for about 12h on a P4 3Ghz. The query/function does this: Esentially flattens some data. It looks through the values in a row, does an if/else to categorize the value and update another table based on the