[rt-users] Performance Issues after 3.8.0 upgrade -- PostgreSQL delays

Jessie Bryan jessie.bryan at gmail.com
Thu Jul 17 19:55:31 EDT 2008


On Thu, Jul 17, 2008 at 4:49 PM, Ruslan Zakirov <ruz at bestpractical.com> 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..



More information about the rt-users mailing list