Re: Concurrently run scipts

From: hector vass <hector(dot)vass(at)gmail(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Concurrently run scipts
Date: 2023-10-26 09:21:26
Message-ID: CAJJx+iVextjyh4XFaTVA5qdMnrpHJ=8EN0q58N=cSOeHkUHHvQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

max_connections

..which is set in postgresql.conf
select * from pg_settings() where setting~'conn'

On Thu, 26 Oct 2023, 09:01 Shaozhong SHI, <shishaozhong(at)gmail(dot)com> wrote:

> How many scripts can be run concurrently but independently?
>
> Regards,
>
> David
>
> On Wed, 25 Oct 2023 at 21:43, hector vass <hector(dot)vass(at)gmail(dot)com> wrote:
>
>> Concurrently but independently
>> psql -f script1 & psql -f script2 && fg
>> Similar in windows can be achieved using start iirc
>>
>> On Wed, 25 Oct 2023, 21:15 Bruce Momjian, <bruce(at)momjian(dot)us> wrote:
>>
>>> On Wed, Oct 25, 2023 at 08:57:03PM +0100, Shaozhong SHI wrote:
>>> > In psql we run scripts sequentially like the following:
>>> >
>>> > \ir script1
>>> > \ir script2
>>> >
>>> >
>>> > Is there something similar for concurrent running script?
>>>
>>> Uh, yeah, see the use of \! and & starting on slide 59:
>>>
>>> https://momjian.us/main/writings/pgsql/locking.pdf
>>>
>>> --
>>> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
>>> EDB https://enterprisedb.com
>>>
>>> Only you can decide what is important to you.
>>>
>>>
>>>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2023-10-26 09:49:21 Re: Concurrently run scipts
Previous Message Shaozhong SHI 2023-10-26 08:01:14 Re: Concurrently run scipts