Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kV1U6-0000NO-DK for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Oct 2020 23:56:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kV1U5-0005RQ-0L for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Oct 2020 23:56:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kV1U4-0005Qm-Eu for pgsql-hackers@lists.postgresql.org; Tue, 20 Oct 2020 23:56:04 +0000 Received: from mail-il1-x143.google.com ([2607:f8b0:4864:20::143]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kV1Tw-0006pz-Nw for pgsql-hackers@postgresql.org; Tue, 20 Oct 2020 23:56:03 +0000 Received: by mail-il1-x143.google.com with SMTP id p9so647028ilr.1 for ; Tue, 20 Oct 2020 16:55:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jncsoftware-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=VTijF1WIQ/ZHdc9+3pY+/hgaUtaLZD4vRg6wS0orf10=; b=ykmTDNW7/uSyhg+FnZh5fEBVV+RoUyhBtNAm1Uy7KtSlCQPF8AQZCAf9zeuI5pDMWZ 3lKNTAFttSqEJ5poffz5GzOQiq/bbgSl/yMK9s9F2EnMRK2N4PF+wYX/G54/WYU0xDpK Qlyd8vogXjM3YmG5UsuPIVYRKkWla3ZXlH1EXrMVzoeLPh4et4KX0N7xz16/CPSeD0of 3VycsEmq0S+f9EGplnxe9kt3NXsxLox6PWJxCwWmJhWPjV/gxFap1KOGV27MCbOIg6az WN4ydfPj4IZ4IwNei30uQwiv91PIr4X3EjGYDN/EsAE17WP9Ltik5lFHcC563Q7kXiAS XMtg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=VTijF1WIQ/ZHdc9+3pY+/hgaUtaLZD4vRg6wS0orf10=; b=H6DJ1GoCy3pVFNms3Z7ncfNrVeC5FWAxJLVoakgo/jkc8sRQDTODzg/7xLYT2Rop8r DUDrwNZeNM2sFOJK6Jfmy6aZE/SyskRUSBRhLd3hhqSW8X1EqO8p+MF0B1Nuui4kRIJ1 gdOunYR6KEBeh4yz9U6xOzf5lX14A8q4e8Tw/wuSZgKUgQZ6+vLlvQtRuja73v2RG3M0 AUp34nHhKGyW/v1/0L05JEIW1+sbeCGZYoxtpiC8EPEp4nyGkZG2SzV9J7/RKwJNEEo2 5b+O4/CUkbXOFfEuGeBOLD398asASacDGvWOnzfm/z8q13dXdPtsHWREpLhSUCtm1oyp J6xQ== X-Gm-Message-State: AOAM531RtAJPipLF/ZMMEodInev4f/ZjJuCp6858NYzqumbn6xFvWmb2 bs1iBJuqtRUVLQ2r1ywfyUQlxKWuYn/0zJjs X-Google-Smtp-Source: ABdhPJz45xF72zsx7bUkKlBgRqhw/Wrxj4bJ+UOMLWZbWRwV3E39/4+qWlMlyjhkAPiblQzlFlS1lQ== X-Received: by 2002:a92:2003:: with SMTP id j3mr351336ile.28.1603238154405; Tue, 20 Oct 2020 16:55:54 -0700 (PDT) Received: from mail-io1-f53.google.com (mail-io1-f53.google.com. [209.85.166.53]) by smtp.gmail.com with ESMTPSA id p17sm183612ilh.34.2020.10.20.16.55.52 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 20 Oct 2020 16:55:53 -0700 (PDT) Received: by mail-io1-f53.google.com with SMTP id r9so757580ioo.7 for ; Tue, 20 Oct 2020 16:55:52 -0700 (PDT) X-Received: by 2002:a02:7:: with SMTP id 7mr637127jaa.112.1603238152556; Tue, 20 Oct 2020 16:55:52 -0700 (PDT) MIME-Version: 1.0 References: <6e747f98-835f-2e05-cde5-86ee444a7140@2ndquadrant.com> <20201009184625.4hfgpcxzd6jfredb@alap3.anarazel.de> <20201009185902.2hrednanwa7dxout@alap3.anarazel.de> <26d034cc-d4af-e2f8-72b8-f23fea9320ed@2ndquadrant.com> In-Reply-To: From: Jack Christensen Date: Tue, 20 Oct 2020 18:55:41 -0500 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: dynamic result sets support in extended query protocol To: Shay Rojansky Cc: Dave Cramer , Peter Eisentraut , Andres Freund , pgsql-hackers , Vladimir Sitnikov , Mark Paluch Content-Type: multipart/alternative; boundary="00000000000092d60605b222f8a2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000092d60605b222f8a2 Content-Type: text/plain; charset="UTF-8" Regarding decoding binary vs text performance: There can be a significant performance cost to fetching the binary format over the text format for types such as text. See https://www.postgresql.org/message-id/CAMovtNoHFod2jMAKQjjxv209PCTJx5Kc66anwWvX0mEiaXwgmA%40mail.gmail.com for the previous discussion.