Re: tweaking NTUP_PER_BUCKET

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: tweaking NTUP_PER_BUCKET
Date: 2014-07-12 09:39:04
Message-ID: CA+U5nM+VyPNE629qUAvwwHTP7B_ex+Y-_LpG5Z5TemzPKWfrVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11 July 2014 18:25, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:

> Turns out getting this working properly will quite complicated.

Lets keep this patch simple then. Later research can be another patch.

In terms of memory pressure, having larger joins go x4 faster has a
much more significant reducing effect on memory pressure than anything
else. So my earlier concerns seem less of a concern.

So lets just this change done and then do more later.

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomonari Katsumata 2014-07-12 11:18:20 Re: proposal: rounding up time value less than its unit.
Previous Message Fabrízio de Royes Mello 2014-07-12 05:42:12 Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED