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 1mmTVK-0005CU-R0 for pgsql-performance@arkaria.postgresql.org; Mon, 15 Nov 2021 04:22:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mmTVJ-0002Qa-QJ for pgsql-performance@arkaria.postgresql.org; Mon, 15 Nov 2021 04:22:01 +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 1mmTVJ-0002QL-Ep for pgsql-performance@lists.postgresql.org; Mon, 15 Nov 2021 04:22:01 +0000 Received: from mail-qk1-x72e.google.com ([2607:f8b0:4864:20::72e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mmTVG-0000BF-Jk for pgsql-performance@lists.postgresql.org; Mon, 15 Nov 2021 04:22:01 +0000 Received: by mail-qk1-x72e.google.com with SMTP id a11so8779029qkh.13 for ; Sun, 14 Nov 2021 20:21:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:to:content-language:from :subject:content-transfer-encoding; bh=fMZgmbUK/qbEkGD54ay49dpezDhpQB8RkTugvpggM/g=; b=ZU4LlEPRmAdhCLdBm8LFhOyE9KDI4LysiOfug6K1ZxJNw/fS1bT8n64HFWJqG5VxNC F/mo4Jt3s1/K1G6H0RJOzrnOrbMcZSM6IDGmegG7G9aWxoc3B1U0eQ4LsV4I+eH08D5P GRATKwiIpjX91T07F88InEgbYh7SH83Ws7dumGX/V1XSet5L7+M+NgQA7ZXjEUcnkSty h9N5vco4pYbdGg+znPIHuecwOK6Ng+4RhpamCI+BPx8soiJTXn4L38vu5gfv1gsoAqBv S0ySJYtn43VelQxNl0EPgwg61rb0wtZ1OkLue8B49fR0PsD744RhnJEr23C1Q766dteI WOWg== 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:to :content-language:from:subject:content-transfer-encoding; bh=fMZgmbUK/qbEkGD54ay49dpezDhpQB8RkTugvpggM/g=; b=LjGP4x7h7ELZPSPXMT+WZV5Va2JRPopuEy9av5zOGhQGp4uTYiNbsNbs4Lr8aaSh18 5ZbO6yV0/S4lzxuR9fRrk2agGP0L8iEOI8mcArS+kwvtYZsu8qkDeq7uOWpt0Bo/kMrm cusTBOPfsFstTsX46P3uR5ENprbfSNUMDI4MC/8zUXc+NBN6CAdTZ7fChT/SM8U/KbBv BW5ZqjoTWN18Kg3Rc2aKlLIfLFjRz3QSH4F5845CF/2RSQtlpKsNbx5//G5NG6pujHLo XR5sox00xZ8YehZ876C6Dv01GQgKUb4GhKUckrcIsoHMOf3sdhaH+a9k+IJp0d4dVMKd yitw== X-Gm-Message-State: AOAM533uqm6KMwFQfcpwdLuaxSaxFwHJdd/zgp2MUakhuQ3YmnSBCZ5G v/eHrBM+IKNC1ns4QU0JKx3T8RKxamg= X-Google-Smtp-Source: ABdhPJxWsLYF+pSYdGuq2Q1B0JphYbN+rmTGyFHnSsUj1ebMBH7TE5YG5cAvIXngwrHhIr+WrpzfUw== X-Received: by 2002:a05:620a:2996:: with SMTP id r22mr23834095qkp.485.1636950116071; Sun, 14 Nov 2021 20:21:56 -0800 (PST) Received: from [192.168.2.100] (pool-72-79-19-93.nwrknj.east.verizon.net. [72.79.19.93]) by smtp.gmail.com with ESMTPSA id y8sm6568392qko.36.2021.11.14.20.21.55 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 14 Nov 2021 20:21:55 -0800 (PST) Message-ID: <86fccf60-1281-b81b-4c42-5a1ef8b032ab@gmail.com> Date: Sun, 14 Nov 2021 23:21:54 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.3.0 To: pgsql-performance@lists.postgresql.org Content-Language: en-US From: Mladen Gogala Subject: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I was trying to upgrade my test 13.4 instance on Oracle Linux 8.4 (x86_64) to 13.5. I can't upgrade postgresql13-llvm jit because Oracle's and Red Hat repositories still don't have the required version of llvm (12.1.0.2): root@postgres mgogala]# rpm -qa|grep llvm llvm-libs-11.0.1-2.0.1.module+el8.4.0+20397+f876858a.x86_64 llvm7.0-libs-7.0.1-7.el8.x86_64 llvm-test-11.0.1-2.0.1.module+el8.4.0+20397+f876858a.x86_64 llvm-11.0.1-2.0.1.module+el8.4.0+20397+f876858a.x86_64 llvm-static-11.0.1-2.0.1.module+el8.4.0+20397+f876858a.x86_64 llvm-devel-11.0.1-2.0.1.module+el8.4.0+20397+f876858a.x86_64 [root@postgres mgogala]# I am getting the following error: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 requires libLLVM-12.so()(64bit), but none of the providers can be installed. There is a CentOS8-stream version which solves the problem but I cannot use that in the office. I will probably have to wait for another month before OL8 has everything that I need in its repositories. Now, the question is what kind of an impact will running without llvm-jit have? According to the links below, llvm-jit effects are quite spectacular: https://llvm.org/devmtg/2016-09/slides/Melnik-PostgreSQLLLVM.pdf https://www.pgcon.org/2017/schedule/events/1092.en.html Now, the question is whether anyone on this list can quantify the difference? What would be a better option? To wait for the repos to receive the necessary packages or to run without llvm-jit? In the office I have some rather large databases and CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY  fixes in 13.5 are highly desired but not at the cost of the overall application performance. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com