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?
2011/6/9 Håvard Wahl Kongsgård haavard.kongsga...@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
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
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
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.