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
