Re: constraint exclusion analysis caching

--GV0iVqYguTV4Q9ER
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Gregory Stark (stark@[EMAIL PROTECTED]
) wrote:
> "Andrew Dunstan" <andrew@[EMAIL PROTECTED]
> writes:
>=20
> > Actual execution of the query in question was talking one tenth of
that
> > time.
> >...
> > but in principle it seems silly to keep paying the same penalty over
and
> > over again.
>=20
> I would think constraint_exclusion only really makes sense if you're
spen=
ding
> a lot more time executing than planning queries. Either that means
you're
> preparing queries once and then executing them many many times or you're
> planning much slower queries where planning time is insignificant
compare=
d to
> the time to execute them.

Would it be possible to change the application to use prepared queries?
Seems like that'd make more sense the changing it to use the child
tables directly..  Just my 2c.

	Thanks,

		Stephen

--GV0iVqYguTV4Q9ER
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIJKPHrzgMPqB3kigRAnFcAJ9aVRL4fRX32MOpp4KwAZ6J9YP9CQCffopQ
jaHRrFNr65Odc/4aZ0ZBMkg=
=GPOj
-----END PGP SIGNATURE-----

--GV0iVqYguTV4Q9ER--