Re: postgresql not using index even though it's faster - Mailing list pgsql-general

From Maksim Likharev
Subject Re: postgresql not using index even though it's faster
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A016D2DF8@mailc03.aurigin.com
Whole thread Raw
In response to postgresql not using index even though it's faster  (Rudy Koento <rudy_koento@yahoo.com>)
List pgsql-general
You mean
"My queries are slow or don't make use of the indexes. Why?"

may be better just fix that stone age requirement?

It just ridicules,
could statistic be build during index build, if no statistic available?


-----Original Message-----
From: Karsten Hilbert [mailto:Karsten.Hilbert@gmx.net]
Sent: Wednesday, August 27, 2003 1:52 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgresql not using index even though it's
faster


> Hi, I've created an index but it's not being used by
> postgresql when doing a query.  But doing an "explain
> analyze" shows that with index, it's faster.  Here's
> the output:

This sounds like someone needs to put a big fat link to
this FAQ item at the top of the PostgreSQL frontpage URL ?

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-general by date:

Previous
From: Alex
Date:
Subject: plpgsql , dynamic queries
Next
From: Al Hulaton
Date:
Subject: Re: Books for PostgreSQL?