Re: [PERFORM] Fwd: [HACKERS] client performance v.s. server statistics

2012-02-15 Thread Han Zhou
Freund wrote: > On Wednesday, February 15, 2012 12:33:13 PM Han Zhou wrote: >> Hi, >> >> To be more specific, I list my calculation here: >> The timing shown in psql may include: plan + execution + copying to >> result set in backend (does this step exist?) + tr

Re: [PERFORM] Fwd: [HACKERS] client performance v.s. server statistics

2012-02-15 Thread Han Zhou
15, 2012 at 7:02 PM, Han Zhou wrote: > Hi Andres, > > May you missed my first post, and I paste it here again: > In our environment sequential scanning (select * from ...) for a table > with tens of thousands of record costs 1 - 2 seconds, regardless of > using ODBC driver or th

Re: [PERFORM] Fwd: [HACKERS] client performance v.s. server statistics

2012-02-15 Thread Han Zhou
Hi Andres, May you missed my first post, and I paste it here again: In our environment sequential scanning (select * from ...) for a table with tens of thousands of record costs 1 - 2 seconds, regardless of using ODBC driver or the "timing" result shown in psql client (which in turn, relies on lib