Re: postgresql not using index even though it's faster

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(dot)Hilbert(at)gmx(dot)net]
Sent: Wednesday, August 27, 2003 1:52 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)