Re: AW: [HACKERS] Really slow query on 6.4.2
От | The Hermit Hacker |
---|---|
Тема | Re: AW: [HACKERS] Really slow query on 6.4.2 |
Дата | |
Msg-id | Pine.BSF.4.05.9903291436280.6652-100000@thelab.hub.org обсуждение исходный текст |
Ответ на | Re: AW: [HACKERS] Really slow query on 6.4.2 (geek+@cmu.edu) |
Ответы |
Re: AW: [HACKERS] Really slow query on 6.4.2
|
Список | pgsql-hackers |
On 25 Mar 1999 geek+@cmu.edu wrote: > 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. What I personally am not interested in is having to spend 20 minute per day with a totally locked up database because I want my queries to be faster, when there are other ways of doing it... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-hackers по дате отправления: