pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Mayer <thomas.mayer@student.kit.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: window function induces full table scan
Date: Fri, 3 Jan 2014 19:25:24 +0100
Message-ID: <52C70094.3040006@student.kit.edu> (raw)
In-Reply-To: <4827.1388772253@sss.pgh.pa.us>
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>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

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



view thread (13+ messages)

Message-ID: <52C70094.3040006@student.kit.edu>
Permalink:  ../52C70094.3040006@student.kit.edu/
Also on:    postgresql.org/message-id/52C70094.3040006@student.kit.edu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: thomas.mayer@student.kit.edu, tgl@sss.pgh.pa.us
  Subject: Re: window function induces full table scan
  In-Reply-To: <52C70094.3040006@student.kit.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox