Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Question Unanswered: Large Table Performance

    Hi,

    I'm designing a database for a project, and have been trying to get an idea of PostgreSQL performance for large table sizes.

    I'm aware that this is highly dependant upon hardware, table design and other performance criteria, but I was hoping that some of you may have some experience which will give me an idea of what I can expect.

    According to the PostgreSQL documentation, there is no hard limit per se on a table size in terms of row count, allow there is a limit of 32TB on the physical size of the table.

    Does anyone have any experience with, or can point me towards examples, the feasibilility of Postgres tables with row counts in the order of 10^9?

    I appreciate this is a fairly involved topic, but I'm just interested in finding some additional background reading.

    Many Thanks,

    George

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Skype

    Also, look here...
    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
  •