Re: [ADMIN] Vacuum and deadlock.

2001-09-06 Thread Jeremy Buchmann
On Wednesday, September 5, 2001, at 07:11 AM, Sébastien HEITZMANN wrote: > Since some week I have some trouble with my database. I use postgres v > 7.1.2 on redhat 7.0 >   > The trouble is that the database lock when in the night some user left > an application open ( which do some read on som

[ADMIN] Vacuum and deadlock.

2001-09-05 Thread Sébastien HEITZMANN
Since some week I have some trouble with my database. I use postgres v 7.1.2 on redhat 7.0   The trouble is that the database lock when in the night some user left an application open ( which do some read on some table) and the night process of backup and vacuum happend. The database stay in