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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
