Skip site navigation (1) Skip section navigation (2)

Re: Tuning single row operations

From: Matthew O'Connor <matthew(at)zeut(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tuning single row operations
Date: 2006-12-21 14:36:05
Message-ID: 458A9BD5.8030602@zeut.net (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group