RE: [HACKERS] Re: vacuum slowness

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: [HACKERS] Re: vacuum slowness
Дата
Msg-id 000201be7118$119fed40$2801007e@cadzone.tpf.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: vacuum slowness  (Vadim Mikheev <vadim@krs.ru>)
Список pgsql-hackers

> -----Original Message-----
> From: owner-pgsql-hackers@postgreSQL.org
> [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Vadim Mikheev
> Sent: Thursday, March 18, 1999 2:07 PM
> To: Bruce Momjian
> Cc: hackers@postgreSQL.org
> Subject: Re: [HACKERS] Re: vacuum slowness
> 
> 
> Bruce Momjian wrote:
> > 
> > >
> > > Indices?
> > 
> > Yes.  That seems to be the problem.  45k lines, COPY is fast, DELETE is
> > fast if there are no indexes.  With an index, it takes a long time.
> > Bummer.  Ideas?
> 
> I hope to implement space re-using and address vacuum slowness
> in 6.6
>

We would be able to vacuum without blocking same-table writers in v6.5 ?
Or would VACUUM block same-table readers as VACUUM does currently ?
Thanks.

Hiroshi Inoue
Inoue@tpf.co.jp


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

Предыдущее
От: Clark Evans
Дата:
Сообщение: Re: [HACKERS] Re: vacuum slowness
Следующее
От: jwieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [HACKERS] One more globe