On 12/07/11 1:27 AM, Andre Lopes wrote:
This is enough information for some clues on how to increase the
response time in queries?
no.
to optimize queries, you generally need to know what the queries are,
what the relations they are using look like, and get the output of
`explain analyze <your query>;`
some random comments in passing...
* whats mysql got to do with this?
* a server running efficiently should be using zero swap. the fact
that you have 340MB of swap used implies you need at least twice as
much physical memory as you have.
* VPS? as in virtual server? so your disk IO is virtualized too?
this is usually bad news for getting decent database performance.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
