X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 99F4FB42166 for ; Wed, 9 Jul 2003 06:51:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 47243-07 for ; Wed, 9 Jul 2003 03:51:45 -0300 (ADT) Received: from ethereal-realms.org (thebe.ethereal-realms.org [142.179.222.205]) by svr1.postgresql.org (Postfix) with ESMTP id BCBBAB430A9 for ; Wed, 9 Jul 2003 03:51:44 -0300 (ADT) Received: from ethereal-realms.org (ip14.ethereal-realms.COM [192.168.1.14]) by ethereal-realms.org (8.12.6/8.12.6) with ESMTP id h696pjUc026528 for ; Wed, 9 Jul 2003 00:51:45 -0600 (MDT) Message-ID: <3F0BBB7E.6080008@ethereal-realms.org> Date: Wed, 09 Jul 2003 00:51:42 -0600 From: Martin Foster Organization: Ethereal Realms User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PostgreSQL Performance Subject: Re: Efficiency of timestamps References: <20030708215908.U8273-100000@megazone23.bigpanda.com> In-Reply-To: <20030708215908.U8273-100000@megazone23.bigpanda.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/152 X-Sequence-Number: 2445 Stephan Szabo wrote: > > Well, the reason I asked is to see both whether the estimates for the > various columns were somewhere near reality (if not, then you may need to > raise the statistics target for the column) which might affect whether > it'd consider using a multi-column index for the conditions and sort > rather than the index scan it was using. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster I'm going to have to pull out the 'Practical PostgreSQL' book and brush up on optimizing. This level of optimization is not something I have had to deal with in the past. Also to make this interesting. The sub-query method is faster at times and slower in others. But doing two separate queries and working on the PostIDNumber field exclusively is always blazingly fast... Martin Foster Creator/Designer Ethereal Realms martin@ethereal-realms.org