Skip site navigation (1) Skip section navigation (2)

Re: [PORTS] vacuum takes too long

From: David Wetzel <dave(at)turbocat(dot)de>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: ports(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org
Subject: Re: [PORTS] vacuum takes too long
Date: 1999-01-06 22:38:29
Message-ID: 199901062238.XAA03489@cat.turbocat.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-ports
> From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>

> > insert a few row in a table (>50000) and do
> > delete from mytable;
> > vacuum verbose  analyze;
> >
> > Why is this that slow?
>
> Analyze checks every column in every row.

even if you only type "vacuum verbose" it takes _very_ long.

I deleted _all_ records with "delete from mytable;" before.
A drop and a new create is faster. But what is when you delete (maybe  
100000) rows but keep 100 in the table?

I use 6.4.2 on NetBSD/i486 (that box makes gets 12MBytes/sec via the  
filesystem out of the drives)
---
   _  _
 _(_)(_)_  David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
  _/  \_   Fax +49 33056 82835 NeXTmail dave(at)turbocat(dot)de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION

In response to

Responses

pgsql-ports by date

Next:From: Bruce MomjianDate: 1999-01-07 00:50:37
Subject: Re: [PORTS] vacuum takes too long
Previous:From: Bruce MomjianDate: 1999-01-06 21:02:33
Subject: Re: [PORTS] vacuum takes too long

pgsql-hackers by date

Next:From: Peter T MountDate: 1999-01-06 23:20:11
Subject: Re: [HACKERS] SQLJ
Previous:From: Bruce MomjianDate: 1999-01-06 21:02:33
Subject: Re: [PORTS] vacuum takes too long

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group