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

Tom,

> > 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() ...

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.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco