Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-cluster-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group