Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id ED061B5DC06 for ; Wed, 20 Jul 2011 16:58:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 81693-10 for ; Wed, 20 Jul 2011 19:58:20 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm30.bullet.mail.ne1.yahoo.com (nm30.bullet.mail.ne1.yahoo.com [98.138.90.93]) by mail.postgresql.org (Postfix) with SMTP id E7A02B5DC02 for ; Wed, 20 Jul 2011 16:58:19 -0300 (ADT) Received: from [98.138.90.51] by nm30.bullet.mail.ne1.yahoo.com with NNFMP; 20 Jul 2011 19:58:19 -0000 Received: from [98.138.89.168] by tm4.bullet.mail.ne1.yahoo.com with NNFMP; 20 Jul 2011 19:58:19 -0000 Received: from [127.0.0.1] by omp1024.mail.ne1.yahoo.com with NNFMP; 20 Jul 2011 19:58:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 222344.91938.bm@omp1024.mail.ne1.yahoo.com Received: (qmail 53200 invoked by uid 60001); 20 Jul 2011 19:58:18 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1311191898; bh=zraqFQY5A6x1Sujs7cyIu8iuqyGZXmeAYS+Mc8TySMc=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=yfBVW5GyzWDByLS0ZBvPleeGv27IvgzWeaN14fM73fTRoLZiK/kKBdJVKzOUIXrwjmFvIrDfmHc3TTiZyLvEd5nqayIBciflRHslCyHx0xQeT9ueaNjUXAcy6PgJXuYu6ea7ajpAaO7rqeKuAqcW7ZzFhXy1nqdKTJi2cIHRdiE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=h0XJbksZ9zQhUMdVRHHk/lmZXkFcKqPRyMzgv1yFssXs0Q/KUTNy3omJHJNt3/8hpZW6fgMGC4MsmihjBjnli0QQwnY762L2afWlYm0XV4BuPgg2pTdavXjFGFxLHdIMrlNRWUNHNTMcirRNLGGFvD1Tf3Jg9ZyLYaXx2uRUlIQ=; X-YMail-OSG: Sb0f7dIVM1l5OoJeoDWFjBLuiUgWcXW.0BtLX0y.l0f8hrL i6luBXY3Q4x2d0Bdex8kWDogMI1P2RGs6NdJOOzqIgbWFdF_E3SGWzyIW..b VO6jAzXqBXKWMO9fJqlwXXWN0R600tAAgJJsAkmpSujHK8av8Y6nQTLk61be grRwijNHF9lirL4EJbTcBgEMYR5U2U8vKgb2bkupeaE0iml4v98uLuIxIYNV oEELyL9QSx5viCrYLS_QxqIwAhKA4ypSkBHQZbotRGtQnhMmGSsUDvkM4sBK yQSmjLJrz4S6rOVLl3CLpFXmnxk0zL956wFgX.TdFPGo87nL4ZRo- Received: from [64.61.91.74] by web120015.mail.ne1.yahoo.com via HTTP; Wed, 20 Jul 2011 12:58:18 PDT X-Mailer: YahooMailWebService/0.8.112.310352 Message-ID: <1311191898.49250.YahooMailNeo@web120015.mail.ne1.yahoo.com> Date: Wed, 20 Jul 2011 12:58:18 -0700 (PDT) From: A J Reply-To: A J Subject: How frequently to defrag(cluster) To: PG Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-294825442-1311191898=:49250" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.091 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-1.193 X-Spam-Level: X-Archive-Number: 201107/148 X-Sequence-Number: 37927 --0-294825442-1311191898=:49250 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I understand that 'cluster' performs the role of defrag (along with rewriti= ng in index order) in Postgres.=0AHow frequently does one have to run clust= er ? Any thumb-rules =A0or experience ? How do I find if my table is fragme= nted enough to need a cluster ?=0AWe are still to use Postgres in productio= n, just evaluating at this point.=0A=0AThanks for any pointers. --0-294825442-1311191898=:49250 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I understand tha= t 'cluster' performs the role of defrag (along with rewriting in index orde= r) in Postgres.
How frequently does one have to run cluster ? Any= thumb-rules  or experience ? How do I find if my table is fragmented = enough to need a cluster ?
We are still to use Postgres in produc= tion, just evaluating at this point.

Thanks for an= y pointers.
--0-294825442-1311191898=:49250--