Re: Tuning Postgres 9.1 on Windows

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning Postgres 9.1 on Windows
Date: 2012-04-30 22:04:17
Message-ID: CAHyXU0wZJVeHbGDTRerh41iN6PfJNhDxvDJRdxbmUVx_U58JDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 30, 2012 at 5:00 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> Merlin Moncure wrote on 30.04.2012 23:43:
>
>> Trying turning off fsync in postgrsql.conf to be sure.
>
>
> This is a dangerous advise.
> Turning off fsync can potentially corrupt the database in case of a system
> failure (e.g. power outage).
>

sure. that said, we're just trying to figure out why he's getting
around 40tps. since he's only benchmarking test data it's perfectly
ok to do that.

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Walker, James Les 2012-05-01 12:51:57 Re: Tuning Postgres 9.1 on Windows
Previous Message Thomas Kellerer 2012-04-30 22:00:09 Re: Tuning Postgres 9.1 on Windows