On Thu, May 04, 2006 at 01:15:25PM -0700, Tony Lausin wrote: > My project is essentially a CMS, but there are features that are > commonly found in social networking sites like MySpace and CampusHook. > I prefer to call it a web-based BBS inspired by my Citadel days that > borrows features from social networking sites and multi-user blog > sites (think Slashdot, not LiveJournal or Blogger). Cool. Bonus points if you figure out a way to allow people to bring together blogs of friends that are on multiple sites with a seamless interface. > I don't anticipate the kind of usage that a site like MySpace gets; > but should users really go for the social networking features, and > start hammering away at profiles with comments and updates; I'd like > to know that the database can survive. If I had a dollar for everyone who started with MySQL because "it'll only be a small site"... > I read in a few places that vacuuming on a heavily hit site can be > necessary several times a day; and so that has been my biggest concern > with PostgreSQL. I haven't previously used autovacuum. Autovacuum is your friend. I would suggest cutting all the threshold values in half, though. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
