Dear Pg people,
I would ask for your help considering this scaling issue. We are planning to
move from 3Millions of events/day instance of postgres (8 CPU, 65 gb ram) to 5
millions of items/day.
What do you suggest in order to plan this switch? Add separate server? Increase
RAM? Use SSD?
Any
On Fri, Oct 03, 2014 at 10:55:04AM +0200, Roberto Grandi wrote:
Dear Pg people,
I would ask for your help considering this scaling issue. We are planning to
move from 3Millions of events/day instance of postgres (8 CPU, 65 gb ram) to
5 millions of items/day.
What do you suggest in order
: [PERFORM] Planning for Scalability
On Fri, Oct 03, 2014 at 10:55:04AM +0200, Roberto Grandi wrote:
Dear Pg people,
I would ask for your help considering this scaling issue. We are planning to
move from 3Millions of events/day instance of postgres (8 CPU, 65 gb ram) to
5 millions of items/day
Hi Roberto,
Hardware etc. is a solution; but you have not yet characterised the problem.
You should investigate if the events are mostly...
- reads
- writes
- computationally intensive
- memory intensive
- I/O intensive
- network I/O intensive
- independent? (e.g. does it matter if you
On Fri, Oct 3, 2014 at 5:55 AM, Roberto Grandi
roberto.gra...@trovaprezzi.it wrote:
Dear Pg people,
I would ask for your help considering this scaling issue. We are planning to
move from 3Millions of events/day instance of postgres (8 CPU, 65 gb ram) to
5 millions of items/day.
The most