[GENERAL] Postgresql 9.1 on VMWare ESXi 5.0

2012-08-23 Thread Edson Richter
Dear friends, Anyone has experienced extreme slowness running PostgreSQL 9.1.4 on virtualized CentOS 5.8 on VMware ESXi 5.0 (with all Paravirtualized drivers)? By extreme slowness, consider a query that brings one record from a table with 5000 records (using the PK as criteria) takes 200ms..

Re: [GENERAL] Postgresql 9.1 on VMWare ESXi 5.0

2012-08-23 Thread Craig Ringer
On 08/24/2012 10:18 AM, Edson Richter wrote: Dear friends, Anyone has experienced extreme slowness running PostgreSQL 9.1.4 on virtualized CentOS 5.8 on VMware ESXi 5.0 (with all Paravirtualized drivers)? https://wiki.postgresql.org/wiki/Slow_Query_Questions Examine `EXPLAIN ANALYZE` for virt

Re: [GENERAL] Postgresql 9.1 on VMWare ESXi 5.0

2012-08-25 Thread Edson Richter
Em 24/08/2012 00:14, Craig Ringer escreveu: On 08/24/2012 10:18 AM, Edson Richter wrote: Dear friends, Anyone has experienced extreme slowness running PostgreSQL 9.1.4 on virtualized CentOS 5.8 on VMware ESXi 5.0 (with all Paravirtualized drivers)? https://wiki.postgresql.org/wiki/Slow_Query_