> 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])