Richard Huxton wrote:
> Simon Riggs wrote:
>> - improve RI check perf by caching small, static tables in each backend
>> - apply index filter conditions on index scan to avoid heap lookup
> 
> For fkey checks against a basically static table could you get away with 
> just checking the index and not the table?

I'm not sure that would fly, there is always the possibility it could 
change, I think the ENUMs patch will solve this performance problem.

In response to

• Re: Tuning single row operations at 2006-12-21 14:08:00 from Richard Huxton

Responses

• Re: Tuning single row operations at 2006-12-21 14:56:30 from Simon Riggs

pgsql-hackers by date

Next:	From: Zeugswetter Andreas ADI SD	Date: 2006-12-21 14:39:07
	Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2
Previous:	From: Matthew O'Connor	Date: 2006-12-21 14:30:06
	Subject: Re: Interface for pg_autovacuum