From: Sidar López Cruz <sidarlopez@hotmail.com>
To: pgsql-performance@postgresql.org
Cc: chad.wagner@gmail.com
Subject: Re: Very slow queries
Date: Wed, 31 Jan 2007 08:19:41 -0600
Message-ID: <BAY132-F1209F4D7B2DF92759FA080CEA50@phx.gbl> (raw)
In-Reply-To: <81961ff50701301437t60c5370bvdf165215cbeaeb25@mail.gmail.com>
>From: "Chad Wagner" <chad.wagner@gmail.com>
>To: "Sidar López Cruz" <sidarlopez@hotmail.com>
>CC: pgsql-performance@postgresql.org
>Subject: Re: [PERFORM] Very slow queries
>Date: Tue, 30 Jan 2007 17:37:17 -0500
>
>On 1/30/07, Sidar López Cruz <sidarlopez@hotmail.com> wrote:
>>
>>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)
>>
>
>How many rows exist in salarios, but not in patronos? How many rows are
>there in salarios?
Rows:
Patronos: 1032980
Salarios: 28480200
>
>What does the explain look like for:
>
>delete
>from ceroriesgo.salarios s
>where not exists (select 1
> from ceroriesgo.patronos
> where numero_patrono = s.numero_patrono);
>
>Also, is this not a case for a foreign key with a cascade delete?
No, this is not cascade delete case because I need to delete from salarios
not from patronos.
>http://www.postgresql.org/docs/8.2/static/ddl-constraints.html
>
>
>--
>Chad
>http://www.postgresqlforums.com/
_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.latam.msn.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sidarlopez@hotmail.com, chad.wagner@gmail.com
Subject: Re: Very slow queries
In-Reply-To: <BAY132-F1209F4D7B2DF92759FA080CEA50@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox