dbTalk Databases Forums  

Storing every scrabble board possible

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Storing every scrabble board possible in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim C. Nasby
 
Posts: n/a

Default Storing every scrabble board possible - 11-22-2004 , 09:58 AM






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 decibel (AT) decibel (DOT) org
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 majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.