X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E4F78DA93A for ; Tue, 25 Oct 2005 20:31:22 -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 67443-08 for ; Tue, 25 Oct 2005 23:31:17 +0000 (GMT) Received: from hotmail.com (bay23-f7.bay23.hotmail.com [64.4.22.57]) by svr1.postgresql.org (Postfix) with ESMTP id 59067DAE9C for ; Tue, 25 Oct 2005 20:31:19 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 25 Oct 2005 16:31:22 -0700 Message-ID: Received: from 196.40.18.42 by by23fd.bay23.hotmail.msn.com with HTTP; Tue, 25 Oct 2005 23:31:22 GMT X-Originating-IP: [196.40.18.42] X-Originating-Email: [sidarlopez@hotmail.com] X-Sender: sidarlopez@hotmail.com From: =?iso-8859-1?B?U2lkYXIgTPNwZXogQ3J1eg==?= To: pgsql-admin@postgresql.org Subject: zero performance on query Date: Tue, 25 Oct 2005 17:31:22 -0600 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 25 Oct 2005 23:31:22.0668 (UTC) FILETIME=[359FEEC0:01C5D9BC] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.335 required=5 tests=[AWL=-0.415, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/271 X-Sequence-Number: 19343 what happend with postgresql 8.1b4 performance on query? 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 _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.latam.msn.com/