Re: Migration study, step 2: rewriting queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>
Cc: "Pgsql performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Migration study, step 2: rewriting queries
Date: 2006-04-18 14:32:03
Message-ID: 13055.1145370723@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tarabas (Manuel Rorarius) 2006-04-18 14:35:13 Problem with LIKE-Performance
Previous Message Tom Lane 2006-04-18 14:30:58 Re: SELECT FOR UPDATE performance is bad