RE: [HACKERS] Re: vacuum slowness - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: [HACKERS] Re: vacuum slowness
Date
Msg-id 000201be7118$119fed40$2801007e@cadzone.tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] Re: vacuum slowness  (Vadim Mikheev <vadim@krs.ru>)
List 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 by date:

Previous
From: Clark Evans
Date:
Subject: Re: [HACKERS] Re: vacuum slowness
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] One more globe