Re: How to get RTREE performance from GIST index?

Поиск
Список
Период
Сортировка
От Clive Page
Тема Re: How to get RTREE performance from GIST index?
Дата
Msg-id 4B16CA2A.3070900@star.le.ac.uk
обсуждение исходный текст
Ответ на Re: How to get RTREE performance from GIST index?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: How to get RTREE performance from GIST index?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Список pgsql-general
Дерево обсуждения 
> Actually, autovacuum doesn't process temp tables at all because it
> cannot get to them; they might live solely in the creating process'
> private memory area.
>

Does that mean that, in between creating a temporary table and actually
using it in a complicate query, it is desirable to run an ANALYZE
command on it?

I haven't been doing that, because I didn't know.

Regards

--
Clive Page

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to get RTREE performance from GIST index?
Следующее
От: Tech 2010
Дата:
Сообщение: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227