| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | gincostestimate |
| Date: | 2010-07-02 12:33:31 |
| Message-ID: | 4C2DDC9B.1060908@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Patch implements much more accuracy estimation of cost for GIN index scan than
generic cost estimation function. Basic idea is described on PGCon-2010:
http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf, pages 48-54.
After discussion on PGCon, the storage of additional statistic information has
been changed from pg_class table to meta-page of index. Statistics data is
cached in Relation->rd_amcache to prevent frequent read of meta-page.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| Attachment | Content-Type | Size |
|---|---|---|
| gincostestimate-0.19.gz | application/x-tar | 8.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Fowler | 2010-07-02 13:07:15 | Re: Issue: Deprecation of the XML2 module 'xml_is_well_formed' function |
| Previous Message | Andrew Dunstan | 2010-07-02 12:10:25 | Re: pgsql: Allow copydir() to be interrupted. |