Re: MySQL versus Postgres

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: greg(at)2ndquadrant(dot)com
Cc: jd(at)commandprompt(dot)com, masivakumar(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: MySQL versus Postgres
Date: 2010-08-13 00:38:35
Message-ID: 20100813.093835.16668689.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> It's slower than smaller numbers, and if you actually dirty a
> significant portion of it you can have a checkpoint that takes hours to
> sync, completely trashing system responsiveness for a good portion of it.

So how much is the reasonal upper limit of shared_buffers at this
point? If it's obvious, should we disable or warn to use more than
that number?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vibhor Kumar 2010-08-13 01:11:13 Re: Setting up pgpass.conf for the postgres OS user on windows for pgAgent
Previous Message Joshua D. Drake 2010-08-13 00:30:56 Re: MySQL versus Postgres