Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is PostgreSQL 9.1 not using index for simple equality select - Mailing list pgsql-general

From John R Pierce
Subject Re: Why is PostgreSQL 9.1 not using index for simple equality select
Date
Msg-id 5167CCD1.5060801@hogranch.com
Whole thread Raw
In response to Re: Why is PostgreSQL 9.1 not using index for simple equality select  (Yang Zhang <yanghatespam@gmail.com>)
List pgsql-general
Tree view
On 4/12/2013 1:45 AM, Yang Zhang wrote:
db=> explain select * from lead where email = 'foo@blah.com';

can you try
explain analyze select * from lead where email = 'foo@blah.com';  
?


-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How to convert US date format to European date format ?
Next
From: Andres Freund
Date:
Subject: Re: Segmentation fault with core dump