Aarni, Jason,
> My suggestion would be to put all of the data in one table.
> Especially if that would make the system easier to query. Believe it
> or not but 1 million records isn't really that big of a deal. I have
> tables with 17 million rows, and I generally use cheap commodity
> hardware.
You may want expert help or advice on performance tweaks for your
server, though. The default settings in postgresql.conf are not
intended for a million-row table on a serious server.
-Josh Berkus