Naresh Soni <jmnaresh@xxxxxxxxx> wrote: > This is my first question on the list, I wanted to ask if > postgres can handle multi millions records? for example there > will be 1 million records per table per day, so 365 millions per > year. Yes, I have had hundreds of millions of rows in a table without performance problems. If you want to see such a table in action, go to the following web site, bring up a court case, and click the "Court Record Events" button. Last I knew the table containing court record events had about 450 million rows, with no partitioning. The total database was 3.5 TB. http://wcca.wicourts.gov/ > Is yes, then please elaborate. You will want indexes on columns used in the searches. Depending on details you have not provided it might be beneficial to partition the table. Do not consider partitioning to be some special magic which always makes things faster, though -- it can easily make performance much worse if it is not a good fit. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
