From: | vimal(dot)gupta(at)gmail(dot)com |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Hanging Query |
Date: | 2006-01-08 17:34:30 |
Message-ID: | 1136741670.479720.284080@f14g2000cwb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
We have to inserts a records(15000- 20000) into a table which also
contains (15000-20000) records, then after insertion, we have to delete
the records according to a business rule.
Above process is taking place in a transaction and we are using batches
of 128 to insert records.
Everything works fine on QA environment but somehow after inserts,
delete query hangs in production environment. Delete query has some
joins with other table and a self join. There is no exception as we
have done enough exception handling. It simply hangs with no trace in
application logs.
When I do "ps aux" , I see
postgres 5294 41.3 2.4 270120 38092 pts/4 R 10:41 52:56
postgres: nuuser nm 127.0.0.1 DELETE
Postgres 7.3.4 on Linux..
Thanks for any help..
Vimal
From | Date | Subject | |
---|---|---|---|
Next Message | Luke Lonergan | 2006-01-08 18:42:31 | Re: help tuning queries on large database |
Previous Message | Greg Stark | 2006-01-08 16:49:12 | Re: Stats collector performance improvement |