Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com
	[216.136.174.114])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f6GJXca93964
	for <pgsql-admin@postgresql.org>; Mon, 16 Jul 2001 15:33:38 -0400 (EDT)
	(envelope-from chrup999@yahoo.com)
Received: from proxy.compucom.com (HELO Z161842) (204.214.145.2)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 16 Jul 2001 19:26:56 -0000
X-Apparently-From: <chrup999@yahoo.com>
Message-ID: <00b001c10e2d$420007e0$5dd26383@corp.compucom.com>
From: "Chris Ruprecht" <chrup999@yahoo.com>
To: "p-admin" <pgsql-admin@postgresql.org>
Subject: Vacuum
Date: Mon, 16 Jul 2001 14:26:48 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00AD_01C10E03.58F00420"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Archive-Number: 200107/70
X-Sequence-Number: 1826

This is a multi-part message in MIME format.

------=_NextPart_000_00AD_01C10E03.58F00420
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi fellow Postgressers

I have a relatively small database. The data itself is about 1.5GB. After I=
 did some index value changes over the weekend, I decided that it's time to=
 do a vacuum - the db had grown to 10 GB in size - which was just unrealist=
ic.
at 7:13 this otherwise fine morning, I started the vacuum and was hoping fo=
r a run time of maybe 2 hours - max. Well, it is 2:20 PM now and it's still=
 ticking. It has created so far 1411 files in $PGDATA/pg_xlog (which, since=
 last night resides on a different drive from the database). Each of the fi=
le is 16 MB in size and if this continues for another 3 hours (or so) I'm r=
unning out of disk space.

If I would have done a=20
dump all data
drop db
create new db
restore schema (create tables/indexes/sequences)
load all data

I would have been done in about 2 hours.

Can somebody explain to me what this vacuum is doing with all these files? =
I suppose, this transaction logging stuff needs some serious looking into/r=
e-writing.
Is there a way to switch this stuff off all together?

Best regards,
Chris


------=_NextPart_000_00AD_01C10E03.58F00420
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi fellow Postgressers</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have a relatively small database. The da=
ta itself=20
is about 1.5GB. After I did some index value changes over the weekend, I de=
cided=20
that it's time to do a vacuum - the db had grown to 10 GB in size - which w=
as=20
just unrealistic.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>at 7:13 this otherwise fine morning, I sta=
rted the=20
vacuum and was hoping for a run time of maybe 2 hours - max. Well, it is 2:=
20 PM=20
now and it's still ticking. It has created so far 1411 files in $PGDATA/pg_=
xlog=20
(which, since last night resides on a different drive from the database). E=
ach=20
of the file is 16 MB in size and if this continues for another 3 hours (or =
so)=20
I'm running out of disk space.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>If I would have done a </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>dump all data</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>drop db</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>create new db</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>restore schema (create=20
tables/indexes/sequences)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>load all data</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I would have been done in about 2=20
hours.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Can somebody explain to me what this vacuu=
m is=20
doing with all these files? I suppose, this transaction logging stuff needs=
 some=20
serious looking into/re-writing.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Is there a way to switch this stuff off al=
l=20
together?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Best regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Chris</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00AD_01C10E03.58F00420--


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com