Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5FB1116C3ADF for ; Wed, 11 Jul 2012 23:20:47 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sp91K-0001df-Ii for pgsql-performance@postgresql.org; Thu, 12 Jul 2012 02:20:46 +0000 Received: by pbbrp8 with SMTP id rp8so2935127pbb.19 for ; Wed, 11 Jul 2012 19:20:34 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:x-gm-message-state; bh=nSZiPLjt2yYxUXBHCBXx75qlRJEaxM7FcVaAXhafWaQ=; b=lXlMBW61wMzg/TiijsHfrAUOoGLdtmTGYWZtSO8Xuyk57KoY37Xubwulj27A9SVWkW zo6NeKQ/7UVyxAo9DaVF8skdmeTXAbZxfmuEty7olZX27Hx0bAlEwoUBwWwiIaBBiKQN D0x8N46nCp15EaqxFUmyh3qaBSQ8EbM+JKogmCL6yA39f+6FNPjZv276VZISW7xuYzTw S4gyqUuSyqnCC6uFa7XekeEa5B/YaIok+pS9w0dL0AiPzr/+5OnXUAiX0YgQNQiWFhi9 26rnOgSlgOcupENG8Ei/Zn4/12/8ww/hrXnT4QDYGOs1ss2GHfJf3cMvoTqs0gO819Nh RBmg== Received: by 10.68.223.129 with SMTP id qu1mr1013139pbc.165.1342059633800; Wed, 11 Jul 2012 19:20:33 -0700 (PDT) Received: from ayaki.localdomain (office1.postnewspapers.com.au. [150.101.171.128]) by mx.google.com with ESMTPS id to1sm2828102pbc.27.2012.07.11.19.20.29 (version=SSLv3 cipher=OTHER); Wed, 11 Jul 2012 19:20:31 -0700 (PDT) Message-ID: <4FFE346A.7030402@ringerc.id.au> Date: Thu, 12 Jul 2012 10:20:26 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120605 Thunderbird/13.0 MIME-Version: 1.0 To: Yan Chunlu CC: Albe Laurenz , "pgsql-performance@postgresql.org" Subject: Re: how could select id=xx so slow? References: <4FFB848D.7080900@ringerc.id.au> <4FFB9781.60601@ringerc.id.au> <4FFE17CF.1050601@ringerc.id.au> In-Reply-To: Content-Type: multipart/alternative; boundary="------------010907010306060305080308" X-Gm-Message-State: ALoCoQl36ofi1cdDfkZMzSOi7HbHIyxCHMxtx1IJJ6JsZZBSwp3VbwthOWnthHWN/d+ypZAXinRY X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/149 X-Sequence-Number: 47330 This is a multi-part message in MIME format. --------------010907010306060305080308 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------010907010306060305080308 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
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
--------------010907010306060305080308--