вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats@duneanalytics.com>:I'm looking for some help to manage queries against two large tables.Can you tell the version you're running currently and the output of this query, please? select name,setting,source from pg_settings where source not in ('default','override');
I'm looking for some help to manage queries against two large tables.
Running "PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg19.10+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.2.1-9ubuntu2) 9.2.1 20191008, 64-bit"
Updated the gist to include the results forom pg_settings. Here's the direct link https://gist.githubusercontent.com/mewwts/9f11ae5e6a5951593b8999559f5418cf/raw/e5deebbbb48680e04570bec4e9a816fa009da34f/pg_settings
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных