Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Date: 2005-03-09 07:00:46
Message-ID: 200503082300.47085.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

> Huh? Doubled compared to what?

Compared to how much data writing I can do to the database when pgsql_tmp
isn't engaged.

In other words, when pgsql_tmp isn't being written, database writing is 9mb/s.
When pgsql_tmp gets engaged, that drops to 4mb/s.

Alternatively, the WAL drive, which is the same hardware, will write at
10mb/s.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gaetano Mendola 2005-03-09 11:20:57 Re: pl/pgsql faster than raw SQL?
Previous Message Bruno Wolff III 2005-03-09 05:20:20 Re: index scan on =, but not < ?