Skip site navigation (1) Skip section navigation (2)

Re: Postgres insert performance and storage requirement compared to Oracle

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Divakar Singh <dpsmails(at)yahoo(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Date: 2010-10-27 18:42:19
Message-ID: 4CC8728B.9050205@krogh.cc (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
On 2010-10-27 20:28, Merlin Moncure wrote:
> Postgres indexes are pretty compact, and oracle (internals I am not
> familiar with) also has to do MVCC type management, so I am suspecting
> your measurement is off (aka, operator error) or oracle is cheating
> somehow by optimizing away storage requirements somehow via some sort
> of tradeoff.  However you still fail to explain why storage size is a
> problem.  Are planning to port oracle to postgres on a volume that is
> 50% full? :-)
>    
Pretty ignorant comment.. sorry ..

But when your database approaches something that is not mainly
fitting in memory, space directly translates into speed and a more
compact table utillizes the OS-page cache better. This is both
true for index and table page caching.

And the more compact your table the later you hit the stage where
you cant fit into memory anymore.

.. but if above isn't issues, then your statements are true.

-- 
Jesper

In response to

Responses

pgsql-performance by date

Next:From: Steve SingerDate: 2010-10-27 18:51:02
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Previous:From: Trenta sisDate: 2010-10-27 18:38:20
Subject: Massive update, memory usage

pgsql-hackers by date

Next:From: Steve SingerDate: 2010-10-27 18:51:02
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Previous:From: Merlin MoncureDate: 2010-10-27 18:28:06
Subject: Re: Postgres insert performance and storage requirement compared to Oracle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group