Re: speed up full table scan using psql

Поиск
Список
Период
Сортировка
От Lian Jiang
Тема Re: speed up full table scan using psql
Дата
Msg-id CA+aY8X4Wn2KBDYsqspPOoWUybsB1Jh6yfBVChMSHxVkuRVm3VQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: speed up full table scan using psql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: speed up full table scan using psql
Re: speed up full table scan using psql
Re: speed up full table scan using psql
Список pgsql-general
Дерево обсуждения
The command is: psql $db_url -c "copy (select row_to_json(x_tmp_uniq) from public.mytable x_tmp_uniq) to stdout"
postgres version:  14.7
Does this mean COPY and java CopyManager may not help since my psql command already uses copy?

Regarding pg_dump, it does not support json format which means extra work is needed to convert the supported format to jsonl (or parquet) so that they can be imported into snowflake. Still exploring but want to call it out early. Maybe 'custom' format can be parquet?


Thanks
Lian

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

Предыдущее
От: "Henrik Peinar (nodeSWAT.com)"
Дата:
Сообщение: Re: Help needed to understand query planner regression with incremental sort
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: speed up full table scan using psql