Re: Optimizing a read-only database

Поиск
Список
Период
Сортировка
От hari.fuchs@gmail.com
Тема Re: Optimizing a read-only database
Дата
Msg-id 87vbfpj891.fsf@hf.protecting.net
обсуждение исходный текст
Ответ на Optimizing a read-only database  (François Battail <francois.battail@sipibox.fr>)
Список pgsql-general
François Battail <francois.battail@sipibox.fr> writes:

> My bad, got it. May be interesting but as I have a lot of indexes it
> will be hard to test and to choose the best candidate. No idea of how
> it can affect EWKB data indexed by a GiST (PostGIS) index, but it's
> something to try just to know.

You could also raise the statistics target and re-analyze.  This will
take some time, but then your query plans might be better.

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

Предыдущее
От: Geoff Montee
Дата:
Сообщение: Re: SQL Server access from PostgreSQL
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Documentation bug?