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
Subject: Re: how could select id=xx so slow?
Date: Thu, 12 Jul 2012 08:18:23 +0800
Message-ID: <4FFE17CF.1050601@ringerc.id.au> (raw)
In-Reply-To: <CAOA66tE9PwbQ07+g9=HhbVwqXosy=Tb=M51NwSpoAmh5LvnVnw@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>

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

view thread (25+ messages)  latest in thread

Message-ID: <4FFE17CF.1050601@ringerc.id.au>
Permalink:  ../4FFE17CF.1050601@ringerc.id.au/
Also on:    postgresql.org/message-id/4FFE17CF.1050601@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: <4FFE17CF.1050601@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