Re: [PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-11 Thread Dan Langille
> On Feb 10, 2016, at 5:13 AM, Dan Langille wrote: > >> On Feb 10, 2016, at 2:47 AM, Jeff Janes wrote: >> >> On Tue, Feb 9, 2016 at 4:09 PM, Dan Langille wrote: >>> I have a wee database server which regularly tries to insert 1.5 million or >>> even 15 million new rows into a 400 million row t

[PERFORM] Architectural question

2016-02-11 Thread Moreno Andreo
Hi everyone, I have a question that I hope fits in this discussion group. I'm migrating my actual server into a new, more powerful architecture on Google Cloud Platform. ATM the server is a VM with 4 vCPUs (the host has 4 Xeon E2xx 3,1 GHZ, if I remember) and 32 GB RAM, just running Ubuntu