From: | John Scott <jmscott(at)yahoo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | using WAL in a VACUUM? |
Date: | 2001-06-22 23:43:47 |
Message-ID: | 20010622234347.18832.qmail@web10006.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
has anyone thought about applying the write-ahead log
to the results of a vacuum that allows both readers and writers?
in other words, couldn't vacuum just record the highest commited
transaction id, say "TX", run the vacuum in a private space,
then apply the write-ahead log for all transactions after "TX"
to the private space, and, finally, update the appropriate system
tables to point to the new version of the tables.
seems to me that this approach, while disk intensive, would work well in
environments where a 24x7 db is critical AND slow periods are acceptable.
of course, this approach is lossy, since the wal could
be active through out the sync by the vacuum process.
in other words, the vacuum could perpetually chase the tail
of an active wal. so the vacuum just gives up after a certain number of
tries.
otherwise, do any fundamental problems exist with this approach?
cheers-john scott
=====
John Scott
Senior Partner
August Associates
email: john(at)august(dot)com
web: http://www.august.com/~jmscott
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-06-23 00:04:44 | Re: [HACKERS] Re: Multiple Indexing, performance impact |
Previous Message | Tom Lane | 2001-06-22 23:29:58 | Re: Multiple Indexing, performance impact |