[PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Lee Nguyen
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 were entertaining the idea of running our Postgres database on our VM farm alongside our

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Gavin Flower
On 26/11/13 09: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 were entertaining the idea of running our Postgres

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Heikki Linnakangas
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 were entertaining the idea of running our Postgres

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Andrew Dunstan
On 11/25/2013 03:19 PM, Heikki Linnakangas wrote: 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

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Mark Kirkwood
On 26/11/13 09:28, Andrew Dunstan wrote: On 11/25/2013 03:19 PM, Heikki Linnakangas wrote: 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

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Merlin Moncure
On Mon, Nov 25, 2013 at 2:01 PM, Lee Nguyen leemob...@gmail.com 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 were entertaining the

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread David Lang
On Mon, 25 Nov 2013, Merlin Moncure wrote: On Mon, Nov 25, 2013 at 2:01 PM, Lee Nguyen leemob...@gmail.com 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

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Merlin Moncure
On Mon, Nov 25, 2013 at 4:57 PM, David Lang da...@lang.hm wrote: On Mon, 25 Nov 2013, Merlin Moncure wrote: On Mon, Nov 25, 2013 at 2:01 PM, Lee Nguyen leemob...@gmail.com wrote: Hi, Having attended a few PGCons, I've always heard the remark from a few presenters and attendees that

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Xenofon Papadopoulos
We have been running several Postgres databases on VMs for the last 9 months. The largest one currently has a few hundreds of millions of rows (~1.5T of data, ~100G of frequently queried data ) and performs at ~1000 tps. Most of our transactions are part of a 2PC, which effectively results to high

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread David Lang
On Tue, 26 Nov 2013, Xenofon Papadopoulos wrote: We have been running several Postgres databases on VMs for the last 9 months. The largest one currently has a few hundreds of millions of rows (~1.5T of data, ~100G of frequently queried data ) and performs at ~1000 tps. Most of our transactions

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Xenofon Papadopoulos
Which scenario do you have in mind? We don't add servers to scale out, we only scale up in each single project. We use SAN for storage, so if we need to increase disk space we provide more through LVM. There is one case we need to move data around, when we relocate projects over to new storage