X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 251C8D1D06F for ; Fri, 9 Apr 2004 12:02:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23290-07 for ; Fri, 9 Apr 2004 12:02:14 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5FFDAD1D078 for ; Fri, 9 Apr 2004 12:02:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i39F2CM7025870; Fri, 9 Apr 2004 11:02:12 -0400 (EDT) To: "Andrew Matthews" Cc: pgsql-performance@postgresql.org Subject: Re: Wierd issues In-reply-to: <79AEF92046759442A4AA04C2AB08C0B80834E2@exchange.corp.dslextreme.com> References: <79AEF92046759442A4AA04C2AB08C0B80834E2@exchange.corp.dslextreme.com> Comments: In-reply-to "Andrew Matthews" message dated "Mon, 05 Apr 2004 18:41:08 -0700" Date: Fri, 09 Apr 2004 11:02:11 -0400 Message-ID: <25869.1081522931@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/118 X-Sequence-Number: 6418 "Andrew Matthews" writes: > [ PG 7.3.4 much slower than 7.2.1 ] > > Both have same databases, Both have had vacume full ran on them. You did ANALYZE too, right? The bulk of the time is evidently going into the seqscan on users in each case: > -> Seq Scan on users u (cost=0.00..1938.51 rows=71283 width=4) (actual time=0.81..30119.58 rows=70809 loops=1) > -> Seq Scan on users u (cost=0.00..1888.85 rows=71548 width=4) (actual time=18.38..2277152.51 rows=71028 loops=1) > Filter: (get_pwd(username, '127.0.0.1'::character varying, '101'::character varying, 'MD5'::character varying) IS NOT NULL) I have to suspect that the inefficiency is inside this get_pwd() function, but you didn't tell us anything about that... regards, tom lane