From: | Sidar López Cruz <sidarlopez(at)hotmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | tallen(at)blackducksoftware(dot)com |
Subject: | Re: Very slow queries |
Date: | 2007-01-30 21:19:41 |
Message-ID: | BAY132-F115B53C5DBE5274BF8B1BECEA60@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>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/
From | Date | Subject | |
---|---|---|---|
Next Message | Chad Wagner | 2007-01-30 22:37:17 | Re: Very slow queries |
Previous Message | Ted Allen | 2007-01-30 21:14:38 | Re: Very slow queries |