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

Re: Very slow queries

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 (view raw, whole thread or download thread mbox)
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?

TABLE ceroriesgo.patronos ADD CONSTRAINT patronos_pkey PRIMARY 

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 
>>  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 
>>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: 
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Have you searched our list archives?
>*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

Charla con tus amigos en línea mediante MSN Messenger:

In response to

pgsql-performance by date

Next:From: Chad WagnerDate: 2007-01-30 22:37:17
Subject: Re: Very slow queries
Previous:From: Ted AllenDate: 2007-01-30 21:14:38
Subject: Re: Very slow queries

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