pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsize difference between du and PG_CLASS
2+ messages / 2 participants
[nested] [flat]
* size difference between du and PG_CLASS
@ 2004-06-22 15:47 Lee Wu <Lwu@mxlogic.com>
2004-06-22 17:28 ` Re: size difference between du and PG_CLASS Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Lee Wu @ 2004-06-22 15:47 UTC (permalink / raw)
To: pgsql-admin
Hi All,
We have a big difference between du and PG_CLASS:
du -hs ./base/17613
21G ./base/17613
select sum(relpages)*8/1024/1024 from pg_class;
?column?
----------
11
(1 row)
I am sure I run the select under the right database (17613).
I know there are some files under:
du -hs base/17613/pgsql_tmp
1.7G base/17613/pgsql_tmp
But the difference is still around 8G (21G - 11G - 1.7G).
When I check timestamp on files under directory 17613, I found there are
many old relfilenode which do not exist
in the pg_class any more. We had bounced the PG server, those files are
still there.
Does PG remove those files which are not longer used by PG after server
bounce?
Which files can I safely delete?
Thanks,
PS: PG version 7.3.2 and OS version Red Hat Linux release 7.3 (Valhalla)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: size difference between du and PG_CLASS
2004-06-22 15:47 size difference between du and PG_CLASS Lee Wu <Lwu@mxlogic.com>
@ 2004-06-22 17:28 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-06-22 17:28 UTC (permalink / raw)
To: Lee Wu <Lwu@mxlogic.com>; +Cc: pgsql-admin
"Lee Wu" <Lwu@mxlogic.com> writes:
> in the pg_class any more. We had bounced the PG server, those files are
> still there.
I am starting to think that a lot of your problems are self-induced.
You should not "bounce the PG server" every time you think maybe there's
something wrong.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-22 17:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-22 15:47 size difference between du and PG_CLASS Lee Wu <Lwu@mxlogic.com>
2004-06-22 17:28 ` Tom Lane <tgl@sss.pgh.pa.us>
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