pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
abnormal size of the on-disk file.
2+ messages / 2 participants
[nested] [flat]

* abnormal size of the on-disk file.
@ 2002-04-26 14:52  Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Rajesh Kumar Mallah @ 2002-04-26 14:52 UTC (permalink / raw)
  To: pgsql-sql

Hi There,

I have a small table  companies (< 300 rows)  and its on-disk size shows

abnormal


i check it as follows:

 SELECT relname,relfilenode  from pg_class where relfilenode=30977;
  relname  | relfilenode
-----------+-------------
 companies |       30977
(1 row)

ls -lsh  30977
487M -rw-------    1 postgres postgres     486M Apr 26 20:27 30977
bash-2.03$


i created a new table with the same content

tradein_clients=> CREATE  TABLE t_a as select * from companies;

SELECT

its on disk file is very small

tradein_clients=> SELECT relname,relfilenode  from pg_class where
relname='t_a';
 relname | relfilenode
---------+-------------
 t_a     |    87812505
(1 row)

bash-2.03$ ls -lsh  87812505
196k -rw-------    1 postgres postgres     192k Apr 26 20:27 87812505
bash-2.03$

Can anyone explain this ..

does unvaccuming makes tables  x2000  times largers??

regds
mallah.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: abnormal size of the on-disk file.
@ 2002-04-29 16:46  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephan Szabo @ 2002-04-29 16:46 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-sql

On Fri, 26 Apr 2002, Rajesh Kumar Mallah wrote:

> Hi There,
>
> I have a small table  companies (< 300 rows)  and its on-disk size shows
> abnormal


If you've been making modifications to the table rows and haven't been
vacuuming you're going to have all the dead rows in the table as well
as live ones.  On 7.2 you'd need a vacuum full to clear the space at this
point (you can use normal vacuum more frequently during normal operation
to avoid needing the full).

> does unvaccuming makes tables  x2000  times largers??




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-04-29 16:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-26 14:52 abnormal size of the on-disk file. Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-29 16:46 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>

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