Marc Cousin escribió:
> There are other things I am thinking of : maybe it would be better to have sort space on another (and not DBRD'ded) raid set ? we have a quite
> cheap setup right now for the database, and I think maybe this would help scale better. I can get a filesystem in another volume group, which is not used that much for now.
You know, that's the first thing it came to me when I read you're using
DRDB. Have you tried setting temp_tablespace to a non-replicated disk?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support