Postgres partition tables 1 million rows I have a 1 million rows in one of my table and expect it grow to 3-4M in next 1 or 2 years.

There is lot of averages and sum are run on the date column for this row.

I'm planning to partition the tables to make the query run faster..

Questions:


Is it ok to partition table that just has 1 million rows.
I have 10 columns in the table but there are 2 columns that are text which stores around 2000 bytes of data.
How many rows Postgres can handle without partitions.
Your database is small and doesn't require partitioning.

A quick guesstimate gives storage requirements: two 2,000 byte columns times 1M rows is 4GB; times 3-4M rows is 12-16GB. A proper calculation would include a fudge factor for the other columns, indices, and other overheads, but it's still obviously an amount that fits in RAM on anything but the most crusty of servers.

So to answer your questions:


You can partition a 1M row table, but it's not worth the effort with PostgreSQL. (PostgreSQL is not MySQL.)
This is not a question!
PostgreSQL's "about" page states there is no limit on the number of rows, but a table cannot exceed 32TB.