Postgres Pro
Downloads
Home   >   mailing lists

Re: Updates, deletes and inserts are very slow. What can I do make them bearable? - Mailing list pgsql-general

From Tim Uckun
Subject Re: Updates, deletes and inserts are very slow. What can I do make them bearable?
Date
Msg-id AANLkTimWtMnH4jxORg9+zPvhgp1Dk+DhgpcLYYqhv6aD@mail.gmail.com
Whole thread Raw
In response to Re: Updates, deletes and inserts are very slow. What can I do make them bearable?  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: a query on stored procedures/functions in pgsql
Next
From: Josh Kupershmidt
Date:
Subject: Re: pg_temp implicit search path: functions vs. tables