Re: Postgresql 9.1 on VMWare ESXi 5.0 - Mailing list pgsql-general

From Craig Ringer
Subject Re: Postgresql 9.1 on VMWare ESXi 5.0
Date
Msg-id 5036F183.4090507@ringerc.id.au
Whole thread Raw
In response to Postgresql 9.1 on VMWare ESXi 5.0  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Postgresql 9.1 on VMWare ESXi 5.0  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: At what point does a big table start becoming too big?
Next
From: Sébastien Lorion
Date:
Subject: Re: Amazon High I/O instances