Re: Write performance on a large database

From: Vick Khera <vivek(at)khera(dot)org>
To: Håvard Wahl Kongsgård <haavard(dot)kongsgaard(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Write performance on a large database
Date: 2011-06-09 13:35:21
Message-ID: BANLkTin4S7dPbuNgkeSoNGqVP7qOi4ZPXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011/6/9 Håvard Wahl Kongsgård <haavard(dot)kongsgaard(at)gmail(dot)com>:
> To improve the write performance, what are my options?

add more ram. add more checkpoint segments. get faster disks. reduce
the number of indexes you have. split your big tables into smaller
partitions.

which of these may work depends on your exact problem. we don't know
what that is.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-06-09 13:44:02 Re: plpgsql function with update and seeing changed data from outside during run
Previous Message Bill Moran 2011-06-09 12:44:31 Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres