Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9EDE79FB451 for ; Tue, 30 Jan 2007 17:46:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 48667-06 for ; Tue, 30 Jan 2007 17:46:07 -0400 (AST) X-Greylist: delayed 00:31:29.367364 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6801F9FB412 for ; Tue, 30 Jan 2007 17:46:06 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp.blackducksoftware.com (nat.blackducksoftware.com [216.195.218.91]) by svr4.postgresql.org (Postfix) with ESMTP id 0756E5AF88C for ; Tue, 30 Jan 2007 21:14:35 +0000 (GMT) Received: from localhost (gyro.blackducksoftware.com [127.0.0.1]) by smtp.blackducksoftware.com (Postfix) with ESMTP id E24485C4276; Tue, 30 Jan 2007 16:15:12 -0500 (EST) Received: from smtp.blackducksoftware.com ([127.0.0.1]) by localhost (gyro.blackducksoftware.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15325-09; Tue, 30 Jan 2007 16:15:12 -0500 (EST) Received: from [10.12.14.31] (tallen.blackducksoftware.com [10.12.14.31]) by smtp.blackducksoftware.com (Postfix) with ESMTP id 0BB735C415B; Tue, 30 Jan 2007 16:15:12 -0500 (EST) Message-ID: <45BFB53E.1040105@blackducksoftware.com> Date: Tue, 30 Jan 2007 16:14:38 -0500 From: Ted Allen User-Agent: Thunderbird 1.5.0.9 (X11/20070104) MIME-Version: 1.0 To: =?ISO-8859-1?Q?Sidar_L=F3pez_Cruz?= Cc: pgsql-performance@postgresql.org Subject: Re: Very slow queries References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Debian amavisd-new at blackducksoftware.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/437 X-Sequence-Number: 23038 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@blackducksoftware.com T +1.781.891.5100 x133 F +1.781.891.5145 http://www.blackducksoftware.com