Re: AW: [HACKERS] Really slow query on 6.4.2

Поиск
Список
Период
Сортировка
От geek+@cmu.edu
Тема Re: AW: [HACKERS] Really slow query on 6.4.2
Дата
Msg-id emacs-smtp-2711-14074-42096-361803@export.andrew.cmu.edu
обсуждение исходный текст
Ответ на Re: AW: [HACKERS] Really slow query on 6.4.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: AW: [HACKERS] Really slow query on 6.4.2  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
Then <tgl@sss.pgh.pa.us> spoke up and said:
> I'm not convinced that accurate stats are worth that cost, but I don't
> know how big the cost would be anyway.  Anyone have a feel for it?

They are definitely *not* worth the cost.  Especially since no table
will have the default 0 rows entry after a single vacuum analyze of
that table.  Let's be honest: if you aren't interested in doing a
vacuum, then really aren't interested in performance, anyway.

-- 
=====================================================================
| JAVA must have been developed in the wilds of West Virginia.      |
| After all, why else would it support only single inheritance??    |
=====================================================================
| Finger geek@cmu.edu for my public key.                            |
=====================================================================

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

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: [HACKERS] PostgreSQL LOGO (was: Developers Globe (FINAL))
Следующее
От: jwieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [HACKERS] PostgreSQL LOGO (was: Developers Globe (FINAL))