Optimizing query

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Optimizing query
Date: 2026-09-09 18:17:44
Message-ID: CA+FnnTyMuCK7tijgK2hCzGjL5Lnfs7=EDV7QLUaRduACEd1F3w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, ALL,
Can below 4 queries

std::wstring query1 = L"SELECT rolname FROM pg_roles";
std::wstring query2 = L"SELECT datname FROM pg_database WHERE
datistemplate = true;";
std::wstring query3 = L"SELECT pg_encoding_to_char( conforencoding
) AS name FROM pg_conversion";
std::wstring query4 = L"SELECT collname, collencoding,
collprovider collctype FROM pg_collation";
std::wstring query5 = L"SELECT spcname FROM pg_tablespace";

be made as one big query to use a 1 DB hit?

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mantas Gridinas 2026-09-09 20:34:50 What is the cost of a tx?
Previous Message dinesh kumar 2026-09-09 16:52:21 Re: FATAL Idle transaction timeout - TRX Commit