Date: Thu, 24 Jul 2025 23:14:09 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Pgsql-general <pgsql-general@postgresql.org>, 
	Laurenz Albe <laurenz.albe@cybertec.at>
Message-ID: <922431211.2481276.1753398849435@mail.yahoo.com>
In-Reply-To: <0af232bff681af8f34fd92ceb4d5c635e11815cb.camel@cybertec.at>
References: <1453510076.1900935.1753260637232.ref@mail.yahoo.com> <1453510076.1900935.1753260637232@mail.yahoo.com> <de08fd016dd9c630f65c52b80292550e0bcdea4c.camel@cybertec.at> <959901171.1916220.1753271729336@mail.yahoo.com> <0af232bff681af8f34fd92ceb4d5c635e11815cb.camel@cybertec.at>
Subject: Re:  Is there any limit on the number of rows to import using copy
 command
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_2481275_603327018.1753398849433"
Content-Length: 6360
Archived-At: <https://www.postgresql.org/message-id/922431211.2481276.1753398849435%40mail.yahoo.com>
Precedence: bulk

------=_Part_2481275_603327018.1753398849433
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Those two columns have null values when the color turns into Red.
And the status column shows 'active' only.=C2=A0 =C2=A0All those three colu=
mn values are same (null, null, active) even after 2 hours!
It works when I split the trigger function into three, one each for insert,=
 delete and update call from three different triggers.=C2=A0 I've replied t=
hat separately.
Happiness Always
BKR Sivaprakash

    On Wednesday 23 July, 2025 at 07:41:06 pm IST, Laurenz Albe <laurenz.al=
be@cybertec.at> wrote: =20
=20
 On Wed, 2025-07-23 at 11:55 +0000, sivapostgres@yahoo.com wrote:
> 1.=C2=A0 I tried running Copy From command from PGAdmin.=C2=A0=C2=A0
> 2.=C2=A0 I ran pg_stat_activity also in another tab [ PGAdmin ].
>=20
> What I observed,
> 1.=C2=A0 In about 2 min, in the Dashboard of PGAdmin, the colour changed =
to Orange for that particular pid.
> 2.=C2=A0 After few seconds, the colour again changed to Red.=C2=A0 =C2=A0
> 3.=C2=A0 The stat column in both Dashboard and pg_stat_activity.state sho=
ws 'active'.
> 4.=C2=A0 No messages relevant to this pid in postgres' log files
> 5.=C2=A0 CPU usage is normal, hovering around 36% overall, 15-18% for pos=
tgresql server, from the beginning and even after 3 min.
> 6.=C2=A0 We didn't run any other application in that machine.=C2=A0=C2=A0
> 7.=C2=A0 Unique Index is there in table2 which will return only one row f=
or that Select Count(*) query.
> 8.=C2=A0 No record is there in the target table when transfer started.=C2=
=A0 This transfer is the first batch for that particular table.
> 9.=C2=A0 Once color turned into Red, I could cancel the query execuion in=
 PGAdmin, which immediately stops the execution.
> 10. I could not see any locks or blocking pids.

As far as I know, red in pgAdmin (I don't use it) *is* the indication for a=
 wait event.
So look again what the columns "wait_event_type" and "wait_event" in "pg_st=
at_activity" show.

Yours,
Laurenz Albe


 =20
------=_Part_2481275_603327018.1753398849433
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpeae570f0yahoo-style-wrap" style=
=3D"font-family:times new roman, new york, times, serif;font-size:16px;"><d=
iv></div>
        <div><div><div dir=3D"ltr" style=3D"font-family: times new roman, n=
ew york, times, serif; font-size: 16px;">Those two columns have null values=
 when the color turns into Red.</div><div dir=3D"ltr" style=3D"font-family:=
 times new roman, new york, times, serif; font-size: 16px;"><br clear=3D"no=
ne"></div><div dir=3D"ltr" style=3D"font-family: times new roman, new york,=
 times, serif; font-size: 16px;">And the status column shows 'active' only.=
&nbsp; &nbsp;All those three column values are same (null, null, active) ev=
en after 2 hours!</div><div dir=3D"ltr" style=3D"font-family: times new rom=
an, new york, times, serif; font-size: 16px;"><br clear=3D"none"></div><div=
 dir=3D"ltr" style=3D"font-family: times new roman, new york, times, serif;=
 font-size: 16px;">It works when I split the trigger function into three, o=
ne each for insert, delete and update call from three different triggers.&n=
bsp; I've replied that separately.</div><div dir=3D"ltr" style=3D"font-fami=
ly: times new roman, new york, times, serif; font-size: 16px;"><br clear=3D=
"none"></div><div dir=3D"ltr" style=3D"font-family: times new roman, new yo=
rk, times, serif; font-size: 16px;">Happiness Always<br clear=3D"none">BKR =
Sivaprakash</div></div><br></div><div><br></div>
       =20
        </div><div id=3D"yahoo_quoted_3831410596" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Wednesday 23 July, 2025 at 07:41:06 pm IST, Laur=
enz Albe &lt;laurenz.albe@cybertec.at&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr">On Wed, 2025-07-23 at 11:55 +0000, <a=
 shape=3D"rect" ymailto=3D"mailto:sivapostgres@yahoo.com" href=3D"mailto:si=
vapostgres@yahoo.com">sivapostgres@yahoo.com</a> wrote:<br clear=3D"none">&=
gt; 1.&nbsp; I tried running Copy From command from PGAdmin.&nbsp;&nbsp;<br=
 clear=3D"none">&gt; 2.&nbsp; I ran pg_stat_activity also in another tab [ =
PGAdmin ].<br clear=3D"none">&gt; <br clear=3D"none">&gt; What I observed,<=
br clear=3D"none">&gt; 1.&nbsp; In about 2 min, in the Dashboard of PGAdmin=
, the colour changed to Orange for that particular pid.<br clear=3D"none">&=
gt; 2.&nbsp; After few seconds, the colour again changed to Red.&nbsp; &nbs=
p;<br clear=3D"none">&gt; 3.&nbsp; The stat column in both Dashboard and pg=
_stat_activity.state shows 'active'.<br clear=3D"none">&gt; 4.&nbsp; No mes=
sages relevant to this pid in postgres' log files<br clear=3D"none">&gt; 5.=
&nbsp; CPU usage is normal, hovering around 36% overall, 15-18% for postgre=
sql server, from the beginning and even after 3 min.<br clear=3D"none">&gt;=
 6.&nbsp; We didn't run any other application in that machine.&nbsp;&nbsp;<=
br clear=3D"none">&gt; 7.&nbsp; Unique Index is there in table2 which will =
return only one row for that Select Count(*) query.<br clear=3D"none">&gt; =
8.&nbsp; No record is there in the target table when transfer started.&nbsp=
; This transfer is the first batch for that particular table.<br clear=3D"n=
one">&gt; 9.&nbsp; Once color turned into Red, I could cancel the query exe=
cuion in PGAdmin, which immediately stops the execution.<br clear=3D"none">=
&gt; 10. I could not see any locks or blocking pids.<br clear=3D"none"><br =
clear=3D"none">As far as I know, red in pgAdmin (I don't use it) *is* the i=
ndication for a wait event.<br clear=3D"none">So look again what the column=
s "wait_event_type" and "wait_event" in "pg_stat_activity" show.<div class=
=3D"yqt2364883833" id=3D"yqtfd23184"><br clear=3D"none"><br clear=3D"none">=
Yours,<br clear=3D"none">Laurenz Albe<br clear=3D"none"><br clear=3D"none">=
<br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_2481275_603327018.1753398849433--