Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dO9dI-0005qu-Es for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Jun 2017 21:27:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dO9dI-0004rX-0B for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Jun 2017 21:27:20 +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_2) (envelope-from ) id 1dO9dG-0004qo-VH for pgsql-hackers@postgresql.org; Thu, 22 Jun 2017 21:27:19 +0000 Received: from mail-wr0-x22f.google.com ([2a00:1450:400c:c0c::22f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dO9dE-0004yv-6g for pgsql-hackers@postgresql.org; Thu, 22 Jun 2017 21:27:17 +0000 Received: by mail-wr0-x22f.google.com with SMTP id r103so40488434wrb.0 for ; Thu, 22 Jun 2017 14:27:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=6R7QfoXFIofBOALrIhxfvNracIUjFQY0xBYoSj6kj3M=; b=iTVbcnmTU/obQ7Fv9WmF7tY3LVvTR0DtkUr7jpxWPZ5yYKaGlBDeO9M7gnArZxwr26 mIcctRIh/FwVWU7Ot+eJhh5B2Pije7/noFLKhw4E5pNv26N7gSAYrHoSBMiTA0TqZaM2 /U9O+Sw+VDW/xnRtcCywN/0yjKJNeLA8PWhT1aM3FMeb5hgAIU7277zXx4PRqY/gaeTr FdraFJ3AOvXfKiF8rGI23DoJFNQPThPmNNj/dguWIxGQ+4Kl83UzE1IcspAHzZKtKQ1M xpviDJ6b4DQgl38KuUNEimpw8FsvOw+74dppG64nM1Nce0zeDHQc3hbh4eXVWgE4jXcD 0YOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=6R7QfoXFIofBOALrIhxfvNracIUjFQY0xBYoSj6kj3M=; b=E7sBfN556T9y80rMBoIJhTPo/JGWxSPQN6icLQa2j2TDoHb74jIoMmxmd55mkBhA1L BwZW9+emefB6Ypyz7+DzBglfeviz0zf48bRyR8PcyM7spz3NQskdAECeX/65ctU6onqi BMzDG3eCMjVgry/5CmAnH+r36zSp/M9OE/H8bOVvafis9XibP6n9Uqsnd6tUpYLqXuIi ztQ8SmeCJDsoRVP/VQQdb8qkwcnLkzBSNLmvyNaSnEN/hkaSURXExI2wdunD2GZZdeu9 B1XM99ozScxAuxsV/5VvsbBkgb2craDQemYBq+EvQlEbaXlr7lJZVhzTrEFjxfOHSCbP SCxw== X-Gm-Message-State: AKS2vOxcbDzZ8YdqHJ/4xlIDyBByqyODOSwCjlIz5lJC/Z2c8j+8ldQf nR9A4/ym3kVYl+QElhBmEaP1WgU0HehuQI39I+/QMeY0U7EOczkiCd0UbP2yMB1KxpSmAheUXhl xitxqFZ6m/pYvnLd9+hsBbHrsDNubJ/rJPYcmN4ErkzBtSHICqtXa3v7S82PGVQXAFpzLg+r3em I= X-Received: by 10.28.17.69 with SMTP id 66mr3242192wmr.6.1498166833670; Thu, 22 Jun 2017 14:27:13 -0700 (PDT) Received: from [10.137.2.17] (ip-89-177-46-65.net.upcbroadband.cz. [89.177.46.65]) by smtp.gmail.com with ESMTPSA id k17sm2462645wmg.9.2017.06.22.14.27.12 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 22 Jun 2017 14:27:12 -0700 (PDT) Subject: Re: Pluggable storage To: Robert Haas , Haribabu Kommi Cc: Alvaro Herrera , Pg Hackers References: <20160824182201.GA232997@alvherre.pgsql> <20161013202642.ksiuyx72gu6wgupf@alvherre.pgsql> From: Tomas Vondra Message-ID: <5863132d-a436-321b-6ef9-7c5173bd8ef3@2ndquadrant.com> Date: Thu, 22 Jun 2017 23:27:11 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:54.0) Gecko/20100101 Thunderbird/54.0a2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit 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 Hi, On 6/21/17 9:47 PM, Robert Haas wrote: ... > > like int8 or numeric, it won't work at all. Even for other things, > it's going to cause problems because the bit patterns won't be what > the code is expecting; e.g. bitmap scans care about the structure of > the TID, not just how many bits it is. (Due credit: Somebody, maybe > Alvaro, pointed out this problem before, at PGCon.) Can you elaborate a bit more about this TID bit pattern issues? I do remember that not all TIDs are valid due to safeguards on individual fields, like for example Assert(iptr->ip_posid < (1 << MaxHeapTuplesPerPageBits)) But perhaps there are some other issues? regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers