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

Re: database question

From: john(dot)crawford(at)sirsidynix(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: database question
Date: 2008-09-30 09:10:34
Message-ID: 22b026dd-e233-44c0-8098-1719b296fd01@x41g2000hsb.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
>
> So the answer is you've got something that's gone hog-wild on creating
> large objects and not deleting them; or maybe the application *is*
> deleting them but pg_largeobject isn't getting vacuumed.
>
>                         regards, tom lane
Hi all, thanks for the advice.  I ran the script for largefiles and
the largest is 3Gb followed by 1Gb then followed by another 18 files
that total about 3Gb between them.  So about 7Gb in total of a 100Gb
partition that has 99Gb used.  All this is in the data/base/16450
directory in these large 1Gb files.  If I look in the logs for
Postgres I can see a vacuum happening every 20 minutes, in that it
says "autovacuum: processing database "db name" but nothing else.  How
do I know if the vacuum is actually doing anything?
What is pg_largeobjects and what can I check with it (sorry did say I
was a real novice).
Really appreciate your help guys.
John

In response to

pgsql-general by date

Next:From: Glyn AstillDate: 2008-09-30 09:18:41
Subject: Re: Replication using slony-I
Previous:From: Ivan ZolotukhinDate: 2008-09-30 08:58:58
Subject: Re: pg_start_backup() takes too long

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