From: Richard Huxton <dev@archonet.com>
To: prakashr2n5@yahoo.com
Cc: pgsql-performance@postgresql.org
Subject: Re: server space increasing very fast but transaction are very low
Date: Thu, 06 Nov 2008 11:04:30 +0000
Message-ID: <4912CF3E.90801@archonet.com> (raw)
In-Reply-To: <551154.82667.qm@web8405.mail.in.yahoo.com>
References: <551154.82667.qm@web8405.mail.in.yahoo.com>
1. Don't email people directly to start a new thread (unless you have a
support contract with them of course).
2. Not much point in sending to two mailing lists simultaneously. You'll
just split your responses.
brahma tiwari wrote:
> Hi all
>
> My database server db01 is on linux environment and size of base
> folder increasing very fast unexpectedly(creating renamed files of 1
> GB in base folder like 1667234568.10) details as below
These are the files containing your tables / indexes.
When a file gets larger than 1GB the file gets split and you get .1, .2 etc
on the end)
> what is significance of these files and how can i avoid it.can i
> delete these renamed files from base folder or any thing else. Please
> help
NEVER delete any files in .../data/base.
Since these files all seem to have the same number they are all the same
object (table or index). You can see which by looking in pg_class.
You'll want to use the number 1662209326 of course.
=> SELECT relname,relpages,reltuples,relfilenode FROM pg_class WHERE
relfilenode=2336591;
relname | relpages | reltuples | relfilenode
---------+----------+-----------+-------------
outputs | 3 | 220 | 2336591
(1 row)
This is the table outputs on mine which occupies 3 pages on disk and has
about 220 rows. You can find out the reverse (size of any table by name)
with some useful functions:
select pg_size_pretty(pg_total_relation_size('my_table_name'));
I'm guessing what you've got is a table that's not being vacuumed
because you've had a transaction that's been open for weeks.
--
Richard Huxton
Archonet Ltd
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-performance@postgresql.org
Cc: dev@archonet.com, prakashr2n5@yahoo.com
Subject: Re: server space increasing very fast but transaction are very low
In-Reply-To: <4912CF3E.90801@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox