All;
I am running a select from a partitioned table. The table (and all the
partitions) have an index on contract_date like this:
CREATE INDEX on part_tab (contract_date) where contract_date >
'2022-01-01'::date
The table (including all partitions) has 32million rows
The db server is an auror
On 4/19/22 22:17, Jeff Janes wrote:
On Tue, Apr 19, 2022 at 5:00 PM Sbob wrote:
However if we move the file to another server in the same network and
run with a psql -h then it runs for more than 10min.
What is the ping time? Packet loss? You can't take for granted that
Hi all;
We are debugging a sql performance issue. We have a sql file with 50,000
simple select statements in it. If I run the file locally it completes
in less than 15sec. If I force the local connection to be a tcp/ip
connection via psql -h and I get approximately the same results, 15 - 16s
All;
I am looking for information on how PostgreSQL leverages or interfaces
with CPU's on Linux. Does PostgreSQL let Linux do the work? Does it
bypass the OS? Any information or docs you can send my way would be much
appreciated.
Thanks in advance
EnterpriseDB is basically postgres with the added oracle compatability
and some added external tools. THe default user & db will no longer be
postgres but 'enterprisedb', but it is still postgresql so you won't
have any issues working with EDB if you already know postgres
On 9/13/21 20:52, M
