Eci,
I could not google them up quickly, but there are people dealing with tables with millions of records in PostgreSQL.
Per technical data the number of rows in a table is unlimited in PostgreSQL:
http://www.postgresql.org/about/There may be performance-reasons to split up a table of that size, but still you can trust PostgreSQLs table inheritance together with constraint exclusion to deal with that: just inherit your tables on a monthly base:
create table access200601 inherits ....
and adjust your rules accordingly.
read up on this documentation for examples of table partitioning,
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.htmlwhat is the technical term for the method you are looking for.
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now you can prepare budget for visiting EuroPython 2007.