Postgres Pro
Downloads
Home   >   mailing lists

Re: Write performance on a large database - Mailing list pgsql-general

From Vick Khera
Subject Re: Write performance on a large database
Date
Msg-id BANLkTin4S7dPbuNgkeSoNGqVP7qOi4ZPXQ@mail.gmail.com
Whole thread Raw
In response to Write performance on a large database  (Håvard Wahl Kongsgård <haavard.kongsgaard@gmail.com>)
List pgsql-general
Tree view 
2011/6/9 Håvard Wahl Kongsgård <haavard.kongsgaard@gmail.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.

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres
Next
From: Merlin Moncure
Date:
Subject: Re: plpgsql function with update and seeing changed data from outside during run