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

2012-02-14 Thread Zhou Han
t; not created index. > > **2. **What is exact scenario for fetching records > > ** ** > > ** ** > > ** ** > > * pgsql-hackers-ow...@postgresql.org [mailto: > pgsql-hackers-ow...@postgresql.org] On Behalf Of Zhou Han > Sent: Wednesday, February 1

[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 seconds