Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bDCYX-0002eR-NX for pgsql-performance@arkaria.postgresql.org; Wed, 15 Jun 2016 15:16:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bDCYX-0004yh-2I for pgsql-performance@arkaria.postgresql.org; Wed, 15 Jun 2016 15:16:37 +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_2) (envelope-from ) id 1bDCWq-0002ro-ID for pgsql-performance@postgresql.org; Wed, 15 Jun 2016 15:14:52 +0000 Received: from mail-vk0-x22f.google.com ([2607:f8b0:400c:c05::22f]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bDCWm-0004ba-8C for pgsql-performance@postgresql.org; Wed, 15 Jun 2016 15:14:51 +0000 Received: by mail-vk0-x22f.google.com with SMTP id u64so33775797vkf.3 for ; Wed, 15 Jun 2016 08:14:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=gOqblg6GpkWZKghJvyhCE+vWb+lFjkWg/nWUjMsbCZI=; b=JxLMiDGmUjoeiLwHFG5yG45wY8wwb25SNytyYoGtiGhJVlKelCX/JgUC9+rsH/BhmJ ZGK7caMTcnLMK0KLnuSU5rfks/LEjNSApi40PNtVJnJ76GD0H/+vUXtEANwnpnVxT3hx hn++1PVORUVip0Zz5QAMXrHfudZKUV+1AROzDikFLArurlXwDUBHZrlPDEhYvjkdCGvN CM+Kc7m0MvxZYpzxOL5tg6aCKiC1nW2rXn8nw+5xqYRKh26UG7TEUx4DDcqvQt8oDBSd F1ooBRVpOwsGXYs9g5AsNwFX+4X0VH5i1Sln0cpZ7BUlglBOOTJkBY9e077JcoHtfboJ qHFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=gOqblg6GpkWZKghJvyhCE+vWb+lFjkWg/nWUjMsbCZI=; b=RGValeNep80R5RJ/XxkfrPpg53cXleEPxkvbf6onTm37tGOMF53Dm95tMZj6n2q7Yh T8KapvX5lR1JShntkgmjiUjcqvnwHkpoVlRs2Ms1Loxr6p/VuOw08KVrMejjDN3t2Q68 YB1FyULX0l4bHuIopc94ThVycFhdoAyv0xd395rGcmUHjFMqMPEHGGbxPRN8OJJcjw1R QVviia8IKWXy4lVNh92jJoOmckCWaVIOWaUSW1roIpUqiT2DfwVMfC+N3MJjjAsDI13w G40N6yxGxNHsx08fi+od1JQvyvEMqgzbOn3h0PRgZI/8Ag+z3HmUGLoVce7EUw7R75O5 axpA== X-Gm-Message-State: ALyK8tL0Uj9DPw5VPoGgP4xhP3kfx2PA+0C81jpi7KTYI7Mxh/vn07NcG86n8jQFCXefuJQgARLk/Y/SFkrAIw== X-Received: by 10.176.0.145 with SMTP id 17mr11450434uaj.103.1466003686672; Wed, 15 Jun 2016 08:14:46 -0700 (PDT) MIME-Version: 1.0 Received: by 10.103.131.204 with HTTP; Wed, 15 Jun 2016 08:14:45 -0700 (PDT) In-Reply-To: <20160615131614.GM25300@aart.rice.edu> References: <20160615130307.GL25300@aart.rice.edu> <20160615131614.GM25300@aart.rice.edu> From: Jeff Janes Date: Wed, 15 Jun 2016 08:14:45 -0700 Message-ID: Subject: Re: Indexes for hashes To: "ktm@rice.edu" Cc: Ivan Voras , postgres performance list Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Wed, Jun 15, 2016 at 6:16 AM, ktm@rice.edu wrote: > On Wed, Jun 15, 2016 at 03:09:04PM +0200, Ivan Voras wrote: >> On 15 June 2016 at 15:03, ktm@rice.edu wrote: >> >> >> I don't suppose there's an effort in progress to make hash indexes use WAL? >> :D > > Hi Ivan, > > Several people have looked at it but it has not made it to the top of anyone's > to-do list. I don't know if it is the top of his todo list, but Amit seems pretty serious about it: https://www.postgresql.org/message-id/CAA4eK1LfzcZYxLoXS874Ad0+S-ZM60U9bwcyiUZx9mHZ-KCWhw@mail.gmail.com I hope to give him some help if I get a chance. Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance