pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David Siebert <david@eclipsecat.com>
To: pgsql-general@postgresql.org
Subject: Yet another indexing issue.
Date: Tue, 19 Mar 2002 13:40:51 -0500
Message-ID: <OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com> (raw)
In-Reply-To: <20020315101751.N51975-100000@megazone23.bigpanda.com>


I am having issues with an Index.
Here is the query

SELECT * FROM phonecalls WHERE istatus = 0 AND (sfor = 'pat' OR
sfor='TECHIES') ORDER BY ipri DESC, dplaceddate;
I have tried '0' and jut plain 0 as well as type casting it with ::int4 .

Here is the index I think it should use.

CREATE INDEX phonecallspoll ON phonecalls USING btree (sfor varchar_ops,
istatus int4_ops);
But it is still doing a scan?

Any suggestions?
yes I have used Vacumme with the anylise option.
Thanks for any info.




view thread (6+ messages)  latest in thread

Message-ID: <OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com>
Permalink:  ../OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com/
Also on:    postgresql.org/message-id/OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: david@eclipsecat.com, pgsql-general@postgresql.org
  Subject: Re: Yet another indexing issue.
  In-Reply-To: <OJEIJALIHAIBMMBFLCOBAENOEDAA.david@eclipsecat.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox