On Thu, May 15, 2008 at 3:48 PM, Semi Noob <seminoob@xxxxxxxxx> 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
