On Thu, May 15, 2008 at 3:48 PM, Semi Noob <seminoob@gmail.com> wrote:
>
>
> I set max_connections is 200.
What error message you get when you try with more than 64 clients ?
> 57 seems a small number, according to you, how much tps is normal or fast?
Its difficult to say how much is good. On my laptop for s = 10, c =
40, t = 1000, I get 51 tps. But on a larger 2 CPU, 2 GB, 3 RAID 0
disks for data and a separate disk for xlog, I get 232 tps.
> and what is the different of "shared_buffers" and "effective_cache_size".
>
"shared_buffers" is the size of the buffer pool which Postgres uses to
cache the data blocks.
"effective_cache_size" is usually size of the shared buffer plus
estimate of whatever data OS can cache. Planner uses this
approximation to choose right plan for execution.
http://www.postgresql.org/docs/8.3/interactive/runtime-config-query.html
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com