ot;outer".codigoreparacion = "inner".codigoreparacion) AND
("outer".codigoempresa = "inner".codigoempresa) AND
("outer".codigotienda = "inner".codigotienda))
-> Index Scan using codigosiniestro_pk on siniestro
(cost=0.00..3638.2
Sorry I answer the message only to Scott Marlowe. I re-send the response
- 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
4.2 there are more indices, or there was duplicated indices
with the woody version too?
(before you comment this: yes I try to remove the duplicate indices to
check if this was the problem)
--
Piñeiro <[EMAIL PROTECTED]>
---(end of broadcast)
codigobanco, pago.codigooficina, pago.numerocuenta,
pago.esAPlazos,pago.pagosRealizados,pago.numeroVencimientos,pago.fechainicio,
pago.esdomiciliacion order by
participantecompany.nombre,facturaabono.numeroFactura);
Any idea ?
--
Piñeiro <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
