Kevin Grittner schrieb am 04.05.2016 um 09:06:
> On Wed, May 4, 2016 at 1:46 AM, Thomas Kellerer wrote:
>
>> I have a table that is an aggregation of another table.
>> This aggregation reduces an input of ~14 million rows to ~4
>> million rows.
>
>> The refresh takes approx 2 minutes (fastest wa
On Wed, May 4, 2016 at 1:46 AM, Thomas Kellerer wrote:
> I have a table that is an aggregation of another table.
> This aggregation reduces an input of ~14 million rows to ~4
> million rows.
> The refresh takes approx 2 minutes (fastest was 1:40) on our
> development server (CentOS, Postgres 9.5
Hello,
I have a table that is an aggregation of another table.
This aggregation reduces an input of ~14 million rows to ~4 million rows.
So far I have used a truncate/insert approach for this:
truncate table stock;
insert into stock (product_id, warehouse_id, reserved_provisional,
re