sql indexing suggestions needed

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: sql indexing suggestions needed
Date: 2007-03-20 18:54:29
Message-ID: 18D56075-0023-4B77-A256-813FD552F749@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i'm going crazy trying to optimize this select.

The table has ~25 columns, the select is based on 10. There are
approx 5 million records in the table and growing.

No matter how I index + analyze this table, including making an index
of every related column on the search, pg keeps doing a sequential
scan and never includes an index -- which takes ~2minutes to do. I
really need to cut this down.

SELECT
*
FROM
table_a
WHERE
( bool_a = False )
AND
( bool_b= False )
AND
( int_c IS NOT NULL )
AND
( int_c <= 10 )
AND
( bool_d = False )
AND
( bool_e= True )
AND
( timestamp_f IS NULL )
AND
( bool_g IS False )
AND
( int_h= 1 )
AND
( bool_i = False )
ORDER BY
id ASC
LIMIT 100

can anyone suggest an indexing approach that might get pg to use the
indexes ? this is driving me crazy.

thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Arai 2007-03-20 19:10:00 Re: sql indexing suggestions needed
Previous Message Bob Pawley 2007-03-20 18:41:50 Postgresql to Delphi