From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Idea for nested transactions / savepoints |
Date: | 2001-08-05 17:52:00 |
Message-ID: | 3B6D87C0.5B82E3B5@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
>
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> The complaints about WAL size amount to "we don't have the disk space
> >> to keep track of this, for long-running transactions". If it doesn't
> >> fit on disk, how likely is it that it will fit in memory?
>
> > Sure, we can put on the disk if that is better.
>
> I think you missed my point. Unless something can be done to make the
> log info a lot smaller than it is now, keeping it all around until
> transaction end is just not pleasant. Waving your hands and saying
> that we'll keep it in a different place doesn't affect the fundamental
> problem: if the transaction runs a long time, the log is too darn big.
Keeping it in a different place does have other benefits - you can
discard
each subtransaction after it is committed/aborted regardless of what WAL
log does, so the chap who did a "begin transaction" 8 hours ago does not
get
subtransactions kept as well, thus postponing the problem a lot.
> There probably are things we can do --- for example, I bet an UNDO
> log kept in this way wouldn't need to include page images.
Not keeping something that does not need to be kept is always a good
idea
when preserving space is important.
> But it's that sort of consideration that will make or break UNDO,
> not where we store the info.
But "how long do we need to keep the info" _is_ an important
consideration.
--------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2001-08-05 18:00:38 | Re: Re: Name for new VACUUM |
Previous Message | Hannu Krosing | 2001-08-05 17:45:47 | Re: Re: Name for new VACUUM |