Hi,
Our new Postgres database includes a table with about 1 mil records. So far, I've been impressed with the performance of queries against 1 mil rows. Unfortunately I just found out that the size of the table will increase to 3 mil records.
Can I expect Postgres to return results on a query with a basic join against a 3 mil record table in under 1 sec? The box is a Xenon processor with 512 MB RAM. The table is indexed on an integer field that's also the foreign key in most joins. I'm not familiar with how Postgres scales as your table size grows, so any input would be appreciated...
Jon