Re: changeset generation v5-01 - Patches & git tree - Mailing list pgsql-hackers

From Tom Lane
Subject Re: changeset generation v5-01 - Patches & git tree
Date
Msg-id 9844.1372434969@sss.pgh.pa.us
Whole thread Raw
In response to Re: changeset generation v5-01 - Patches & git tree  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: changeset generation v5-01 - Patches & git tree
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I'm just talking out of my rear end here because I don't know what the
> real numbers are, but it's far from obvious to me that there's any
> free lunch here.  That having been said, just because indexing
> relfilenode or adding relfilenodes to WAL records is expensive doesn't
> mean we shouldn't do it.  But I think we need to know the price tag
> before we can judge whether to make the purchase.

Certainly, any of these solutions are going to cost us somewhere ---
either up-front cost or more expensive (and less reliable?) changeset
extraction, take your choice.  I will note that somehow tablespaces got
put in despite having to add 4 bytes to every WAL record for that
feature, which was probably of less use than logical changeset
extraction will be.

But to tell the truth, I'm mostly exercised about the non-unique
syscache.  I think that's simply a *bad* idea.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: PostgreSQL 9.3 latest dev snapshot