Re: Function scan push-down using SQL/MED syntax - Mailing list pgsql-cluster-hackers

From Takahiro Itagaki
Subject Re: Function scan push-down using SQL/MED syntax
Date
Msg-id 20100309173213.99DD.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: Function scan push-down using SQL/MED syntax  (Hitoshi Harada <umi.tanuki@gmail.com>)
Responses Re: Function scan push-down using SQL/MED syntax  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-cluster-hackers
Hitoshi Harada <umi.tanuki@gmail.com> wrote:

> So, as the first step we implement it by tuplestore with the present
> libpq, but for further improvement we need to refactor or to extend
> our libpq to buffer some sized tuples. Or invent another
> more-data-fetching-oriented protocol like existing copy?

Before starting such optimization, we need some research for which
part is the performance bottleneck when sending large amount of data.

IMHO, since network is typically slower than in-memory data copy,
data compression and burst-transport would be more effective
even if they consume local CPU resources to convert the data format.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center



pgsql-cluster-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: Function scan push-down using SQL/MED syntax
Next
From: Tatsuo Ishii
Date:
Subject: Re: Function scan push-down using SQL/MED syntax