-----BEGIN PGP SIGNED MESSAGE-----
> Nope; Gaetano's right, you cannot assume that. It's entirely possible
> for the planner to choose different plans depending on the OFFSET.
> (Maybe not very likely, with such small offsets, but could happen.)
Interesting. I realized that there was a finite chance of different
plans being chosen, but it seemed neigh-impossible since there is
no WHERE clause and the offsets only vary from 0-7. What sort of
different plans would it choose, out of curiosity?
Seq-scan vs. index-scan? Are there any particular cases where the
same plan is guaranteed to be used?
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200408192216
-----BEGIN PGP SIGNATURE-----
-----END PGP SIGNATURE-----
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2004-08-20 03:25:21|
|Subject: Re: SQL Challenge: Arbitrary Cross-tab |
|Previous:||From: Tony Yang||Date: 2004-08-19 22:00:56|
|Subject: help with scheme changes to live system.|