Message-ID: <52C70094.3040006@student.kit.edu>
Date: Fri, 3 Jan 2014 19:25:24 +0100
From: Thomas Mayer <thomas.mayer@student.kit.edu>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.2.0
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: window function induces full table scan
References: <52C5DAD1.20109@student.kit.edu> <17191.1388699570@sss.pgh.pa.us>
 <CAMkU=1zcZH+7_kzAS_jWR-soz7YWUeu6nYeTtAMhiDt6BQKTpw@mail.gmail.com>
 <18380.1388702592@sss.pgh.pa.us> <20167.1388706955@sss.pgh.pa.us>
 <52C63E8B.2040806@student.kit.edu> <9269.1388760865@sss.pgh.pa.us>
 <52C6F712.6040804@student.kit.edu> <4827.1388772253@sss.pgh.pa.us>
In-Reply-To: <4827.1388772253@sss.pgh.pa.us>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Am 03.01.2014 19:04, schrieb Tom Lane:

> I think you need to read the code around subquery_is_pushdown_safe and
> qual_is_pushdown_safe some more.
>
> 			regards, tom lane
> .
>

In general, I'd need to go throught the pg source code which will take 
some time. For instance, I wanted to see which are the requirements for 
a patch to be accepted.

Currently, I can't provide you with a patch anyways (lack of time and 
knowledge). However, I can possibly give it a try in a few weeks.

If someone is working on that in the meantime, please let me know.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance