Results 1 to 6 of 6

Thread: large database

  1. #1
    Join Date
    Jan 2007
    Posts
    4

    Unanswered: large database

    Hi Folks!
    I have same problem with large database.
    That is my web application database is large (10GB-->500GB) and my boss can't pay for Oracle because it's so expensive for his company. Because of requirement, I pay attention to MS SQL Server or PostgreSQL but I don’t know these DBMSs can work well as expect?
    The language of application is Java, the server which run this application is medium-->high.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by skywar
    Hi Folks!
    I have same problem with large database.
    That is my web application database is large (10GB-->500GB) and my boss can't pay for Oracle because it's so expensive for his company. Because of requirement, I pay attention to MS SQL Server or PostgreSQL but I don’t know these DBMSs can work well as expect?
    The language of application is Java, the server which run this application is medium-->high.
    PostgreSQL should work for this. Set up two separate servers - one for the backend database, and one for the web server. I'm sure that others who have worked with large databases will be able to provide additional tips/tricks to optimize performance.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    27

    large database

    Hi,

    You can also have a look at the Firebird database.

    Thank you.

    Sudheer

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    There are some good pointers over at postgreSQL.org mailing list archives.

    http://archives.postgresql.org/pgsql...2/msg00079.php

    http://archives.postgresql.org/pgsql...8/msg00043.php
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  5. #5
    Join Date
    Jan 2007
    Posts
    4
    Thanks your guide.
    I also have an another question: Does PostgreSQL support distributed database attribute?
    I have installed PostgreSQL in driver C (Windows OS), my data will be over capacity of this driver, how can I solve this problem?
    Between distributed application and distributed database, which is best?
    Please give me your advice!!
    Have a nice day to everybody!

  6. #6
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Add a tablespace which references an separate drive or fileserver.

    The drive could be physically installed on the PC, or it could be a shared network drive.

    Make sure that the large tables reside on the large tablespace.

    Note that IF the external drive is a shared network drive, performance will suffer unless you have a very fast connection (preferrably gigabit, or dedicated 100 megabit connection) between the server and the file server.
    Last edited by loquin; 02-08-07 at 14:45.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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