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 (eg

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 a

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 Merlin Moncure
On Mon, Nov 25, 2013 at 4:57 PM, David Lang wrote: > On Mon, 25 Nov 2013, Merlin Moncure wrote: > >> On Mon, Nov 25, 2013 at 2: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

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 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 Merlin Moncure
On Mon, Nov 25, 2013 at 2: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. > > Here at work we were entertaining the idea of runni

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 t

Re: [PERFORM] Postgresql in a Virtual Machine

2013-11-25 Thread Gudmundsson Martin (mg)
Hi! We have virtualized several hundreds of production databases, mostly Oracle and DB2 but a few postgres as well, and we have seen a very positive effect in doing this. We might loose a little bit in virtualization overhead but have gained a lot in flexibility and managebility. My tips are t

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 were

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 databas

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 datab

[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 applicatio