pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Craig Ringer <ringerc@ringerc.id.au>
To: Yan Chunlu <springrider@gmail.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: how could select id=xx so slow?
Date: Thu, 12 Jul 2012 10:20:26 +0800
Message-ID: <4FFE346A.7030402@ringerc.id.au> (raw)
In-Reply-To: <CAOA66tF1M+S=m-7mU=TV91_hkxdcb1T8vwSwb-KRFOrdgBqWwA@mail.gmail.com>
References: <CAOA66tEJLDOt4JpJ0RwOEsgizfQPWkCHd+SgT7kbiHix_io18A@mail.gmail.com>
	<D960CB61B694CF459DCFB4B0128514C2081BF021@exadv11.host.magwien.gv.at>
	<CAOA66tF8dAzAS9wG381bhp+AiC2LrzcF7MDmOxvgW0p07rMNtw@mail.gmail.com>
	<4FFB848D.7080900@ringerc.id.au>
	<CAOA66tEe4m8OQQ+26AKxrreEF458R-983UVMARZ6zeqEkZxwCQ@mail.gmail.com>
	<4FFB9781.60601@ringerc.id.au>
	<CAOA66tEiZ+OrU6mRutVq6Vksa6tRsgQYvB4erSNUpWx7t8LksQ@mail.gmail.com>
	<D960CB61B694CF459DCFB4B0128514C2082464D4@exadv11.host.magwien.gv.at>
	<CAOA66tE9PwbQ07+g9=HhbVwqXosy=Tb=M51NwSpoAmh5LvnVnw@mail.gmail.com>
	<4FFE17CF.1050601@ringerc.id.au>
	<CAOA66tF1M+S=m-7mU=TV91_hkxdcb1T8vwSwb-KRFOrdgBqWwA@mail.gmail.com>

On 07/12/2012 08:47 AM, Yan Chunlu wrote:
> Really sorry for the lack of information
I shouldn't have grumped like that either, sorry about that.

> I didn't mention the connections  number because I don't think my app 
> is that busy, and the large number connections was caused by slow queries.

Yep - assumptions are a killer like that.

Now you know to watch your system load with iostat, vmstat, top, etc and 
to monitor your overall load.

--
Craig Ringer

view thread (25+ messages)  latest in thread

Message-ID: <4FFE346A.7030402@ringerc.id.au>
Permalink:  ../4FFE346A.7030402@ringerc.id.au/
Also on:    postgresql.org/message-id/4FFE346A.7030402@ringerc.id.au

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ringerc@ringerc.id.au, springrider@gmail.com, laurenz.albe@wien.gv.at
  Subject: Re: how could select id=xx so slow?
  In-Reply-To: <4FFE346A.7030402@ringerc.id.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox