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:23:48
Message-ID: 408F5C04.7020101@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I can understand the performance loss on non-selects for keeping the
> index validity state tracking the row validity, but would that outweigh the
> performance gains on selects? Depends on your mix of selects to non
> selects I guess, but other database systems seem to imply that keeping
> the index on track is worth it overall.

Yes, some sort of flag on index creation would be sweet :)

Chris

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2004-04-28 07:34:59 Re: planner/optimizer question
Previous Message Gary Doades 2004-04-28 07:08:03 Re: planner/optimizer question