> > 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 Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to