Skip site navigation (1) Skip section navigation (2)

Re: indexes make other queries slow!

From: Josh Berkus <josh(at)agliodbs(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:24:28
Message-ID: 200409161424.28644.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Qing,

> 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?

What's the rate of updates on the newly indexed tables?    If you have a lot 
of updates, the work that the database does to keep the indexes current would 
put a big load on your server.   This is far more likely to be the cause of 
your issues.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Jason CoeneDate: 2004-09-16 21:36:46
Subject: Re: indexes make other queries slow!
Previous:From: Qing ZhaoDate: 2004-09-16 21:20:29
Subject: indexes make other queries slow!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group