Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aHZoI-0003xS-Od for pgsql-admin@arkaria.postgresql.org; Fri, 08 Jan 2016 16:22:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aHZoI-0000QK-BM for pgsql-admin@arkaria.postgresql.org; Fri, 08 Jan 2016 16:22:42 +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 ) id 1aHZmd-0006ys-8D for pgsql-admin@postgresql.org; Fri, 08 Jan 2016 16:20:59 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aHZmY-0004x6-OK for pgsql-admin@postgresql.org; Fri, 08 Jan 2016 16:20:58 +0000 Received: from mn3.etecsa.cu (unknown [192.168.91.45]) by imx6.etecsa.cu (Postfix) with ESMTP id 1B99EBF for ; Fri, 8 Jan 2016 11:20:49 -0500 (CST) Received: (qmail 7592 invoked by uid 11185); 8 Jan 2016 16:20:00 -0000 Received: from 192.168.91.6 by mn3.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.023425 secs); 08 Jan 2016 16:20:00 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 8 Jan 2016 16:20:00 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Fri, 8 Jan 2016 11:20:48 -0500 (GMT+5) Message-ID: <51229.192.168.207.54.1452270048.squirrel@webmail.etecsa.cu> In-Reply-To: <568FE034.7070702@uvic.ca> References: <568FE034.7070702@uvic.ca> Date: Fri, 8 Jan 2016 11:20:48 -0500 (GMT+5) Subject: Re: [MASSMAIL]index bloat - fixed in which version From: "Gilberto Castillo" To: "Evan Rempel" Cc: pgsql-admin@postgresql.org Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 89322 [Jan 08 2016] X-KLMS-AntiSpam-Version: 5.5.6 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Moebius-Timestamps: 3902947, 3902987, 3902535 X-KLMS-AntiSpam-Info: LuaCore: 393 393 c2c6794cec399221a2b2ea37c1235b8c69404071, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2015/12/30 13:07:41 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2016/01/08 10:36:00 #7027504 X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > I have a database the has a huge amount of new and old deleted records (3 > million a day). I remember reading somewhere that a particular > version/update of postgresql reused deleted index entries so that the size > of the index on disk did not grow indefinitely due to deleted index > entries. > > Can anyone provide a link to such a reverence, or at let me know which > version(s) addressed the index bloat? > Evan, you used vaccum?. Rgds, Gilberto Castillo ETECSA, La Habana, Cuba -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin