Re: [PERFORM] Planning for Scalability

2014-10-03 Thread Claudio Freire
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

Re: [PERFORM] Planning for Scalability

2014-10-03 Thread Graeme B. Bell
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

Re: [PERFORM] Planning for Scalability

2014-10-03 Thread Roberto Grandi
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

Re: [PERFORM] Planning for Scalability

2014-10-03 Thread k...@rice.edu
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