Re: Performance Expectations

From: "Derek Hamilton" <derek(at)capweb(dot)com>
To: "Marc Mitchell" <marcm(at)eisolution(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Performance Expectations
Date: 2003-04-18 19:55:35
Message-ID: 000401c305e4$7aaa2840$1b01a8c0@jcaves.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey Marc,

I've run the EXPLAIN statement on the query and it does use the index.

I also use an "order by" on the table that does not include the indexed
field. Would adding an index for the fields I'm ordering by help at all?

Thanks,
Derek

> I would suggest simply doing an EXPLAIN on your query and examining the
> output. It will tell you whether your index is being used or not. That's
> a big first step in determining what your optimal performance expectations
> should be.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2003-04-18 20:05:51 Re: Performance Expectations
Previous Message Andrew Biagioni 2003-04-18 19:07:34 Re: How does PG know when a database is being accessed ?