Re: weird table sizes

On Saturday, July 23, 2011 11:29:48 am MirrorX wrote:
> hello to all
>
> i would like your help in the following matter ->
>
> we have 2 identical databases. the 1st was built from scratch while the 2nd
> was 'restored' from a dump of another database (without the data). so the
> sequences for instance on the 2nd started from very big numbers. in these
> databases there is a table. in the first it has around 350 mil rows and
> size of 65GB (sequence started from 1). in the second it has 250 mil and
> size of 430 GB(sequence started from 9 billions). how can that be?the
> sizes are from the pg_relation_size function.
>
> i know that with what i said you certainly cannot answer to my question but
> i dont know what kind of extra info you would like to know in order to help
> me, so i can provide you anything you find useful.

First I am having a problem with they are identical but different:)
Questions:
1) Same or different versions of Postgres?
2) Same or different OSes.?
3) The 2nd was restored from a schema only dump, but has data in it. Where did
the data come from?
4) What is the data?
5) Why did the sequence jump?

>
> i would appreciate it if you could point me to some direction.thank you in
> advance
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/weird-table-sizes-tp4626505p462650
> 5.html Sent from the PostgreSQL - general mailing list archive at
> Nabble.com.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com