StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POpostgresql pgBench tool running user defined SQL script
primarykey
Id
17997070
data
AcceptedAnswerId
18003877
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-01T14:38:23.617
FavoriteCount
0
LastActivityDate
2013-08-05T11:31:43.197
LastEditDate
2013-08-05T11:31:43.197
LastEditorUserId
2377115
OwnerUserId
2377115
ParentId
0
PostTypeId
1
Score
3
ViewCount
3612
LastEditorDisplayName
text
Body
Please help me clarify, if the pgbench tool can execute my own sql scenarios in parallel way? Googling and local searching brought no positive result. I run the script that execeutes with no errors. But after execution I see no signs, that my script was actually performed. Does pgbench commits transaction with my sql script? That's an output I get: <pre><code>C:\Program Files\PostgreSQL\9.2\bin>pgbench.exe -n -h dbserverhost -U postgres - T 10 -c 64 -j 8 bench_dbname -f c:\Dev\bench_script.sql transaction type: TPC-B (sort of) scaling factor: 1 query mode: simple number of clients: 64 number of threads: 8 duration: 10 s number of transactions actually processed: 1020 tps = 95.846561 (including connections establishing) tps = 103.387127 (excluding connections establishing) C:\Program Files\PostgreSQL\9.2\bin> </code></pre> SQL script bench_script.sql is: <pre><code>--comment here begin; insert into schm.log values ( 'pgbench test', current_timestamp ); end; </code></pre> SOLUTION pgBench Windows version is sensitive to the order of the arguements passed to the utility: "bench_dbname" argument must be the last one parameter in a line. This is the correct example of pgbench Windows version command line: <pre><code>pgbench.exe -d -r -h 127.0.0.1 -U postgres -T 5 -f C:\Dev\bench_script.sql -c 64 -j 8 postgres </code></pre> The most useful arguments for me were: <ul> <li>-T 60 (time in seconds to run script)</li> <li>-t 100 (transaction amount per client)</li> <li>-d print detailed debug info to the output</li> <li>-r include in summary latency value calculated for every action of the script</li> <li>-f run user defined sql script in benchmark mode</li> <li>-c client amount</li> <li>-j thread amount</li> </ul> <a href="http://www.postgresql.org/docs/9.2/static/pgbench.html" rel="nofollow">pgBench official doc</a> PgBench, I love you! :) Best wishes everybody ;)
Tags
<multithreading><postgresql><benchmarking><plpgsql>
Title
postgresql pgBench tool running user defined SQL script
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USxacinay
UserOwnerUserId
1. USxacinay
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.