Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 8B64B2B2862 for ; Mon, 25 Jun 2012 07:57:03 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sj6yc-0006l2-DR for pgsql-admin@postgresql.org; Mon, 25 Jun 2012 10:57:03 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 25 Jun 2012 05:56:49 -0500 Message-Id: <4FE7FD9A0200002500048A5A@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Mon, 25 Jun 2012 05:56:42 -0500 From: "Kevin Grittner" To: , Subject: Re: a very slow SQL Mime-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201206/113 X-Sequence-Number: 39704 wangqi wrote: =20 > An SQL execution is very slow. > What can I do to makes it faster=A1=A3 =20 Without knowing more about the version of PostgreSQL, your PostgreSQL configuration, your schema (including indexes), and your hardware, it=27s hard to give advice. =20 http://wiki.postgresql.org/wiki/SlowQueryQuestions =20 A wild guess on the evidence we have is that you might benefit from an index on MCL.ctid if you don=27t already have one. =20 -Kevin