Re: Performance Expectations

Поиск
Список
Период
Сортировка
От Derek Hamilton
Тема Re: Performance Expectations
Дата
Msg-id 000401c305e4$7aaa2840$1b01a8c0@jcaves.net
обсуждение исходный текст
Ответ на Performance Expectations  ("Derek Hamilton" <derek@capweb.com>)
Ответы Re: Performance Expectations  (Bruno Wolff III <bruno@wolff.to>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Biagioni
Дата:
Сообщение: Re: How does PG know when a database is being accessed ?
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Performance Expectations