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 repor

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 rec