Re: Very slow queries

[Sidar López Cruz <sidarlopez(at)hotmail(dot)com>]

> From: Ted Allen <tallen(at)blackducksoftware(dot)com>
> To: Sidar López Cruz <sidarlopez(at)hotmail(dot)com>
> CC: pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] Very slow queries
> Date: Tue, 30 Jan 2007 16:14:38 -0500


> What indexes do those tables have?  Any?

Yes:
TABLE ceroriesgo.patronos ADD CONSTRAINT patronos_pkey PRIMARY 
KEY(numero_patrono);

INDEX salarios_numero_patrono_idx  ON ceroriesgo.salarios
 USING btree (numero_patrono);



> Sidar López Cruz wrote:
> > Check this:
> >
> > query: Delete From ceroriesgo.salarios Where numero_patrono Not In (Select 
> > numero_patrono From ceroriesgo.patronos)
> >
> > Seq Scan on salarios  (cost=51021.78..298803854359.95 rows=14240077 
> > width=6)
> >  Filter: (NOT (subplan))
> >  SubPlan
> >    ->  Materialize  (cost=51021.78..69422.58 rows=1032980 width=25)
> >          ->  Seq Scan on patronos  (cost=0.00..41917.80 rows=1032980 
> > width=25)
> >
> >
> > These query took a day to finish, how or who can improove better 
> > performance of my PostgreSQL.
> >
> > _________________________________________________________________
> > Charla con tus amigos en línea mediante MSN Messenger: 
> > http://messenger.latam.msn.com/
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> >               http://archives.postgresql.org
>
>
> --
>
> *Edward Allen*
> Software Engineer
> Black Duck Software, Inc.
>
> tallen(at)blackducksoftware(dot)com <mailto:tallen(at)blackducksoftware(dot)com>
> T +1.781.891.5100 x133
> F +1.781.891.5145
> http://www.blackducksoftware.com

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.latam.msn.com/