On Tue, Jun 14, 2011 at 09:27, Jeff Janes <jeff.ja...@gmail.com> wrote: > pgbench sends each query (per connection) and waits for the reply > before sending another.
We can use -j option to run pgbench in multiple threads to avoid request starvation. What setting did you use, Stefan? >> for those curious - the profile for pgbench looks like: >> samples % symbol name >> 29378 41.9087 doCustom >> 17502 24.9672 threadRun >> 7629 10.8830 pg_strcasecmp If the bench is bottleneck, it would be better to reduce pg_strcasecmp calls by holding meta command names as integer values of sub-META_COMMAND instead of string comparison for each loop. -- Itagaki Takahiro -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
