Re: Table copy

Поиск
Список
Период
Сортировка
От Andy Hartman
Тема Re: Table copy
Дата
Msg-id CAEZv3crcZ+gR6enbRq6W1b_QvFvd2r7XuYXDjfhPmUT9E2hqHw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table copy  (Andy Hartman <hartman60home@gmail.com>)
Список pgsql-general
This is going to be a monthly process not just a 1 time exercise.

On Wed, Feb 5, 2025 at 5:58 PM Andy Hartman <hartman60home@gmail.com> wrote:
Reduce batch size still caused error as reported nothing in WIndows Server log...

 The SimplySql is slick because just qry from src and load to dst ... Is there any way to somehow show more of the error in PS i tried the $error but nothing very descriptive 

On Wed, Feb 5, 2025 at 4:23 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 2/5/25 13:09, Andy Hartman wrote:
> I also reduced batch size to 5000 on the last run  .. I like using this
> SImplySql because it's a script I can launch, so that's why I chose that
> solution...  I'm using it to load a History Env.

You really need to complete your thoughts, remember we have no idea what
you are seeing unless you tell us.

Reducing the batch size did what?


>
> THanks again.
>

--
Adrian Klaver
adrian.klaver@aklaver.com

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