Re: Postgresql 9.1 on VMWare ESXi 5.0

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 9.1 on VMWare ESXi 5.0
Date: 2012-08-24 03:14:11
Message-ID: 5036F183.4090507@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sébastien Lorion 2012-08-24 04:22:47 Re: Amazon High I/O instances
Previous Message Ondrej Ivanič 2012-08-24 02:48:38 Re: At what point does a big table start becoming too big?