Skip site navigation (1) Skip section navigation (2)

Re: Inserting 8MB bytea: just 25% of disk perf used?

From: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: 2010-01-19 13:36:30
Message-ID: 20100119133630.GD2200@comppasch2 (view raw or flat)
Thread:
Lists: pgsql-performance
Ivan Voras:

> [I just skimmed this thread - did you increase the number of WAL logs to 
> something very large, like 128?]

Yes, I tried even more.

I will be writing data quite constantly in the real scenario
later. So I wonder if increasing WAL logs will have a
positive effect or not: AFAIK when I increase it, the
duration after the max is hit will be longer then (which is
not acceptable in my case).

Could anyone confirm if I got it right?

 Felix


In response to

Responses

pgsql-performance by date

Next:From: Greg StarkDate: 2010-01-19 14:52:25
Subject: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Previous:From: Willy-Bas LoosDate: 2010-01-19 12:59:41
Subject: renice on an I/O bound box

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group