Skip site navigation (1) Skip section navigation (2)

Re: Not HOT enough

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Not HOT enough
Date: 2011-11-23 21:55:29
Message-ID: 4530.1322085329@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> My patch actually improves the speed of snapshots, rather than slowing
> them as Tom's would.

It can be arbitrarily fast if it doesn't have to get the right answer.
Unfortunately, you're not producing the right answer.  You can not
exclude XIDs in other databases from the snapshot, at least not unless
you know that the snapshot will not be used for examining any shared
catalogs ... and GetSnapshotData certainly cannot know that.

I think that the idea of computing a different cutoff on the
probably-rare occasions where we need to prune a shared catalog page
has some merit, but the change you are currently proposing to
GetSnapshotData flat out does not work.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-11-23 22:05:07
Subject: Re: [Review] Include detailed information about a row failing a CHECK constraint into the error message
Previous:From: Tom LaneDate: 2011-11-23 21:39:35
Subject: Re: range_adjacent and discrete ranges

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group