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

    Question Unanswered: Large Table Performance


    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,


  2. #2
    Join Date
    Jun 2004
    Arizona, USA

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