Re: dsa_allocate() faliure

2018-08-15 Thread Thomas Munro
On Thu, Aug 16, 2018 at 8:32 AM, Sand Stone wrote: > Just as a follow up. I tried the parallel execution again (in a stress > test environment). Now the crash seems gone. I will keep an eye on > this for the next few weeks. Thanks for the report. That's great news, but it'd be good to understand

Re: dsa_allocate() faliure

2018-08-15 Thread Sand Stone
Just as a follow up. I tried the parallel execution again (in a stress test environment). Now the crash seems gone. I will keep an eye on this for the next few weeks. My theory is that the Citus cluster created and shut down a lot of TCP connections between coordinator and workers. If running on u

Re: Fwd: increase insert into local table from remote oracle table preformance

2018-08-15 Thread legrand legrand
This is not so bad, you where at 10h for 200GB (20GB/h), And now at 24GB/h, it makes a 20% increase ;0) Could you tell us what are the résults with parallel exécutions (Before to switch to unload reload strategy) Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-perfor

RE: Calculating how much redo log space has been used

2018-08-15 Thread Reza Taheri
> -Original Message- > From: Andres Freund [mailto:and...@anarazel.de] > Sent: Tuesday, August 14, 2018 12:31 PM > To: Reza Taheri > Cc: pgsql-performa...@postgresql.org > Subject: Re: Calculating how much redo log space has been used > > Hi, > > On 2018-08-14 18:51:34 +, Reza Taheri

Re: increase insert into local table from remote oracle table preformance

2018-08-15 Thread Daniel Blanch Bataller
The Postgres command of choice to load bulk data is COPY https://www.postgresql.org/docs/current/static/sql-copy.html is much faster than anything else. It’s likely that the slowest part could be Oracle exporting it’s data. Try to

Re: Fwd: increase insert into local table from remote oracle table preformance

2018-08-15 Thread Mariel Cherkassky
Inserting directly into the partition didnt help, the performance are just the same. I tried to increase the prefetch value to 1000(alter foreign table hist_oracle options (add prefetch '1000') but still no change - 15 minutes for one partition(6GB). On the oracle side the plan is full scan on the