Re: [PERFORM] PostgreSQL perform poorly on VMware ESXi

2011-11-07 Thread Ivan Voras
On 07/11/2011 11:36, Lucas Mocellin wrote: > Hi everybody, > > I'm having some issues with PostgreSQL 9.03 running on FreeBSD 8.2 on top > of VMware ESXi 4.1 U1. I hope your hardware is Nehalem-based or newer... > The problem is query are taking too long, and some times one query "blocks" > ever

Re: [PERFORM] PostgreSQL perform poorly on VMware ESXi

2011-11-07 Thread k...@rice.edu
On Mon, Nov 07, 2011 at 08:36:10AM -0200, Lucas Mocellin wrote: > Hi everybody, > > I'm having some issues with PostgreSQL 9.03 running on FreeBSD 8.2 on top > of VMware ESXi 4.1 U1. > > The problem is query are taking too long, and some times one query "blocks" > everybody else to use the DB as

Re: [PERFORM] PostgreSQL perform poorly on VMware ESXi

2011-11-07 Thread Tomas Vondra
On 7 Listopad 2011, 11:36, Lucas Mocellin wrote: > Hi everybody, > > I'm having some issues with PostgreSQL 9.03 running on FreeBSD 8.2 on top > of VMware ESXi 4.1 U1. > > The problem is query are taking too long, and some times one query > "blocks" > everybody else to use the DB as well. > > I'm a

[PERFORM] PostgreSQL perform poorly on VMware ESXi

2011-11-07 Thread Lucas Mocellin
Hi everybody, I'm having some issues with PostgreSQL 9.03 running on FreeBSD 8.2 on top of VMware ESXi 4.1 U1. The problem is query are taking too long, and some times one query "blocks" everybody else to use the DB as well. I'm a network administrator, not a DBA, so many things here can be "new