Re: [Postgres-xc-developers] Pushing down LIMIT clause

On Tue, Oct 30, 2012 at 8:05 AM, Koichi Suzuki <koi...@gm...>wrote:

> Thanks Ashutosh for the patch.   This is very useful in many cases.
>

Totally agree...this will help optimize many cases...


> ----------
> Koichi Suzuki
>
>
> 2012/10/29 Ashutosh Bapat <ash...@en...>:
> > Hi All,
> > PFA the patch for pushing down LIMIT clause to the datanodes.
> >
> > Pushing down LIMIT clause whenever possible can help reducing the
> bandwidth
> > in case the LIMIT + OFFSET is too less as compared to the qualifying rows
> > fetched from the datanodes.
> >
> > The patch has comments about working of the code.
> >
> > Regression does not show any failures. Expected outputs have been fixed
> for
> > two testcases, where plan changed, because of this optimization.
> >
> > --
> > Best Wishes,
> > Ashutosh Bapat
> > EntepriseDB Corporation
> > The Enterprise Postgres Company
> >
> >
> >
> ------------------------------------------------------------------------------
> > The Windows 8 Center - In partnership with Sourceforge
> > Your idea - your app - 30 days.
> > Get started!
> > http://windows8center.sourceforge.net/
> >
> what-html-developers-need-to-know-about-coding-windows-8-metro-style-apps/
> > _______________________________________________
> > Postgres-xc-developers mailing list
> > Pos...@li...
> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
> >
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_sfd2d_oct
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>



-- 
Ahsan Hadi
Snr Director Product Development
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: +92-51-8358874
Mobile: +92-333-5162114

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the
individual or entity to whom it is addressed. This message contains
information from EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under applicable law. If you are
not the intended recipient or authorized to receive this for the intended
recipient, any use, dissemination, distribution, retention, archiving, or
copying of this communication is strictly prohibited. If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete this message.