Here's an interesting discussing about storing every possible scrabble board: http://www.livejournal.com/users/stenz/117914.html Note that PostgreSQL ends up being 12x larger than a theoretical custom storage format, which isn't too bad considering the gymnastics going on in the custom storage format. Also note the author's original brute-force method is 5x larger than an improved method using PostgreSQL.
So, is anyone currently running a PostgreSQL database that's 6TB and 150B rows? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly