| From: | PFC <lists(at)peufeu(dot)com> |
|---|---|
| To: | "Hannu Krosing" <hannu(at)krosing(dot)net>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
| Cc: | "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Free Space Map data structure |
| Date: | 2008-04-09 22:36:41 |
| Message-ID: | op.t9c7rfkhcigqcu@apollo13.peufeu.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
About the FSM :
Would it be possible to add a flag marking pages where all tuples are
visible to all transactions ? (kinda like frozen I think)
This could be useful to implement index-only scans, for count(), or to
quickly skip rows when OFFSET is used, or to use only the index when the
selected columns are all in the index. Of course if the page is flagged as
"may contain updated tuples", then it would have to look in the heap. But,
for tables that are not randomly updated (for instance tables that are
mostly appended to, like forum posts, or logs, or the huge archive table,
etc) it could save a lot of heap lookups and IO.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-04-09 23:03:22 | Re: Commit fest queue |
| Previous Message | Guillaume Smet | 2008-04-09 21:10:37 | Re: jaguar is failing |