[PERFORM] Re: [PERFORM] Question about network bandwidth usage between PostgreSQL’s client and server

2013-04-25 Thread Heikki Linnakangas
On 25.04.2013 02:56, Kelphet Xiong wrote: In all the experiments, the lineitem and partsupp tables reside in memory because there is no io activities observed from iotop. Since there is enough network bandwidth (1Gb/s or 128MB/s) between client and server, I would like to know what determines the

[PERFORM] Question about network bandwidth usage between PostgreSQL’s client and server

2013-04-24 Thread Kelphet Xiong
Hi all, I have a general question about network traffic between PostgreSQL’s client and server: what determines the network bandwidth usage or data transferring rate between a client and a server when network bandwidth is enough? For example, I ran queries on two tables, lineitem and parts