Обсуждение: Patch for testing query modes on pgbench
Here is a patch for testing query modes on pgbench. It is discussed on http://archives.postgresql.org/pgsql-hackers/2007-10/msg00755.php I think this is useful to measure performance of protocols and prepared statements. I hope the extended protocol will be improved as fast as the simple protocol. It is 10-20% slower now. (for 8.4 item) The querymode option is added: -M querymode Choose the query mode from the follows: simple: using simple query protocol. extended: using extended protocol. prepared: using extended protocol with prepared statements. default is simple. Usage: $ pgbench -M [simple|extended|prepared] Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
Вложения
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --------------------------------------------------------------------------- ITAGAKI Takahiro wrote: > Here is a patch for testing query modes on pgbench. It is discussed on > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00755.php > > I think this is useful to measure performance of protocols and > prepared statements. I hope the extended protocol will be improved > as fast as the simple protocol. It is 10-20% slower now. > (for 8.4 item) > > The querymode option is added: > -M querymode > Choose the query mode from the follows: > simple: using simple query protocol. > extended: using extended protocol. > prepared: using extended protocol with prepared statements. > default is simple. > > Usage: > $ pgbench -M [simple|extended|prepared] > > Regards, > --- > ITAGAKI Takahiro > NTT Open Source Software Center > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +