Re: [ADMIN] Option shared_buffers in PostgreSQL

2011-05-01 Thread Tom Lane
Javier Reyes writes: > I have a server with 4GB of RAM and PostgreSQL 9.0.3 on Centos 5. I'm using > pgbench and pgbench-tools to measure performance, using two pgbench-tools > queries: select and tpc-b. > With default settings of postgresql.conf and select query, I get the > following results:

Re: [ADMIN] Option shared_buffers in PostgreSQL

2011-05-01 Thread Lou Picciano
ell above my paygrade, but I think that's a fair rough outline. (!!) Lou Picciano - Original Message - From: "Javier Reyes" To: [email protected] Sent: Sunday, May 1, 2011 7:20:15 AM Subject: [ADMIN] Option shared_buffers in PostgreSQL Hello. I hav

[ADMIN] Option shared_buffers in PostgreSQL

2011-05-01 Thread Javier Reyes
Hello. I have a server with 4GB of RAM and PostgreSQL 9.0.3 on Centos 5. I'm using pgbench and pgbench-tools to measure performance, using two pgbench-tools queries: select and tpc-b. With default settings of postgresql.conf and select query, I get the following results: Scale: 1, 10, 100, 1000.