| From: | "tjk(at)tksoft(dot)com" <tjk(at)tksoft(dot)com> |
|---|---|
| To: | hamid(at)emarq(dot)com (Hamid Khoshnevis) |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] zombie postmasters |
| Date: | 1999-11-16 23:00:13 |
| Message-ID: | 199911162300.PAA14773@uno.tksoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
You can place timeouts on the queries and
terminate the query if it takes too long.
Troy
>
> Hello to all,
> In a web environment, a user can repeatedly starts and abort large queries
> which create a large number of zombie postmasters. Is there a way to
> control the postmaster zombies so that they don't clog up the system
> resources.
>
> thanks,
>
> hamid
>
> Hamid Khoshnevis
> emarQ.com
> 1488-1188 W. Georgia St.
> Vancouver, BC V6E 4A2, Canada
> Ph: (604) 687-7111
> Fx: (604) 687-7222
> http://www.emarq.com
> hamid(at)emarq(dot)com
>
>
> ************
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hamid Khoshnevis | 1999-11-16 23:06:35 | zombie postmasters |
| Previous Message | John Ziniti | 1999-11-16 22:58:09 | Re: [SQL] Updating datetime fields with NULL values |