Re: Plans for solving the VACUUM problem

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

In response to

Browse pgsql-hackers by date

  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