From: | evgeny gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Planner statistics vs. count(*) |
Date: | 2005-09-20 18:12:55 |
Message-ID: | 20050920221255.2c32b87b.eugrid@fpm.kubsu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi Everybody.
I am going to replace some 'select count(*) from ... where ...' queries
which run on large tables (10M+ rows) with something like
'explain select * from ... where ....' and parse planner output after that
to find out its forecast about number of rows the query is going to retrieve.
Since my users do not need exact row count for large tables, this will
boost performance for my application. I ran some queries with explain and
explain analyze then. If i set statistics number for the table about 200-300
the planner forecast seems to be working very fine.
My questions are:
1. Is there a way to interact with postgresql planner, other than 'explain ...'? An aggregate query like 'select estimate_count(*) from ...' would really help =))
2. How precise is the planner row count forecast given for a complex query (select with 3-5 joint tables,aggregates,subselects, etc...)?
--
Evgeny Gridasov
Software Developer
I-Free, Russia
From | Date | Subject | |
---|---|---|---|
Next Message | Bricklen Anderson | 2005-09-20 18:29:31 | Re: Planner statistics vs. count(*) |
Previous Message | evgeny gridasov | 2005-09-20 16:02:10 | Re: RAID Stripe size |