Re: planner/optimizer question - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: planner/optimizer question
Date
Msg-id 408F5C04.7020101@familyhealth.com.au
Whole thread Raw
In response to Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
List 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


pgsql-performance by date:

Previous
From: "Gary Doades"
Date:
Subject: Re: planner/optimizer question
Next
From: Manfred Koizar
Date:
Subject: Re: planner/optimizer question