Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Date
Msg-id 16215.1110342464@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> Maybe I'm not an idiot (really!)  even with almost 2GB of maintenance_mem, PG
> still writes to pgsql_tmp no faster than 2MB/s.    I think there may be an
> artificial bottleneck there.  Question is, PostgreSQL, OS or hardware?

AFAIR that's just fwrite() ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: index scan on =, but not < ?
Next
From: Josh Berkus
Date:
Subject: Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?