pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
size 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