Re: Call for 7.5 feature completion
Joshua D. Drake <jd@commandprompt.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Mario Weilguni <mweilguni@sime.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2004-05-17T20:32:44Z
Lists: pgsql-hackers
Attachments
- jd.vcf (text/x-vcard)
Mario Weilguni wrote: >>Interesting. >>We have made COMPLETELY different experiences. >> >>There is one question people ask me daily: "When can we have sychronous >>replication and PITR?". >>Performance is not a problem here. People are more interested in >>stability and "enterprise" features such as those I have mentioned above. > > > I doubt that. Having deployed several 7.4 databases, the first customers ask > (of course not in technical speech, but in the meaning) when the problem with > checkpoint hogging system down is solved. This is a really serious issue, > especially when using drbd + ext3. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Well that seems to be part of the problem. ext3 does not scale well at all under load. You should probably upgrade to a better FS (like XFS). I am not saying that your point isn't valid (it is) but upgrading to a better FS will help you. Sincerely, Joshua D. Drake The system will become really unresponsive > when checkpoint is running. > > I heavily await 7.5 because of the background writer. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL