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

Re: Physical Tlist optimization still possible?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Physical Tlist optimization still possible?
Date: 2005-06-01 13:57:02
Message-ID: 13403.1117634222@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> Where I'm leading to is this: If the physical tlist optimization is a
> considerable gain, and it required OIDs, then changing the system
> default to WITHOUT OIDS will cause us to lose the optimization. Yes?

It doesn't require OIDs, though.  What it requires is that the source
and destination tables have the same OIDs-ness.  So changing the default
shouldn't make a difference.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-06-01 13:58:53
Subject: Re: NOLOGGING option, or ?
Previous:From: Bruce MomjianDate: 2005-06-01 13:39:07
Subject: Re: NOLOGGING option, or ?

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