Re: Migration study, step 2: rewriting queries - Mailing list pgsql-performance

From Tom Lane
Subject Re: Migration study, step 2: rewriting queries
Date
Msg-id 13055.1145370723@sss.pgh.pa.us
Whole thread Raw
In response to Re: Migration study, step 2: rewriting queries  ("Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com>)
List pgsql-performance
"Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com> writes:
> Ok, cool. I don't have time to test this right now as the project has to
> move on (and I guess testing the fix would require a dump+build CVS
> version+restore), but as a temporary workaround I simly dropped the
> xda_dat index (all queries on that table include the
> person_information__id column anyway).

The patch is in the 8.1 branch so you don't need dump/restore anyway...

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT FOR UPDATE performance is bad
Next
From: "Tarabas (Manuel Rorarius)"
Date:
Subject: Problem with LIKE-Performance