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 по дате отправления: