Re: SELECT performance problem on a join

Поиск
Список
Период
Сортировка
От Patrice Espié
Тема Re: SELECT performance problem on a join
Дата
Msg-id 010401c0d2df$20c0a550$0400a8c0@univlyon2.fr
обсуждение исходный текст
Ответ на SELECT performance problem on a join  (Patrice Espié <patrice.espie@univ-lyon2.fr>)
Список pgsql-novice
>> >  2) Have you 'VACUUM ANALYZE t_test' and 'VACUUM ANALYZE doc' yet?
>> >Try #2, it should help you quite a bit.
>> I jsut did it : it said : VACUUM. Nothing else. This doesn't help me,
realy
>> ! ;)
>Have you tried your query since you VACUUM'ed?
>It helps a lot more than you would think.

Done. The problem has disapeared !!
Any explanation ?

Thank's a lot
Patrice


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

Предыдущее
От: Joel Burton
Дата:
Сообщение: Re: [PHP] psql with PHP question
Следующее
От: "Peter J. Schoenster"
Дата:
Сообщение: Re: input from a file