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 virtual and physical, compare. If it's
complicated, post both to explain.depesz.com .
Examine `iostat`, `vmstat` and `top` to see where the bottlenecks lie.
etc.
--
Craig Ringer