Re: Performance Expectations - Mailing list pgsql-admin

From Derek Hamilton
Subject Re: Performance Expectations
Date
Msg-id 000401c305e4$7aaa2840$1b01a8c0@jcaves.net
Whole thread Raw
In response to Performance Expectations  ("Derek Hamilton" <derek@capweb.com>)
Responses Re: Performance Expectations  (Bruno Wolff III <bruno@wolff.to>)
List 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.
>


pgsql-admin by date:

Previous
From: Andrew Biagioni
Date:
Subject: Re: How does PG know when a database is being accessed ?
Next
From: Bruno Wolff III
Date:
Subject: Re: Performance Expectations