Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2013
    Posts
    1

    Question Unanswered: Oracle vs Postgres in Baking system

    Hi..

    Currently im working on Postgres Database ( free version ) and our business is now rapidly expanding, database also growing, number of transactions also getting high, baking system is developed using Java + hibernate + active MQ + TOMCAT,

    I am planing to migrate to ORACLE, my question is how i get to know is Postgres can handle ( free version ) system for next 5 years ... is there any performance factors.... what are the benefits it get if i select ORACLE, and what Postgres cant do.. is there any successful baking system which is running on Postgres ..

    Please i need your help to clear out my issue ...

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >number of transactions also getting high,
    at what specific value does the transaction rate go from being acceptable to being "high"?

    is this true for every application on every system?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by doubledb View Post
    Hi..
    . . . E t c . . .
    I am planing to migrate to ORACLE, my question is how i get to know is Postgres can handle ( free version ) system for next 5 years ...
    . . .
    Please i need your help to clear out my issue ...

    Thanks
    What is motivating you to migrate to Oracle if Postgres doing well?
    Postgres limits seem to be adequate:
    Code:
    Limit	Value
    Maximum Database Size	Unlimited
    Maximum Table Size	32 TB
    Maximum Row Size	1.6 TB
    Maximum Field Size	1 GB
    Maximum Rows per Table	Unlimited
    Maximum Columns per Table	250 - 1600 depending on column types
    Maximum Indexes per Table	Unlimited
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •