Re: ANALYZE locks pg_listener in EXCLUSIVE for long

At 12:45 PM 3/05/2004, Tom Lane wrote:
>Possibly we could reduce the strength of the lock taken by the async.c
>functions

If possible, this seems like a great option. We currently have a large 
database with several hundred users who get locked out for as much as half 
an hour while ANALYZE runs.

The data in the database is extremely dynamic, so the analyze needs to be 
run regularly; we could run less often but this will just mean the problem 
happens once per week instead of once per day.

Would ACCESS SHARE be OK?


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 03 5330 3172          |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                 |    --________--
PGP key available upon request,  |  /
and from pgp.mit.edu:11371       |/