Re: [PERFORM] Configuration tips for very large database

2015-02-13 Thread Graeme B. Bell
Hi Nico, No one has mentioned the elephant in the room, but a database can be very I/O intensive and you may not be getting the performance you need from your virtual disk running on your VMware disk subsystem. What do IOmeter or other disk performance evaluation software report?

Re: [PERFORM] Configuration tips for very large database

2015-02-13 Thread k...@rice.edu
On Thu, Feb 12, 2015 at 11:25:54PM +0100, Nico Sabbi wrote: Hello, I've been away from postgres for several years, so please forgive me if I forgot nearly everything:-) I've just inherited a database collecting environmental data. There's a background process continually inserting records