[Rt-devel] Redundant Postgres indexes

[Vivek Khera]

On Oct 6, 2004, at 11:48 AM, Andrew Snare wrote:

> I'm in the middle of migrating from RT 3.0.10 to 3.2.2 as well as from
> postgres 7.3 to 7.4. While doing this, I noticed that there appear to 
> be
>

See the list archives for my alternate set of indexes, which I came to 
by profiling the queries RT actually does.  There are some indexes for 
which I see no evidence of ever being used.

Also you can use Pg's own stat collector to see how often the various 
indexes get used.  That's my next step to see if I need to remove more 
indexes or adjust some.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2476 bytes
Desc: not available
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20041006/8f489838/smime.bin