Re: [PERFORM] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

2011-11-13 Thread Lucas Mocellin
how about your harddisks?? you could get a little help from a RAID10 SAS 15k disks. if you don't even have RAID, it would help a lot! Lucas. 2011/11/8 Sam Gendler > > > Sent from my iPhone > > On Nov 7, 2011, at 7:21 PM, Mohamed Hashim wrote: > > Hi all, > > Thanks for all your responses. > >

[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