pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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