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

Re: planner/optimizer question

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: planner/optimizer question
Date: 2004-04-28 07:04:14
Message-ID: 408F576E.1080504@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
> Why is there an entry in the index for a row if the row is not valid? 
> Wouldn't it be better for the index entry validity to track the row validity. 
> If a particular data value for a query (join, where etc.) can be satisfied 
> by the index entry itself this would be a big performance gain.

For SELECTs, yes - but for INSERT, UPDATE and DELETE it would be a big 
performance loss.

Chris


In response to

Responses

pgsql-performance by date

Next:From: Gary DoadesDate: 2004-04-28 07:08:03
Subject: Re: planner/optimizer question
Previous:From: Gary DoadesDate: 2004-04-28 06:35:41
Subject: Re: planner/optimizer question

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