In article <[EMAIL PROTECTED]>, Dawid Kuroczko <[EMAIL PROTECTED]> writes:
> Use > EXPLAIN SELECT * FROM yourcountedtable; > Planner seems to track estimated statistics on-the-fly. :) > You can even wrap EXPLAIN SELECT in a pgsql function if you > need it. Do you know how to do that? A function "approx_count(tablename)" would be really handy, but FOR row IN EXECUTE 'EXPLAIN SELECT * FROM ' || tbl LOOP fails with the following message: ERROR: cannot open non-SELECT query as cursor > PS: And be aware that these are 'statistics'. And the statement that there > are lies, big lies and statistics is sometimes true even for PostgreSQL. ;-) Does this mean that PostgreSQL believes only in statistics it has faked itself? ;-) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
