pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Qing Zhao <qzhao@supplyfx.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Question about PG on OSX
Date: Thu, 16 Sep 2004 14:05:28 -0700
Message-ID: <200409161405.28778.josh@agliodbs.com> (raw)
In-Reply-To: <224B107D-0821-11D9-B278-000A95AB8896@supplyfx.com>
References: <200409161050.33289.josh@agliodbs.com>
	<200409161200.32427.josh@agliodbs.com>
	<224B107D-0821-11D9-B278-000A95AB8896@supplyfx.com>

Qing,

Please don't start a new question by replying to someone else's e-mail.   It 
confuses people and makes it unlikely for you to get help.

> My suspicion is that since  now a few indexes are added, every ops are
> run by PostgreSQL with the indexes being used when calculating cost.
> This leads to the downgrade of performance.

That seems rather unlikely to me.    Unless you've *really* complex queries 
and some unusual settings, you can't swamp the CPU through query planning.    

On the other hand, your mention of REINDEX indicates that the table is being 
updated very frequently.   If that's the case, then the solution is probably 
for you to cut back on the number of indexes.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



Message-ID: <200409161405.28778.josh@agliodbs.com>
Permalink:  ../200409161405.28778.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200409161405.28778.josh@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com, qzhao@supplyfx.com
  Subject: Re: Question about PG on OSX
  In-Reply-To: <200409161405.28778.josh@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox