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

Very slow queries

From: Sidar López Cruz <sidarlopez(at)hotmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Very slow queries
Date: 2007-01-30 21:09:23
Message-ID: BAY132-F4C49B88EDFA35EDBBD618CEA60@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-performance
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/


Responses

pgsql-performance by date

Next:From: Ted AllenDate: 2007-01-30 21:14:38
Subject: Re: Very slow queries
Previous:From: Alvaro HerreraDate: 2007-01-30 21:03:03
Subject: Re: Querying distinct values from a large table

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