From: | "Mark Parker" <markus_ext(at)senator(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | newbie questions |
Date: | 2003-11-20 02:42:50 |
Message-ID: | KSVub.11429$Ek.8227@twister.austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I've inherited some postgres databases and have a couple of questions
I'm hoping someone can help me out with.
First, is there a way to link the file in the database directory, which
are all numbers, to specific databases?
Second, I've got some dbs that have some really huge files. A nightly
vacuum (not full) is running. Several of the files have names followed by
rev numbers and are the same size; viz:
-rw------- 1 postgres postgres 1073741824 Nov 19 05:32 144287855
-rw------- 1 postgres postgres 1073741824 Nov 19 03:45 144287855.1
-rw------- 1 postgres postgres 1073741824 Nov 19 03:44 144287855.2
-rw------- 1 postgres postgres 1073741824 Nov 19 03:46 144287855.3
-rw------- 1 postgres postgres 1073741824 Nov 19 03:46 144287855.4
-rw------- 1 postgres postgres 1073741824 Nov 19 03:46 144287855.5
-rw------- 1 postgres postgres 1073741824 Nov 19 05:32 144287855.6
-rw------- 1 postgres postgres 12951552 Nov 19 05:32 144287855.7
This looks fishy to me. Is it? I know that there's no way that the db in
question could have 7gb of data in it.
I've been told that the way they've been getting the db back to a
reasonable size was via the ps_dump, drop table, recreate table psql <
dumpfile routing. Seems a bit excessive.
Can someone gimmie some advice please please please? Or point me to the
docs that'll clear up my confusion as I've not found them on my own.
-Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Alex | 2003-11-20 03:38:41 | Export CSV from psql |
Previous Message | Rajesh Kumar Mallah | 2003-11-20 01:26:31 | Re: 7.4RC2 vs 7.4 |