Re: hash aggregation

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: Korisk <Korisk(at)yandex(dot)ru>
Cc: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: hash aggregation
Date: 2012-10-12 04:32:53
Message-ID: CAM6mieJT5tyMz0kgESUEgNSvNBhdcoBCPSX5X_WFW6Rs2HugQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 12 October 2012 15:14, Korisk <Korisk(at)yandex(dot)ru> wrote:
> Strange situation.
> After indexscan enabling the cost is seriously decreased.

You can not really disable any scan method. enable_xxx = off just sets
very high cost (=10000000000) for that operation.

--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)
(http://www.linkedin.com/in/ondrejivanic)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sergey Konoplev 2012-10-12 07:10:06 Re: hash aggregation
Previous Message Korisk 2012-10-12 04:14:38 Re: hash aggregation