Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> Oh, but it's worse than that. When you XLOG a WAL record for each of
> those pages, you're going to trigger full-page writes for all of them.
> So now you've turned 1GB of data to write into 2+ GB of data to
No, because only the first mod of each VM page would trigger a full page
write, at least assuming a reasonable ordering of the operations.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-11-30 16:37:13|
|Subject: Re: crash-safe visibility map, take three |
|Previous:||From: Daniel Loureiro||Date: 2010-11-30 16:33:07|
|Subject: Re: DELETE with LIMIT (or my first hack)|