| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [ADMIN] Vacuum error on database postgres |
| Date: | 2006-09-15 10:33:00 |
| Message-ID: | 450A815C.6000709@logix-tt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Hi, Tom,
Tom Lane wrote:
> We could add another LockTagType just for ANALYZE, but that seems like
> rather a lot of infrastructure to support an extremely narrow corner
> case, namely two people doing database-wide ANALYZE at the same time
> inside transaction blocks. (If they do it outside a transaction block
> then the ANALYZE is divided into multiple xacts and so doesn't try to
> hold locks on multiple tables concurrently. autovacuum won't try to do
> that either.)
Is there any reason to allow ANALYZE run insinde a transaction at all?
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2006-09-15 10:44:33 | Postgresql 7.4 migration to (partially) new disks |
| Previous Message | Martijn van Oosterhout | 2006-09-15 09:40:55 | Re: [ADMIN] Vacuum error on database postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2006-09-15 10:43:52 | Re: Fixed length data types issue |
| Previous Message | Andrew - Supernews | 2006-09-15 10:17:55 | Re: New version of money type |