On Wed, Jul 15, 2020 at 02:49:16PM -0400, Henrique Montenegro wrote:
> Any idea why the actual time is in the 3ms range? If I query that partition
> directly, like this:
>
> As you can see, the `actual_time` when querying the partition table
> directly goes to 0.002 which is almost 2000x faster.
On Wed, Jul 15, 2020 at 8:24 AM Henrique Montenegro
wrote:
>
>
> On Wed, Jul 15, 2020 at 4:03 AM Sebastian Dressler
> wrote:
>
>> Hi Henrique,
>>
>> On 15. Jul 2020, at 03:13, Henrique Montenegro wrote:
>> [...]
>>
>> ```
>> ssl = off
>> shared_buffers = 160GB # min 128kB
>> wo
On Wed, Jul 15, 2020 at 4:03 AM Sebastian Dressler
wrote:
> Hi Henrique,
>
> On 15. Jul 2020, at 03:13, Henrique Montenegro wrote:
> [...]
>
> ```
> ssl = off
> shared_buffers = 160GB # min 128kB
> work_mem = 96GB # min 64kB
> maintenance_work_mem = 12GB
Hi Henrique,
On 15. Jul 2020, at 03:13, Henrique Montenegro
mailto:typ...@gmail.com>> wrote:
[...]
```
ssl = off
shared_buffers = 160GB # min 128kB
work_mem = 96GB # min 64kB
maintenance_work_mem = 12GB # min 1MB
max_stack_depth = 4MB
