Re: [ADMIN] Database taking up space rapidly

2003-12-27 Thread Anjan Dave
... Thanks, Anjan -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Fri 12/26/2003 6:29 PM To: Anjan Dave Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Database taking up space rapidly "Anjan Dave" <[EMAIL PROTECTED]> writes: > Here's

Re: [ADMIN] Database taking up space rapidly

2003-12-26 Thread Tom Lane
"Anjan Dave" <[EMAIL PROTECTED]> writes: > Here's where I find the bulk of the large files: > -rw---1 postgres postgres 1073741824 Dec 23 18:57 17610 > -rw---1 postgres postgres 1073741824 Dec 23 22:41 17610.1 > [ etc ] So, which table or index has relfilenode 17610 (look in pg_cla

[ADMIN] Database taking up space rapidly

2003-12-26 Thread Anjan Dave
Title: Database taking up space rapidly Hi All, I just moved over a db from 7.2.3 to 7.4.0 on a new RH9 server. The dump, I remember was about 2GB, 350MB compressed, when I restored it only about 3-4 days ago… Now, the slice stands at about 30GB!! /dev/sda2 50830616  300348