Re: Concurrently run scipts

Поиск
Список
Период
Сортировка
От hector vass
Тема Re: Concurrently run scipts
Дата
Msg-id CAJJx+iVextjyh4XFaTVA5qdMnrpHJ=8EN0q58N=cSOeHkUHHvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Concurrently run scipts  (Shaozhong SHI <shishaozhong@gmail.com>)
Ответы Re: Concurrently run scipts  (Shaozhong SHI <shishaozhong@gmail.com>)
Список 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@gmail.com> wrote:
How many scripts can be run concurrently but independently?

Regards,

David

On Wed, 25 Oct 2023 at 21:43, hector vass <hector.vass@gmail.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@momjian.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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: Re: Concurrently run scipts
Следующее
От: Shaozhong SHI
Дата:
Сообщение: Re: Concurrently run scipts