Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread David Kerr
On Tue, Nov 26, 2013 at 11:18:41AM -0800, Craig James wrote: - On Tue, Nov 26, 2013 at 10:40 AM, Ben Chobot wrote: - - > On Nov 26, 2013, at 9:24 AM, Craig James wrote: - > - > So far I'm impressed by what I've read about Amazon's Postgres instances. - > Maybe the reality will be disappointing, b

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Craig James
On Tue, Nov 26, 2013 at 10:40 AM, Ben Chobot wrote: > On Nov 26, 2013, at 9:24 AM, Craig James wrote: > > So far I'm impressed by what I've read about Amazon's Postgres instances. > Maybe the reality will be disappointing, but (for example) the idea of > setting up streaming replication with one

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Ben Chobot
On Nov 26, 2013, at 9:24 AM, Craig James wrote: > So far I'm impressed by what I've read about Amazon's Postgres instances. > Maybe the reality will be disappointing, but (for example) the idea of > setting up streaming replication with one click is pretty appealing. Where did you hear this was

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Merlin Moncure
On Tue, Nov 26, 2013 at 11:31 AM, Josh Berkus wrote: > On 11/25/2013 12:01 PM, Lee Nguyen wrote: >> Hi, >> >> Having attended a few PGCons, I've always heard the remark from a few >> presenters and attendees that Postgres shouldn't be run inside a VM. That >> bare metal is the only way to go. > >

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Josh Berkus
On 11/25/2013 12:01 PM, Lee Nguyen wrote: > Hi, > > Having attended a few PGCons, I've always heard the remark from a few > presenters and attendees that Postgres shouldn't be run inside a VM. That > bare metal is the only way to go. This is pretty dated advice. Early VMs had horrible performanc

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Craig James
On Tue, Nov 26, 2013 at 8:29 AM, David Boreham wrote: > On 11/26/2013 7:26 AM, Craig James wrote: > >> >> For those of us with small (a few to a dozen servers), we'd like to get >> out of server maintenance completely. Can anyone with experience on a cloud >> VM solution comment? ... >> > > I've

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread David Boreham
On 11/26/2013 7:26 AM, Craig James wrote: For those of us with small (a few to a dozen servers), we'd like to get out of server maintenance completely. Can anyone with experience on a cloud VM solution comment? Do the VM solutions provided by the major hosting companies have the same good pe

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Andrew Dunstan
On 11/26/2013 08:51 AM, Boszormenyi Zoltan wrote: 2013-11-25 21:19 keltezéssel, Heikki Linnakangas írta: On 25.11.2013 22:01, Lee Nguyen wrote: Hi, Having attended a few PGCons, I've always heard the remark from a few presenters and attendees that Postgres shouldn't be run inside a VM. That

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Andrew Dunstan
On 11/26/2013 09:26 AM, Craig James wrote: On 25.11.2013 22:01, Lee Nguyen wrote: Why shouldn't we run Postgres in a VM? What are the downsides? Does anyone have any metrics or benchmarks with the latest Postgres? For those of us with small (a fe

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Craig James
> > On 25.11.2013 22:01, Lee Nguyen wrote: >> >>> >>> Why shouldn't we run Postgres in a VM? What are the downsides? Does >>> anyone >>> have any metrics or benchmarks with the latest Postgres? >>> >> For those of us with small (a few to a dozen servers), we'd like to get out of server maintenance

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Stephen Frost
Zoltan, * Boszormenyi Zoltan (z...@cybertec.at) wrote: > When the virtual disk is a disk file on the host machine, we've measured > 20% or lower. The host used Fedora 19/x86_64 with IIRC a 3.10.x Linux kernel > with EXT4 filesystem (this latter is sure, not IIRC). The effect was observed > both un

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Boszormenyi Zoltan
2013-11-25 21:19 keltezéssel, Heikki Linnakangas írta: On 25.11.2013 22:01, Lee Nguyen wrote: Hi, Having attended a few PGCons, I've always heard the remark from a few presenters and attendees that Postgres shouldn't be run inside a VM. That bare metal is the only way to go. Here at work we we

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-26 Thread Rafael Martinez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/25/2013 09:01 PM, Lee Nguyen wrote: > Hi, > > Having attended a few PGCons, I've always heard the remark from a > few presenters and attendees that Postgres shouldn't be run inside > a VM. That bare metal is the only way to go. > []