On Thu, Oct 29, 2009 at 4:42 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > First step to speed things up is putting pg_xlog on its own disk(s). > Since pg_xlog is mostly sequentially access, it's much faster when > Did that with a symlink. I always do that. My frustration is that I have this really fast RAID subsystem connected via fibre channel to a Sun X4100 with 20GB RAM and AMD Opterons. I don't seem to be able to squeeze out the update performance I really need out of it. I'm wondering if it is all the FK checks that are slowing me down... Thanks for responding to help me out. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general