anks & Regards,
> Nikhil,
> PostgreSQL DBA.
>
"pg_dump -s" will export the model, including functions, triggers... as
well as tables and views without data.
I should have somewhere an old program I wrote on a lazy day to slice this
backup into individual objects. I can di
s longer than
> the total execution time does not completely avoid this effect.
> For example, a wait-period of 5-second in between queries that take
> 2-second to run, does not help avoid the increasing runtime problem
> completely.
>
> Thanks,
> Shijia
>
>
> On Mon,
Hi Shijia,
It sounds like concurrency on the queries: the second starts before the
first ends, and so on. With a short wait in between you ensure sequential
execution. Notice that you also have the overhead of concurrent psql...
Sounds normal to me.
Best regards
Olivier
On Mon, Dec 16, 2019, 0
