| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
| Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Don Baccus <dhogaza(at)pacifier(dot)com>, ZEUGSWETTER Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>, pgsql-hackers(at)postgreSQL(dot)org, "'kar(at)webline(dot)dk'" <kar(at)webline(dot)dk> |
| Subject: | Re: [HACKERS] 6.6 items |
| Date: | 1999-06-08 17:52:06 |
| Message-ID: | 375D5846.41BCFCC9@krs.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Jackson, DeJuan" wrote:
>
> What about potential deadlocking issues with vacuum? Haven't tried to
> deadlock vacuum, but wondering if it's possible.
Shouldn't be possible.
Vacuum never acquires AccessExclusive lock on more than
one table at once. This lock is released immediately
after a relation processed.
SELECT/COPY_TO queries from pg_dump lock relations
in AccessShare mode for duration of query.
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher C Chimelis | 1999-06-08 17:52:41 | Re: [PORTS] Anyone working on linux Alpha? |
| Previous Message | Bruce Momjian | 1999-06-08 17:49:18 | Open 6.5 items |