agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Mike Baker <bakerlmike@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Vacuum Question
Date: Mon, 16 Dec 2002 07:52:19 -0800 (PST)
Message-ID: <20021216155219.87183.qmail@web13807.mail.yahoo.com> (raw)

Hi.

I am running a weekly cron job to vacuum our
production database.  Everything seems to look OK,
except for the report around the pg_largeobjects
table. I was wondering if there is some tunning that I
need to do to my database, or if it is normal to have
so many tuples and deletes for pg_largeobjects.  Here
is the output:

VACUUM
--Relation pg_largeobject--
Pages 409852: Changed 6205, reaped 393786, Empty 0,
New 0; Tup 1287298: Vac 14028, Keep/VTL 0/0, Crash 0,
UnUsed 454755, MinLen 45, MaxLen 2092; Re-using:
Free/Avail. Space 716319960/716272248; EndEmpty/Avail.
Pages 0/391372. CPU 17.65s/1.09u sec.
Index pg_largeobject_loid_pn_index: Pages 13833;
Tuples 1287298: Deleted 14028. CPU 0.65s/1.99u sec.
Rel pg_largeobject: Pages: 409852 --> 407718; Tuple(s)
moved: 4278. CPU 64.96s/194.85u sec.
Index pg_largeobject_loid_pn_index: Pages 13833;
Tuples 1287298: Deleted 4278. CPU 0.45s/0.68u sec.
Analyzing..

Thanks

Mike Baker
SCM Labs, Inc.


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

view thread (11+ messages)  latest in thread

Message-ID: <20021216155219.87183.qmail@web13807.mail.yahoo.com>
Permalink:  ../20021216155219.87183.qmail@web13807.mail.yahoo.com/
Also on:    postgresql.org/message-id/20021216155219.87183.qmail@web13807.mail.yahoo.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bakerlmike@yahoo.com
  Subject: Re: Vacuum Question
  In-Reply-To: <20021216155219.87183.qmail@web13807.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox