From: kris pal <kristhegambler@yahoo.com>
To: kris pal <kristhegambler@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: regression database
Date: Thu, 26 Aug 2004 14:15:32 -0700 (PDT)
Message-ID: <20040826211532.30654.qmail@web61308.mail.yahoo.com> (raw)
In-Reply-To: <20040826173209.18246.qmail@web61306.mail.yahoo.com>
Actually I just noticed something. Previously for some reason, I thought the data directory corresponded to 'regression'. But I double checked it now with oid2name and it corresponds to our main database say "dds".
But the issue still remains. In the sense that pg_attribute etc are still so huge and I have no idea why. This table is not the one we created in the schema.
thanks,
Kris Pal.
kris pal <kristhegambler@yahoo.com> wrote:Hi tom,
It is actually named 'regression'. I spoke with the person who build the server but apparently he is not well worsed in Postgres. He didn't explicitly create 'regression', I guess he selected some default installation options.
I am not sure how to find out what is causing the 'regression' database to increase in size. Its size is not due to the tables with in the 'regression' but due to the system tables like "pg_attribute" with in 'regression' database. If you chould point to a resource which would help me understand how this 'regression' database is handled internally (what activity writes to this database) that would be great.
Pls see below, the directory 2034862 corresponds to 'regression':
____________________________________________________
[postgres@dds base]$ du -sk /home/postgres/data/base/2034862
6236920 /home/postgres/data/base/2034862
[postgres@dds base]$
[postgres@dds base]$ cd /home/postgres/data/base/2034862
[postgres@dds 2034862]$ du -sk * | awk '{if ($1 > 512000) print $1" --> "$2}'
1049604 --> 1249 (over 1GB)
949484 --> 1249.1 (abt 1GB)
1049604 --> 16609
821104 --> 16609.1
The relname for the corresponding relfilenode:
--------------+-------------
pg_attribute | 1249
pg_attribute_relid_attnam_index | 16609
--------------+-------------
____________________________________________________
So am not sure why this thing is growing progressively.
Any feedback/ help is greatly appreciated.
thanks,
Kris Pal.
Tom Lane <tgl@sss.pgh.pa.us> wrote: kris pal writes:
> I am not sure what the implications of completely deleting the
> 'Regression' database (I don't need the regression testing).
Is it named "Regression" with a capital R? If so, that's not the DB that
is made by the standard regression tests --- that is called "regression".
There is not any reason not to drop the standard regression database, if
you're not using it. But there is no way that that DB would get that
large unless something in your installation is using it. I'd suggest
you find out what.
regards, tom lane
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
---------------------------------
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kristhegambler@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: regression database
In-Reply-To: <20040826211532.30654.qmail@web61308.mail.yahoo.com>
References: <20040826173209.18246.qmail@web61306.mail.yahoo.com> <20040826211532.30654.qmail@web61308.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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox