On Mon, Oct 25, 2010 at 11:39:30AM -0700, Divakar Singh wrote: > Thanks Ray, > Already seen that, but it does not tell about storage requirement compared to > Oracle. I find it takes 2 times space than oracle. > > > Best Regards, > Divakar > ________________________________ > From: Ray Stell <ste...@cns.vt.edu> > To: Divakar Singh <dpsma...@yahoo.com> > Sent: Tue, October 26, 2010 12:05:23 AM > Subject: Re: [PERFORM] Postgres insert performance and storage requirement > compared to Oracle > > On Mon, Oct 25, 2010 at 11:12:40AM -0700, Divakar Singh wrote: > > > > 2. What are the average storage requirements of postgres compared to > > Oracle? I > > > inserted upto 1 million records. The storage requirement of postgreSQL is > >almost > > > > double than that of Oracle. > > there's a fine manual: > http://www.postgresql.org/docs/9.0/interactive/storage.html
Maybe compare to oracle's storage documentation: http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/sql_elements001.htm#SQLRF30020 http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/schema007.htm#ADMIN11622 I don't believe for a second the byte count is double in pg, but that's just a religious expression, I've never counted. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
