Index-only quals
in [PgSql]
|
From: Bruce Momjian on 23 Feb 2010 12:11 I added this URL to the existing TODO item. --------------------------------------------------------------------------- Heikki Linnakangas wrote: > Here is an updated version of my patch to return data from b-tree > indexes, and use it to satisfy quals. > > I added a new column 'amregurgitate' to pg_am, to mark which indexams > can return index tuples. Also, the data type of the index column in > pg_attribute must match the type of the heap column - this catches the > hack that 'name' is stored as cstring, that I had hardcoded before. > > As discussed, GiST/GIN would need more infrastructure to mark which > opclasses can return tuples, but as long as GiST/GIN doesn't support > regurgitation at all, I'm not going to complicate the catalogs with that. > > There's also some planner fixes - indexes that are only useful because > of index-only quals are not considered for bitmap scans, and volatile > expressions mustn't be used as index-only quals. > > > This patch comes in two parts. Indexam API changes, which just splits > the indexam_getnext function into two without providing any new > functionality, and the main patch that applies on top of the indexam API > changes. The patches are also available at > git://git.postgresql.org/git/users/heikki/postgres.git, branches > 'indexam-api-changes and 'indexfilter'. > > Barring objections, I'm going to apply the indexam API changes part, > since that simplifies the code in question regardless of the rest of the > work. I'm pretty happy now with the indexfilter patch as well, but want > to do some more testing on that before committing. Some more eyeballs > would be appreciated as well. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
|
Pages: 1 Prev: tie user processes to postmaster Next: [HACKERS] pg_stop_backup does not complete |