On Wed, 26 Jan 2005 09:45:50 -0000, Simon Gray <[EMAIL PROTECTED]> wrote:
> You can use mysql merge tables instead of innodb or myisam, this will allow > you to split the data in to as many physical tables as you wish (works out > as a single virtual table). > > http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html You can do a similar thing in PostgreSQL as well using views and rules. Create a view on the union of the broken tables. Then set insert, update and delete rules on that view to analyze the data and direct it to a specific table -- e.g. your insert rule could be configured to evenly distribute rows among the group of tables - I'm not sure if that's possible in mysql. http://www.postgresql.org/docs/8.0/interactive/rules.html > Not sure how you'd span that over multiple disks thought, be interested to > find out - quick google search and I found this ' Split databases and tables > over different disks. In MySQL you can use symbolic links for this.' > Cunning! Symlinks work in postgres as well, but with the new v8.0.0 you can use tablespaces to directly store tables in arbitrary disk locations. -- Ben
