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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1999-01-06 23:20:11 | Re: [HACKERS] SQLJ |
Previous Message | Bruce Momjian | 1999-01-06 21:02:33 | Re: [PORTS] vacuum takes too long |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-01-07 00:50:37 | Re: [PORTS] vacuum takes too long |
Previous Message | Bruce Momjian | 1999-01-06 21:02:33 | Re: [PORTS] vacuum takes too long |