Re: Another idea for index-only scans - Mailing list pgsql-hackers

From James Mansion
Subject Re: Another idea for index-only scans
Date
Msg-id 46C6D5BE.2030100@mansionfamily.plus.com
Whole thread Raw
In response to Re: Another idea for index-only scans  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
Decibel! wrote:
> The advantage to Bruce's idea is that it sounds pretty simple to 
> implement. While it wouldn't be of use for many general cases, it 
> *would* be useful for read-only tables, ie: old partitions.

Wouldn't the mostcommon case by foreign key checks against tables that 
essentially map application enums to display strings?  This is a rather 
common scenario.  It would be nice if such tables (which are typically 
small) could be retained in each backend process with a simple check 
that the cached data is still valid.

James



pgsql-hackers by date:

Previous
From: "Trevor Talbot"
Date:
Subject: Re: tsearch2 in PostgreSQL 8.3?
Next
From: Gregory Stark
Date:
Subject: "It'd be better if there were not an implicit cast from int8 to text..."