Re: Practical maximum max_locks_per_transaction?

On 11/25/22 17:56, Tom Lane wrote: Ron writes: How "raised" is too raised?  I just had to increase max_locks_per_transaction from 640 to 1024 on an instance with many child tables and against which is run many large reports.  Another instance has zero children, but had to increase the value to

Re: Practical maximum max_locks_per_transaction?

Ron writes: > How "raised" is too raised?  I just had to increase > max_locks_per_transaction from 640 to 1024 on an instance with many child > tables and against which is run many large reports.  Another instance has > zero children, but had to increase the value to 1280 to prevent reports fro

Practical maximum max_locks_per_transaction?

v9.6.24 (being retired next year) https://www.postgresql.org/docs/9.6/runtime-config-locks.html "The default, 64, has historically proven sufficient, but you might need to raise this value if you have queries that touch many different tables in a single transaction, e.g., query of a parent tab

How to create hot standby of Postgres 12/Debian 10.3 in Windows 11

Hi! Postgres 12 from Postgres repository is running in Debian 10.3 VPS server: PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit (its upgrade is currently not an option). Cluster should mirrored to Windows 11 workstation in real

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

On Tue, Nov 22, 2022 at 5:51 PM Thomas Munro wrote: > On Tue, Nov 22, 2022 at 4:25 AM Kirk Wolak wrote: > > In researching this problem, it appears that the decision was made > like 17yrs ago, when windows did not have a realistic "terminal" type > interface. > > FWIW PostgreSQL 16 will requir

Re: Index-only scan not working when IN clause has 2 or more values

=?UTF-8?B?QW5uYSBCLg==?= writes: > create index "ix-transaction-client-trans_dttm-division" > on transaction (client_id, > trans_dttm desc, > division_code); > > EXPLAIN (ANALYZE, BUFFERS) > select * > from transaction > where client_id = 123456 > an

Re: [BeginnerQuestion]Why the postgres_fe.h not found?

On 11/25/22 03:04, Wen Yi wrote: Hello everyone, I want to study the source of the postgres, but now I faced some problem: (The lsp server can't find the postgres_fe.h) ~src/include/postgres_fe.h image.png //

Re: Configure my pgadmin

On 11/25/22 05:34, William Torrez Corea wrote: How can I configure my pgadmin? Supply the password in the connection settings. Trying to connect to a server but fail *the attempt. * I get the following message: * * *Unable to connect to server: connection to server at "localhost" (

Re: How to select unique records in PostgreSQL

On Fri, Nov 25, 2022 at 7:50 AM Ron wrote: > Honestly, you do it *in PostgreSQL* the same way you do it in all the > other SQL RDBMSs. > Emphasizing "in PostgreSQL" is nonsensical - it isn't like the OP specified that they know how to do it in some other RDBMS and are trying to convert their kno

Re: table inheritance partition and indexes

Docs can always be better, right ;) When I went back and looked at the page I did realize that the ATTACH INDEX command was only mentioned in the description of declarative partitioning and not in the inheritance section so I should have paid closer attention to the location. Ted On Wed, Nov 23,

Re: How to select unique records in PostgreSQL

Honestly, you do it *in PostgreSQL* the same way you do it in all the other SQL RDBMSs. On 11/24/22 06:01, Rama Krishnan wrote: Hi All, I want to get the unique wallet_id from this table even it was repeated on multiple occasions I should calculate only once as well as if the wallet_id was

Configure my pgadmin

How can I configure my pgadmin? Trying to connect to a server but fail *the attempt. * I get the following message: > *Unable to connect to server: connection to server at "localhost" (::1), > port 5432 failed: fe_sendauth: no password supplied * > -- With kindest regards, William. ⢀⣴⠾⠻⢶⣦⠀ ⣾

[BeginnerQuestion]Why the postgres_fe.h not found?

Hello everyone, I want to study the source of the postgres, but now I faced some problem: (The lsp server can't find the postgres_fe.h) [cid:f46601f4-aa60-4ee4-8776-c1d744c9e4a9] [image.png]

Re: About row locking ordering

My first question is why are you not using "WHERE CURRENT OF" cursor_name? The link to the page follows. But effectively, you are locking the row and that is the row you want to update (the current row of the cursor). I wonder if that addresses the problem... https://www.postgresql.org/docs/curre