Re: [Fwd: Re: [PERFORM] Performance problem with Sarge compared

2006-09-12 Thread Alvaro Herrera
Piñeiro wrote: > El mar, 12-09-2006 a las 11:20 -0500, Scott Marlowe escribió: > > As Tom asked, post the explain analyze output for this query. I'm > > guessing there'll be a stage that is creating millions (possibly upon > > millions) of rows from a cross product. > > > Well, yes, it is a frie

Re: [Fwd: Re: [PERFORM] Performance problem with Sarge compared

2006-09-12 Thread Dave Dutcher
> From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Piñeiro > > TIP 6: explain analyze is your friend > Well, yes, it is a friend, but as the select at postgre Sarge version > never finished I can't use a explain analyze. I show you the explain, > with the hope that someone has an

Re: [Fwd: Re: [PERFORM] Performance problem with Sarge compared

2006-09-12 Thread Piñeiro
El mar, 12-09-2006 a las 11:20 -0500, Scott Marlowe escribió: > As Tom asked, post the explain analyze output for this query. I'm > guessing there'll be a stage that is creating millions (possibly upon > millions) of rows from a cross product. > > ---(end of broadcast)

Re: [Fwd: Re: [PERFORM] Performance problem with Sarge compared

2006-09-12 Thread Scott Marlowe
On Tue, 2006-09-12 at 11:06, Piñeiro wrote: > - Mensaje reenviado > De: Piñeiro <[EMAIL PROTECTED]> > Para: Scott Marlowe <[EMAIL PROTECTED]> > Asunto: Re: [PERFORM] Performance problem with Sarge compared with Woody > Fecha: Tue, 12 Sep 2006 17:36:41 +0200 > El mar, 12-09-2006 a l