X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FD023A3B61 for ; Fri, 5 Nov 2004 07:16:25 +0000 (GMT) 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 85600-01 for ; Fri, 5 Nov 2004 07:16:21 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.200]) by svr1.postgresql.org (Postfix) with ESMTP id 01E063A3B2D for ; Fri, 5 Nov 2004 07:16:21 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id a41so23570rng for ; Thu, 04 Nov 2004 23:16:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=JRt2n8iXT6GOxihPlH7jhqb0qBnZ+L+c7DfOUT8HS5S2KUP/hdeGZ7xzmvPWmwOW2ZBYem46Pq48x5o2ta6pxr1KHdlwlzNXHxWbZH9Eos8p8p7UJhwZZoWaaSJkYQaoxNeUy3YXa8IGNqCJmIxBqc7GjaNAAr4NeSkrYJI9E08= Received: by 10.38.152.67 with SMTP id z67mr134293rnd; Thu, 04 Nov 2004 23:16:20 -0800 (PST) Received: by 10.38.149.52 with HTTP; Thu, 4 Nov 2004 23:16:20 -0800 (PST) Message-ID: <2989532e0411042316566b35f4@mail.gmail.com> Date: Fri, 5 Nov 2004 12:46:20 +0530 From: Antony Paul Reply-To: Antony Paul To: pgsql-performance@postgresql.org Subject: Checking = with timestamp field is slow Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200411/86 X-Sequence-Number: 9040 Hi all, I have a table which have more than 200000 records. I need to get the records which matches like this where today::date = '2004-11-05'; This is the only condition in the query. There is a btree index on the column today. Is there any way to optimise it. rgds Antony Paul