On Fri, Oct 3, 2014 at 5:55 AM, 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.
The most important hardware part the
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 split
Dear All
thanks for your precious help. I'll come back to the list once analyzed our
system.
Roberto
- Messaggio originale -
Da: k...@rice.edu
A: "Roberto Grandi"
Cc: pgsql-performance@postgresql.org
Inviato: Venerdì, 3 ottobre 2014 15:00:03
Oggetto: Re: [PERFOR
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 or