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 1nMbWK-00079F-5t for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Feb 2022 20:12:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nMbWI-0006aP-Tx for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Feb 2022 20:12:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMbWI-0006aG-81 for pgsql-hackers@lists.postgresql.org; Tue, 22 Feb 2022 20:12:22 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nMbWF-0001TL-8E for pgsql-hackers@lists.postgresql.org; Tue, 22 Feb 2022 20:12:20 +0000 Received: by mail-ed1-x536.google.com with SMTP id u18so39692284edt.6 for ; Tue, 22 Feb 2022 12:12:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=message-id:date:mime-version:user-agent:subject:content-language:to :cc:references:from:in-reply-to:content-transfer-encoding; bh=Lg+jfj3ZP9/yQHHKDXzQ7/lxE/nXp0qgX3Srx/qcbz4=; b=V0azKpLkKiMYLL7BEfLaxpZAFYhrTCqJsizWDWGGvDqP0qX9MGEWaqi/Pgd/2VvF0x r8ZAHhyHQOn0rtBfr5H/z38bXSeZo8zpuZ2e9efGPliGrp4XRInAk0EVXBz2xbHisEve dnKZV0OzE+Le9tz8P5UcBJZu8qWgH+A0cY0Hpe3HRiLnpSiPDWurkkOkWM7XyJHDEhfd AC4XgtV9lpinN+8HwtQLRN4b96O+qRI+Gnffjnl9mAjv4GDDPWPitADKKoz04Bvj5xnt V0Gcsi7+RuZ1oWYr9ChblAtA9okRoFlGAqyzOUqf9xtQxIUHDyNtQtrr3a9YdW50MTHH cW7w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:cc:references:from:in-reply-to :content-transfer-encoding; bh=Lg+jfj3ZP9/yQHHKDXzQ7/lxE/nXp0qgX3Srx/qcbz4=; b=kZ8jKLukAFqwfZhc/byaxsaQIb09mpEMlmwUy52AYnexf3HTfYNS25uL0hRO/EG1jq g+yawmMduYooOOqjOFyMcD9YknHLWhCykfVl2epVgM+ocpn6QOB1BBm5t3WRZOo5biIY 1D4RsT5MpXh/bwD3lkpN0I5ryAkB7VTbwMB2w1v33hZyRqCrAerVflnKZg2MR8bXIi1v h138lohlH6bmwMutIBRzYgY5F9mdV5z7jCz8l9MGKzScJY6Kw3i12/J3oDmkzYz4TS5Q 95lOE9+15z/59/FgFip+33DwZfMSRXxYkIgNNx54BZF7Gw35vidM/ihkAqGTMcczIonj Sa1A== X-Gm-Message-State: AOAM530WUbq8PwYfZB/BZ6tN2C7+jA8q1nXtkT42KURGf2zhoqUmQSUZ z+wCUa6hhobFvJZSzUZyHw9W3BZLcHYLvpigg8dRncqQIQhjDc1HkfbBvZc+Pg6A+Zm/ywO9Be/ qrAstms825DTfcCSz+TlapT3iXRriND1oi0BlPfuA16HdnJfNf/S2PPx69W6dabq8iQORZDo3y3 GPm+alk7PbAIwLlNSUHiQv0mZjcdGhVRupeziMPSPzgPsP7Z+yimbVRicL8QHblQ0= X-Google-Smtp-Source: ABdhPJxNmFZa8ueyxX7lQR6Y8xTv9ngalfAxjDvbHxpkRQalqveThwJ7i/QNoqSkdPJ8UJaTfcgL/A== X-Received: by 2002:a05:6402:90d:b0:412:d3fe:8460 with SMTP id g13-20020a056402090d00b00412d3fe8460mr19645219edz.316.1645560737129; Tue, 22 Feb 2022 12:12:17 -0800 (PST) Received: from [10.137.0.19] (ip-86-49-251-241.net.upcbroadband.cz. [86.49.251.241]) by smtp.gmail.com with ESMTPSA id z9sm1292319edc.2.2022.02.22.12.12.16 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 22 Feb 2022 12:12:16 -0800 (PST) Message-ID: <76202fae-0c34-4f49-e3a0-1071c3fcf9e1@enterprisedb.com> Date: Tue, 22 Feb 2022 21:12:15 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 Subject: Re: postgres_fdw: using TABLESAMPLE to collect remote sample Content-Language: en-US To: Fujii Masao , Robert Haas , Tom Lane Cc: PostgreSQL Hackers References: <151e835f-55d6-ddbc-b5b4-07ee606aba44@enterprisedb.com> <2080021.1644601183@sss.pgh.pa.us> <2082308.1644602761@sss.pgh.pa.us> <60c4dc7c-82e8-ab04-a938-d7b7c5ee75f0@enterprisedb.com> <84afe85f-2aa0-5aef-fa4a-59759afc03fb@enterprisedb.com> From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/22/22 01:36, Fujii Masao wrote: > > > On 2022/02/18 22:28, Tomas Vondra wrote: >> Hi, >> >> here's a slightly updated version of the patch series. > > Thanks for updating the patches! > > >> The 0001 part >> adds tracking of server_version_num, so that it's possible to enable >> other features depending on it. > > Like configure_remote_session() does, can't we use PQserverVersion() > instead of implementing new function GetServerVersion()? > Ah! My knowledge of libpq is limited, so I wasn't sure this function exists. It'll simplify the patch. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company