Re: weird table sizes

From: MirrorX <mirrorx(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: weird table sizes
Date: 2011-07-23 19:18:25
Message-ID: 1311448705818-4626577.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thx for the reply :)

the table are identical, and i mean that they have the same columns, the
same constraints, the same indexes etc

1) the small table(65gb) is on version 8.4.7 and the big one(430gb) on 8.4.4
2) the small in on Red Hat 4.1.2-50 and the big on Red Hat 4.1.2-46
3) the 2nd was restored from a dump with data in it (my bad for the msg
before where i said that it was just the schema). now it is running and has
more and more data but the total rowcount is the one i gave, around
250million rows for that table
4) the data in these tables are 2 columns with dates, 10 integers and some
varchar columns. these columns are varchar(128) but i checked and they data
in there are far less and almost the same on the 2 tables. so if the varchar
is working "properly" and gets only the actual size of the string inside,
then the difference in the sizes of the 2 tables is not coming from these
columns.
5) i dont know why the sequence jumped. is there anything i can run to find
that? i just saw that it started from 9 billions (the min(id) for that table
is 9billions)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/weird-table-sizes-tp4626505p4626577.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-07-23 20:10:59 Re: Implementing "thick"/"fat" databases
Previous Message Adrian Klaver 2011-07-23 18:46:23 Re: weird table sizes