On Mon, Nov 17, 2008 at 8:17 AM, Howard Cole <howardnews@xxxxxxxxxxxxx> wrote: > Teodor Sigaev wrote: >>> >>> The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks. Non Your entire disk io subsystem is a pair of hard drives. I'm assuming software RAID. > The time that this query takes is not the issue, rather it is the impact > that it has on the server - effectively killing it for the 40 seconds due to > the heavy disk access. You either need to invest more into your drive subsystem so it can handle parallel load better, or you need to create a slave db with slony or londiste so that the ugly queries hit the slave. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
