Re: BTREE index: field ordering

2025-03-29 Thread Kevin Stephenson
Moreno, You have two lines in your WHERE clause commented out, the first line is a duplicate check on flag = TRUE, and the other line involves several checks on the "tipo" column. Will the final query or set of related queries actually need to filter on the "tipo" column? You currently have "ti

Re: Quesion about querying distributed databases

2025-03-29 Thread Kevin Stephenson
Bumping this old thread to clarify a few points. As an initial note on terminology, a "server" can be called a server, an instance, a server instance, or in PostgreSQL's (PG hereafter) case, a "DB Cluster." They all are used interchangeably in the wild to mean the same thing, with perhaps "serv

Re: Quesion about querying distributed databases

2025-03-29 Thread Adrian Klaver
On 3/29/25 02:15, Kevin Stephenson wrote: Bumping this old thread to clarify a few points. As an initial note on terminology, a "server" can be called a server, an instance, a server instance, or in PostgreSQL's (PG hereafter) case, a "DB Cluster." They all are used interchangeably in the wild