Re: Is there any limit on the number of rows to import using copy command

On Wed, Jul 23, 2025 at 2:51 AM sivapostg...@yahoo.com wrote: > > Tried in PostgreSQL 11.11 , PostgreSQL 15.2 in Windows 10 > > Here we try to transfer data from one database to another (remote) database. > > Tables do have records ranging from 85000 to 360 along with smaller sized > tables.

Re: Is there any limit on the number of rows to import using copy command

On 7/23/25 01:50, sivapostg...@yahoo.com wrote: Tried in PostgreSQL 11.11 , PostgreSQL 15.2 in Windows 10 The above command succeeds, when 1.  The trigger in Table1 is disabled with all other constraints on. 2.  The no. of rows is within 16000 or less, with Trigger enabled.  We haven't tried

Re: Is there any limit on the number of rows to import using copy command

On Wed, 2025-07-23 at 11:55 +, sivapostg...@yahoo.com wrote: > 1.  I tried running Copy From command from PGAdmin.   > 2.  I ran pg_stat_activity also in another tab [ PGAdmin ]. > > What I observed, > 1.  In about 2 min, in the Dashboard of PGAdmin, the colour changed to Orange > for that pa

Re: Is there any limit on the number of rows to import using copy command

Tried in PostgreSQL 11.11 , PostgreSQL 15.2 in Windows 10 Here we try to transfer data from one database to another (remote) database.  Tables do have records ranging from 85000 to 360 along with smaller sized tables. No issues while transferring smaller sized tables. I here take one particula

Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture

On Wed, 23 Jul 2025 12:13:26 +0100 Achilleas Mantzios wrote: … > Have you consider pgpool-ii ?  I know most support / service companies > push for patroni, and manually separating read / write traffic from > within the app, Indeed > but I still find pgpool's query routing very nice. Using Pgp

Re: Wrapping a select in another select makes it slower

On 2025-07-23 10:08:31 +1200, David Rowley wrote: > On Wed, 23 Jul 2025 at 03:18, Peter J. Holzer wrote: > > > > PostgreSQL version 17.5 on Ubuntu 24.04 (PGDG build). > > > > -> Merge Left Join (cost=4613.25..7180.30 rows=8357 > > width=136) (actual time=222.037..292242.701 rows

Re: Is there any limit on the number of rows to import using copy command

On Wed, 2025-07-23 at 08:50 +, sivapostg...@yahoo.com wrote: > Tried in PostgreSQL 11.11 , PostgreSQL 15.2 in Windows 10 Both of these choices are unsavory. Don't use the unsupported v11, and use 15.13 with v15. > Here we try to transfer data from one database to another (remote) database. 

Re: Request for Feedback on PostgreSQL HA + Load Balancing Architecture

On 6/18/25 18:12, vijay patil wrote: Hi Team, I am planning to implement a PostgreSQL High Availability (HA) and Load Balancing setup and would greatly appreciate your feedback on the architecture we've designed (see attached diagram). image.png *Overview of the Setup:* * Two Postgr

Re: Is there any limit on the number of rows to import using copy command

Thanks Laurenz Albe, 1.  I tried running Copy From command from PGAdmin.  2.  I ran pg_stat_activity also in another tab [ PGAdmin ]. What I observed,1.  In about 2 min, in the Dashboard of PGAdmin, the colour changed to Orange for that particular pid.2.  After few seconds, the colour again cha

Re: Possible causes of high_replay lag, given replication settings?

On Fri, 18 Jul 2025 at 21:29, Jon Zeppieri wrote: > > I just had a situation where physical replication fell far behind > (hours). The write and flush lag times were 0, but replay_lag was > high. The replica has hot_standby_feedback on, and both > max_standby_streaming_delay and max_standby_archiv

Re: PgBouncer Prepared Statement ERROR

On 7/18/25 13:52, KK CHN wrote: Hi , I am getting error when using  PgBouncer(1.23.1 ) with Postgres 16  (RedHAT 9.4) 2025-07-18 00:00:00 IST ERROR:  prepared statement "S_243" does not exist 2025-07-18 00:00:03 IST ERROR:  prepared statement "S_205" does not exist 2025-07-18 00:00:03 IST ER