Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aPBJD-0002jW-Mn for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Jan 2016 15:50:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aPBJD-0006h2-0n for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Jan 2016 15:50:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aPBJB-0006gp-Vx for pgsql-hackers@postgresql.org; Fri, 29 Jan 2016 15:50:02 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aPBJ4-0005TM-Gu for pgsql-hackers@postgresql.org; Fri, 29 Jan 2016 15:50:00 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 5F51521C5D9E; Fri, 29 Jan 2016 18:49:52 +0300 (MSK) Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id D11i2XVRgvxD; Fri, 29 Jan 2016 18:49:48 +0300 (MSK) Received: from fujitsu (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 9AE2021C5D90; Fri, 29 Jan 2016 18:49:48 +0300 (MSK) Date: Fri, 29 Jan 2016 18:47:33 +0300 From: Aleksander Alekseev To: Anastasia Lubennikova Cc: pgsql-hackers@postgresql.org, Thom Brown Subject: Re: [WIP] Effective storage of duplicates in B-tree index. Message-ID: <20160129184733.2ca9026a@fujitsu> In-Reply-To: <56AB6D30.2040900@postgrespro.ru> References: <55E4051B.7020209@postgrespro.ru> <56AA2081.1080001@postgrespro.ru> <56AA3E06.8040006@postgrespro.ru> <56AB6D30.2040900@postgrespro.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org I tested this patch on x64 and ARM servers for a few hours today. The only problem I could find is that INSERT works considerably slower after applying a patch. Beside that everything looks fine - no crashes, tests pass, memory doesn't seem to leak, etc. > Okay, now for some badness. I've restored a database containing 2 > tables, one 318MB, another 24kB. The 318MB table contains 5 million > rows with a sequential id column. I get a problem if I try to delete > many rows from it: > # delete from contacts where id % 3 != 0 ; > WARNING: out of shared memory > WARNING: out of shared memory > WARNING: out of shared memory I didn't manage to reproduce this. Thom, could you describe exact steps to reproduce this issue please? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers