Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Date
Msg-id 200503082300.47085.josh@agliodbs.com
Whole thread Raw
In response to Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: index scan on =, but not < ?
Next
From: Gaetano Mendola
Date:
Subject: Re: pl/pgsql faster than raw SQL?