Re: When should I start and setup a slave replication?

Tomer Praizler wrote:
> I currently have one Postgres server running on an ec2 instance 32GB, and 8 cores.
> My DB is under a heavy load and sometimes queries might get super slow.
> I guess it is doing too much and has many access patterns which don't let it optimize correctly.
>
> I wonder if introducing a slave replication (making all reads going to the slave,
> and writes to the master) will make my setup more performant.
> Are there any good metrics to measure before making such decision?
> I really want to be able to see the improvement in case I decide to go with setting a replication.

Before you decide on measures, you have to determine the cause of the problem.

- Is it I/O or CPU load?
- What queries are causing the biggest load?

Very often, a few CREATE INDEX can take care of the problem quite nicely.
Perhaps hiring a consultant can help.

For many I/O problems, increasing RAM is also a simple way to help.

Yours,
Laurenz Albe