| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Bruce Momjian" <bruce(at)momjian(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: COUNT(*) and index-only scans |
| Date: | 2011-10-10 19:18:23 |
| Message-ID: | 4E92FEAF0200002500041CF8@gw.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I think what Robert is complaining about is that we won't
> currently consider an index that matches neither any WHERE clauses
> nor ORDER BY, ie, count(*) over the whole table won't get
> considered for an index-only scan, regardless of cost estimates.
I guess the trick would be to get it to consider such plans only
under some conditions, to avoid explosive growth in planning time
for some types of queries. Some statistics bucket for the number of
non-frozen tuples in the relation, maybe?
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2011-10-10 19:25:31 | Re: Bug in walsender when calling out to do_pg_stop_backup (and others?) |
| Previous Message | Cédric Villemain | 2011-10-10 19:16:10 | table/index options | was: COUNT(*) and index-only scans |