On 06/09/2011 08:15 AM, Håvard Wahl Kongsgård wrote:
Hi, I have performance issues on very large database(100GB). Reading
from the database is no problem, but writing(or heavy writing) is a
nightmare.
I have tried tuning postgresql, but that does not seem to improving
the writing performance.
On June 9, 2011 05:15:26 AM Håvard Wahl Kongsgård wrote:
> Hi, I have performance issues on very large database(100GB). Reading from
> the database is no problem, but writing(or heavy writing) is a nightmare.
> I have tried tuning postgresql, but that does not seem to improving the
> writing perfor
> Hi, I have performance issues on very large database(100GB). Reading from
> the database is no problem, but writing(or heavy writing) is a nightmare.
> I have tried tuning postgresql, but that does not seem to improving the
> writing performance.
> To improve the write performance, what are my op
2011/6/9 Håvard Wahl Kongsgård :
> 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
Hi, I have performance issues on very large database(100GB). Reading from
the database is no problem, but writing(or heavy writing) is a nightmare.
I have tried tuning postgresql, but that does not seem to improving the
writing performance.
To improve the write performance, what are my options?
-
