Hi,
I noticed something strange in our PG server. I have a table named
'timetable' that has only one bigint column and one row.
Once in every 5 seconds this row is updated to the current time epoch
value in milliseconds.
The update query seems to be taking considerable time (avg 50
milliseconds)
Hi,
Just realised that the time difference between explain analyze plan
and /timing result is due to the implicit commit.
Sorry about that.
Regards,
Nanda
On Sun, 22 Nov 2020 at 01:57, Nandakumar M wrote:
>
> Hi,
>
> I noticed something strange in our PG server. I have a table named
> 'timetab
On Sun, Nov 22, 2020 at 02:18:10AM +0530, Nandakumar M wrote:
> Just realised that the time difference between explain analyze plan
> and /timing result is due to the implicit commit.
Can you run with SET client_min_messages=debug; and SET log_lock_waits=on;
Oh, but your server is too old for that
