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 16320.1110343078@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?
List pgsql-performance
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
>> AFAIR that's just fwrite() ...

> Well, are there any hacks to speed it up?   It's about doubling the amount of
> time it takes to create an index on a very large table.

Huh?  Doubled compared to what?

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: index scan on =, but not < ?