Re: Function scan push-down using SQL/MED syntax

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp
Cc: umi(dot)tanuki(at)gmail(dot)com, pgsql-cluster-hackers(at)postgresql(dot)org
Subject: Re: Function scan push-down using SQL/MED syntax
Date: 2010-03-09 13:54:11
Message-ID: 20100309.225411.24596908.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cluster-hackers

> 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.

Not sure. Once I tested the performance of rsync using two computers
connected with a GbE. With --compress option, rsync was slower than
without the option. Of course this may vary in different CPU
speed/network speed combo though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

In response to

Browse pgsql-cluster-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2010-03-10 02:10:45 meeting at PGCon2010?
Previous Message Takahiro Itagaki 2010-03-09 08:32:13 Re: Function scan push-down using SQL/MED syntax