X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C984DAA6C for ; Wed, 26 Oct 2005 01:26:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49384-05 for ; Wed, 26 Oct 2005 04:26:44 +0000 (GMT) Received: from hotmail.com (bay23-f12.bay23.hotmail.com [64.4.22.62]) by svr1.postgresql.org (Postfix) with ESMTP id 554D4DA262 for ; Wed, 26 Oct 2005 01:26:44 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 25 Oct 2005 21:26:43 -0700 Message-ID: Received: from 196.40.10.254 by by23fd.bay23.hotmail.msn.com with HTTP; Wed, 26 Oct 2005 04:26:43 GMT X-Originating-IP: [196.40.10.254] X-Originating-Email: [sidarlopez@hotmail.com] X-Sender: sidarlopez@hotmail.com From: =?iso-8859-1?B?U2lkYXIgTPNwZXogQ3J1eg==?= To: pgsql-performance@postgresql.org Subject: zero performance on query Date: Tue, 25 Oct 2005 22:26:43 -0600 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 26 Oct 2005 04:26:43.0695 (UTC) FILETIME=[782E0FF0:01C5D9E5] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.369 required=5 tests=[AWL=-0.381, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/379 X-Sequence-Number: 15147 what happend with postgresql 8.1b4 performance on query? please help me !!! look at this: select count(*) from fotos where archivo not in (select archivo from archivos) Aggregate (cost=4899037992.36..4899037992.37 rows=1 width=0) -> Seq Scan on fotos (cost=22598.78..4899037338.07 rows=261716 width=0) Filter: (NOT (subplan)) SubPlan -> Materialize (cost=22598.78..39304.22 rows=805344 width=58) -> Seq Scan on archivos (cost=0.00..13141.44 rows=805344 width=58) I WILL DIE WAITING FOR QUERY RESPONSE !!! -- CREATE TABLE archivos ( archivo varchar(20)) WITHOUT OIDS; CREATE INDEX archivos_archivo_idx ON archivos USING btree(archivo); ~800000 rows -- CREATE TABLE fotos ( cedula varchar(20), nombre varchar(100), apellido1 varchar(100), apellido2 varchar(100), archivo varchar(20) ) WITHOUT OIDS; CREATE INDEX fotos_archivo_idx ON fotos USING btree (archivo); CREATE INDEX fotos_cedula_idx ON fotos USING btree (cedula); ~500000 rows _________________________________________________________________ Consigue aquí las mejores y mas recientes ofertas de trabajo en América Latina y USA: http://latam.msn.com/empleos/