On Thu, Jul 17, 2008 at 4:49 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: > I'm not big expert on optimizing Pg queries using indexes. Below > you'll find suggestions for some. > > But please run EXPLAIN for each query before creating any index and > after. Without explains we can not help you precisely, just guessing. > Also, please use some real constants in EXPLAIN, random strings and > numbers will generate plans far from reality.
Thanks for the guidance Ruslan, I'll see what I can find.. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
