[HACKERS] client performance v.s. server statistics

2012-02-14 Thread Zhou Han
Hi, I am checking a performance problem encountered after porting old embeded DB to postgreSQL. While the system is real-time sensitive, we are concerning for per-query cost. In our environment sequential scanning (select * from ...) for a table with tens of thousands of record costs 1 - 2

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

2012-02-14 Thread Zhou Han
records ** ** ** ** ** ** * pgsql-hackers-ow...@postgresql.org [mailto: pgsql-hackers-ow...@postgresql.org] On Behalf Of Zhou Han Sent: Wednesday, February 15, 2012 9:30 AM To: pgsql-hackers@postgresql.org Subject: [HACKERS] client performance v.s. server statistics* ** ** Hi, I am