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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
