Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M213962=pgsql-general-arkari@postgresql.org>)
 id 1Z78zQ-0006ra-7f
 for pgsql-general@arkaria.postgresql.org; Mon, 22 Jun 2015 21:10:48 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-general-owner+M213962=pgsql-general-arkari@postgresql.org>)
 id 1Z78zO-0005kc-Bc
 for pgsql-general@arkaria.postgresql.org; Mon, 22 Jun 2015 21:10:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <suresh.rajaabc@gmail.com>)
 id 1Z78z9-0005S9-VT; Mon, 22 Jun 2015 21:10:32 +0000
Received: from mail-wi0-x22c.google.com ([2a00:1450:400c:c05::22c])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <suresh.rajaabc@gmail.com>)
 id 1Z78z2-0003gN-RL; Mon, 22 Jun 2015 21:10:30 +0000
Received: by wibdq8 with SMTP id dq8so87330563wib.1;
 Mon, 22 Jun 2015 14:10:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:date:message-id:subject:from:to:content-type;
 bh=LLOoIJP9AjQjSw2wi+CfYRJqbt6OhGRM7sKfpCoh0MA=;
 b=yO3AM68PIKpK9/xoMCprbKvX8gvOGO8po46AHa6+c1/iaE3SHVOwGJddylsRcSb1e3
 wSn+YBA91dtMaxR5VPl99VNScT6mqpzcSdniA7HfkQOh6cPGl5OS5280dKvMLw+WzMMo
 ij7q76/I/d3OJGpQXH3CwbYB62PcNaD4USnFAJf3HzUfDhadPceJwkT29oIh1SaUiGXO
 jU+bVaJX8Iml7p4tYrp2OO1nmUGY2adTKsqR+rgxLzRxpXYYCoeRxaqpL2Qg48gIuldf
 NCAWEmI1qNrqzTLHTQDzWc7XgdaKkGBTIawm+UElmHAyKpqYIOiaf9Z/3wGJbd/asfcO
 I20Q==
MIME-Version: 1.0
X-Received: by 10.194.2.161 with SMTP id 1mr53346621wjv.143.1435007423809;
 Mon, 22 Jun 2015 14:10:23 -0700 (PDT)
Received: by 10.194.198.179 with HTTP; Mon, 22 Jun 2015 14:10:23 -0700 (PDT)
Date: Mon, 22 Jun 2015 16:10:23 -0500
Message-ID: 
 <CAJP7dtDi4PDGOoxoAMDkr7bAz928mPvC21beNeCL9baAF11mRQ@mail.gmail.com>
Subject: Run analyze on schema
From: Suresh Raja <suresh.rajaabc@gmail.com>
To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=047d7b3a8410bf0fd7051921b39d
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

--047d7b3a8410bf0fd7051921b39d
Content-Type: text/plain; charset=UTF-8

>
> Hi All:
>
> Does postgresql support schema analyze.  I could not find analyze schema
> anywhere.  Can we create a function to run analyze and reindex on all
> objects in the schema.  Any suggestions or ideas.
>
> Thanks,
> -Suresh Raja
>

--047d7b3a8410bf0fd7051921b39d
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote"><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #c=
cc solid;padding-left:1ex"><div dir=3D"ltr">Hi All:<div><br></div><div>Does=
 postgresql support schema analyze.=C2=A0 I could not find analyze schema a=
nywhere.=C2=A0 Can we create a function to run analyze and reindex on all o=
bjects in the schema.=C2=A0 Any suggestions or ideas.</div><div><br></div><=
div>Thanks,</div><div>-Suresh Raja</div></div>
</blockquote></div><br></div></div>

--047d7b3a8410bf0fd7051921b39d--