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

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