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
