Hello Tem,
Can you please help on the below issues . The below Error occurred when I run
the select statement for the huge data volume.
Error Details :
Ran out of memory retrieving query results.
Regards
Nanda Kumar.M
SmartStream Technologies
Eastland Citadel | 5th Floor | 102 Hosur Road | B
I played with TPC-DS and found some of them can't be executed because
of SQL errors and I am not sure why.
For example with query 36:
select
sum(ss_net_profit)/sum(ss_ext_sales_price) as gross_margin
,i_category
,i_class
,grouping(i_category)+grouping(i_class) as lochierarchy
,r
On 3/10/19 9:07 PM, Julie Nishimura wrote:
Oh, this is great news! Yay, thanks!
Just be aware, where -n = --schema:
https://www.postgresql.org/docs/10/app-pgdump.html
"
Note
When -n is specified, pg_dump makes no attempt to dump any other
database objects that the selected schema(s) might d
Oh, this is great news! Yay, thanks!
From: Adrian Klaver
Sent: Sunday, March 10, 2019 6:28 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: migration of 100+ tables
On 3/10/19 5:53 PM, Julie Nishimura wrote:
> Hello friends, I will need to
On 3/10/19 5:53 PM, Julie Nishimura wrote:
Hello friends, I will need to migrate 500+ tables from one server (8.3)
to another (9.3). I cannot dump and load the entire database due to
storage limitations (because the source is > 20 TB, and the target is
about 1.5 TB).
I was thinking about usi
Hello friends, I will need to migrate 500+ tables from one server (8.3) to
another (9.3). I cannot dump and load the entire database due to storage
limitations (because the source is > 20 TB, and the target is about 1.5 TB).
I was thinking about using pg_dump with customized -t flag, then use r
I must have missed this, I did not immediately realize there was a
difference between select and delete
Thanks for the explanation and outlook.
Stefan
