Re: Updates, deletes and inserts are very slow. What can I do make them bearable?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Gary Chambers <gwchamb(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Updates, deletes and inserts are very slow. What can I do make them bearable?
Date: 2010-10-21 05:05:36
Message-ID: AANLkTimWtMnH4jxORg9+zPvhgp1Dk+DhgpcLYYqhv6aD@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One more follow up.

Did a vacuum full on both tables and a re-index on both tables.

Changed the wal_buffers to 16MB (increased the kernel param as a
result) as per
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

I also turned off fsync but still no joy.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2010-10-21 05:43:22 Re: pg_temp implicit search path: functions vs. tables
Previous Message Tom Lane 2010-10-21 05:05:23 Re: a query on stored procedures/functions in pgsql