Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id C79EB1F6FE32
	for <pgsql-performance@postgresql.org>;
	Wed, 11 Jul 2012 21:18:49 -0300 (ADT)
Received: from mail-gg0-f174.google.com ([209.85.161.174])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1Sp77E-0000y8-HB
	for pgsql-performance@postgresql.org; Thu, 12 Jul 2012 00:18:48 +0000
Received: by gglu4 with SMTP id u4so1879153ggl.19
	for <pgsql-performance@postgresql.org>;
	Wed, 11 Jul 2012 17:18:30 -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=93irW0uA5wRDPImYtWYJA7eKRxZ8Ww5KBgrV/8LlZNQ=;
	b=LuXdVIm4UKEQyb7CUNwoMAx8sQ8cwwzT3mFp3hiWLwCc2+n/QawpJslJPon09DwDyy
	w0veO3MTb1yMFYqCnqDLQldSQLUSymTdL5ZSh5zTEoAb3292x2vuQ9hrukg7U3HyHKfS
	rfm/VL+i5ejPj28tMLGaGGc5MlRdvgrAL7RqEgzTzPuTOydHHtHWV8eEtkgr/192ec0b
	DBIQFYclRroBW6k5DZ9POf76wKwl2v08WAtYDnO+LBhgLnwLP/h5D6JX4ZMfcXiU8Q/v
	XXMmgnN2W9/dI9mgKinjN90WQjNscHq40HQ2kg8w3SR2TSrjVv4iobpOavh3nsqhlPqA
	t7WQ==
Received: by 10.66.76.130 with SMTP id k2mr15691260paw.19.1342052310265;
	Wed, 11 Jul 2012 17:18:30 -0700 (PDT)
Received: from ayaki.localdomain (58-6-46-2.dyn.iinet.net.au. [58.6.46.2])
	by mx.google.com with ESMTPS id op10sm2632426pbc.75.2012.07.11.17.18.26
	(version=SSLv3 cipher=OTHER); Wed, 11 Jul 2012 17:18:29 -0700 (PDT)
Message-ID: <4FFE17CF.1050601@ringerc.id.au>
Date: Thu, 12 Jul 2012 08:18:23 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Yan Chunlu <springrider@gmail.com>
CC: Albe Laurenz <laurenz.albe@wien.gv.at>, pgsql-performance@postgresql.org
Subject: Re: how could select id=xx so slow?
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>
In-Reply-To: 
 <CAOA66tE9PwbQ07+g9=HhbVwqXosy=Tb=M51NwSpoAmh5LvnVnw@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------060305070205010007090906"
X-Gm-Message-State: 
 ALoCoQn7OhXfxqanwJa1l7utEYE1BBDO2wGksAaBH2hutVDQa1oaZecWxwouHnMo0CD4yeJbYedq
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201207/143
X-Sequence-Number: 47324

This is a multi-part message in MIME format.
--------------060305070205010007090906
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 07/11/2012 07:40 PM, Yan Chunlu wrote:
> could that because of my system is really busy?
> 1, postgresql always have 400+ connections(dozens of python process 
> using client pool)
> 2, the query peak is 50+/s
> 3, I do have some bad performance sql executing periodically, need 
> 100+ second to complete. could those bad performance sql influence 
> others?  because when I execute those simple sql directly, they was 
> fast. but the slow query log shows it took too much time.
>
Oh, come on, these are the sorts of things you tell us /when you ask 
your question/, not days later after lots of back-and-forth discussion.

--
Craig Ringer

--------------060305070205010007090906
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 07/11/2012 07:40 PM, Yan Chunlu
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAOA66tE9PwbQ07+g9=HhbVwqXosy=Tb=M51NwSpoAmh5LvnVnw@mail.gmail.com"
      type="cite">
      <meta http-equiv="Context-Type" content="text/html;
        charset=ISO-8859-1">
      could that because of my system is really busy?&nbsp;
      <div>1, postgresql always have 400+ connections(dozens of python
        process using client pool)</div>
      <div>2, the query peak is 50+/s</div>
      <div>3, I do have some bad performance sql executing periodically,
        need 100+ second to complete. could those bad performance sql
        influence others? &nbsp;because when I execute those simple sql
        directly, they was fast. but the slow query log shows it took
        too much time.</div>
      <div><br>
      </div>
    </blockquote>
    Oh, come on, these are the sorts of things you tell us <i>when you
      ask your question</i>, not days later after lots of back-and-forth
    discussion.<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------060305070205010007090906--