newbie questions
От | Mark Parker |
---|---|
Тема | newbie questions |
Дата | |
Msg-id | KSVub.11429$Ek.8227@twister.austin.rr.com обсуждение исходный текст |
Ответы |
Re: newbie questions
|
Список | 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
В списке pgsql-general по дате отправления: