| From: | "Jason Coene" <jcoene(at)gotfrag(dot)com> |
|---|---|
| To: | "'Qing Zhao'" <qzhao(at)supplyfx(dot)com> |
| Cc: | "'Postgresql Performance'" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: indexes make other queries slow! |
| Date: | 2004-09-16 21:36:46 |
| Message-ID: | 200409162136.i8GLagv2015192@ms-smtp-03.nyroc.rr.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> My guess is that all the queries that involves the columns that are
> being indexed need to
> be rewritten to use the newly created indexes to avoid the performance
> issues. The reason
> is that REINDEX does not help either. Does it make sense?
>
Qing,
Generally, adding new indexes blindly will hurt performance, not help it.
More indexes mean more work during INSERT/UPDATE. That could easily be
hampering your performance if you have a high INSERT/UPDATE volume.
Run your queries through EXPLAIN ANALYZE to make sure they're using the
right indexes. Take a look at the pg_stat_user_indexes table to see what
indexes are simply not being used.
Jason
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J. Andrew Rogers | 2004-09-16 21:59:12 | Re: Partitioning |
| Previous Message | Josh Berkus | 2004-09-16 21:24:28 | Re: indexes make other queries slow! |