David Blasby <[EMAIL PROTECTED]> writes:
> The only real problem is that the user has to manual keep stats
> up-to-date. Is there anyway to attach something to VACUUM ANALYSE?
The ANALYZE code is set up with the idea that there could be multiple
analysis methods and various kinds of stuff stored
David Blasby <[EMAIL PROTECTED]> writes:
> I've been noticing query planning to be different for a cursor-based
> select and normal select.
IIRC, in a DECLARE context the planner puts more weight on the startup
cost than the total cost, on the theory that you might not be planning
to fetch the wh
I've been noticing query planning to be different for a cursor-based
select and normal select.
For example, my query looks like this:
=# SELECT
The query takes about 1/4 of a second.
But, for:
=# BEGIN;
=# DECLARE mycursor BINARY CURSOR FOR SELECT ;
=# FETCH ALL IN mycursor;
The same [SQL] q