Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions on query planner, join types, and work_mem - Mailing list pgsql-performance

From Robert Haas
Subject Re: Questions on query planner, join types, and work_mem
Date
Msg-id AANLkTik6UBt2ezVFzdCM8iaUPkra_7f-Hs_AmGZgvFhh@mail.gmail.com
Whole thread Raw
In response to Re: Questions on query planner, join types, and work_mem  (Hannu Krosing <hannu@2ndquadrant.com>)
Responses Re: Questions on query planner, join types, and work_mem  (Hannu Krosing <hannu@2ndquadrant.com>)
List pgsql-performance
Tree view 
On Tue, Aug 3, 2010 at 3:03 AM, Hannu Krosing <hannu@2ndquadrant.com> wrote:
> In case of fully cached database it is closer to 1.

In the case of a fully cached database I believe the correct answer
begins with a decimal point.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Questions on query planner, join types, and work_mem
Next
From: Robert Haas
Date:
Subject: Re: Strange explain on partitioned tables