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:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 1:52 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
