Skip site navigation (1) Skip section navigation (2)

Re: Very slow queries

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: Very slow queries
Date: 2007-01-30 21:14:38
Message-ID: 45BFB53E.1040105@blackducksoftware.com (view raw or flat)
Thread:
Lists: pgsql-performance
What indexes do those tables have?  Any?

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


In response to

Responses

pgsql-performance by date

Next:From: Sidar López CruzDate: 2007-01-30 21:19:41
Subject: Re: Very slow queries
Previous:From: Sidar López CruzDate: 2007-01-30 21:09:23
Subject: Very slow queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group