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.
>>>
>>>
>>>
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 |