From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Plans for solving the VACUUM problem |
Date: | 2001-05-18 05:29:06 |
Message-ID: | 13940.990163746@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> Another quick thought for handling FSM contention problems. A backend could
> give up waiting for access to the FSM after a short period of time, and just
> append it's data to the end of the file the same way it's done now. Dunno
> if that is feasable but it seemed like an idea to me.
Mmm ... maybe, but I doubt it'd help much. Appending a page to the file
requires grabbing some kind of lock anyway (since you can't have two
backends doing it at the same instant). With any luck, that locking can
be merged with the locking involved in accessing the FSM.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-18 05:41:33 | Re: Plans for solving the VACUUM problem |
Previous Message | Hiroshi Inoue | 2001-05-18 05:21:12 | Re: Plans for solving the VACUUM problem |