Re: Why no performance boost although I added an index?

Поиск
Список
Период
Сортировка
От nolan@celery.tssi.com
Тема Re: Why no performance boost although I added an index?
Дата
Msg-id 20030407230504.22084.qmail@celery.tssi.com
обсуждение исходный текст
Ответ на Why no performance boost although I added an index?  (Holger Marzen <holger@marzen.de>)
Список pgsql-general
> This is a really big lose if your index and table are on the same disk.

That implies there is an easy way to ensure that the index and table
aren't on the same disk.  That's not obvious from the documentation.

Maybe I just don't understand which subdirectories the data and index are
kept in?
--
Mike Nolan


В списке pgsql-general по дате отправления:

Предыдущее
От: "Dan Langille"
Дата:
Сообщение: Re: Why no performance boost although I added an index?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Backpatch FK changes to 7.3 and 7.2?