Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page
Дата
Msg-id Pine.NEB.3.95.980203143032.14960l-100000@hub.org
обсуждение исходный текст
Ответы Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page
Список pgsql-hackers
On Tue, 3 Feb 1998, Bruce Momjian wrote:

> > > This is correct.  Vacuum is fast, vacuum analyze is pretty slow.  We
> > > could separate them, I guess, and that would eliminate the write-lock
> > > and be only a readlock.
> >
> >     Possible to slip it in for v6.3?  Would make it so that an analyze
> > could be done nightly, to keep statistics up, and then a vacuum once a
> > week or so just for garbage collection...?
>
> When I added analyze, I did not understand the issues, so I was able to
> work from Vadim's code in vacuum.  I put it on the TODO list.  Don't
> know if it can make 6.3.  I am working on cleaning up the cacheoffset
> code right now.

    Okay...personally, I'm finding 'vacuum <table>' an acceptable work
around, so it isn't too big of a priority :)



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] VACUUM ANALYZE Problem
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] subquery syntax broken