From the same Database based on pgbench (TPC-B), I have noted that the
Database size is twice lager in Postgres 7.3.3 & 7.4 than with Oracle
9i.
And don't know why.
Firstly, I thought that as one column name filler type char(88),
char(84) or char(22) according the tables which were not initialized, was
optimised by Oracle to mark them as NULL and save disk space.
But, I have modified the data generation to generate random string
and force Oracle to put something in the columns. As results, the both
Database was twice bigger but Postgres Database size ~= 2 x Oracle Database
size.
And I have not found any explanation.
Regards,
Thierry Missimilly
Seum-Lim Gan wrote:
Hi,I searched through the archive and could not find any conclusive
discussion of results on this.Has anyone compared the disk space usage between PostgreSQL
and Oracle ?I am interested in knowing for the same tuple (i.e same
dictionary), the disk usage between the two.Thanks.
Gan
--
+--------------------------------------------------------+
| Seum-Lim GAN email : [EMAIL PROTECTED] |
| Lucent Technologies |
| 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 |
| Naperville, IL 60566, USA. fax : (630)-713-7272 |
| web : http://inuweb.ih.lucent.com/~slgan |
+--------------------------------------------------------+---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:BIS/R&D adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;-18184 fn:Thierry Missimilly end:vcard
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly