On Tue, 2005-05-31 at 22:31 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
If a table is created as WITHOUT OIDS, is it still possible to take
advantage of the physical tlist optimization?
Um ... it depends. There are cases where you have to have an OID,
and cases where you
Simon Riggs [EMAIL PROTECTED] 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
If a table is created as WITHOUT OIDS, is it still possible to take
advantage of the physical tlist optimization?
Best Regards, Simon Riggs
---(end of broadcast)---
TIP 8: explain analyze is your friend
Simon Riggs [EMAIL PROTECTED] writes:
If a table is created as WITHOUT OIDS, is it still possible to take
advantage of the physical tlist optimization?
Um ... it depends. There are cases where you have to have an OID,
and cases where you have to not have one. See ExecContextForcesOids.