By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,500 Members | 2,766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,500 IT Pros & Developers. It's quick & easy.

Benchmarking tools for PostgreSQL on Linux (fedora)

P: 10
Hello All,
I want to do Bechmarking of PostgreSQL on Linux (fedora) so,please tell me about benchmarking tools of postgresql which is easy to use and implement..It is very urgent for me to do benchmarking of postgresql. I do'nt have deep knowledge about postgresql and benchmarking. I am using "BenchmarkSQL-2.3.2" but it's very difficult to use. so please write me benchmarking tools which is easy to use and free of cost (or at least trial version ,after doing benchmarking we can buy it).
I am searching for benchmarking tools of postgresql on Google search ,but i did'nt found a tool which is easy and free of cost (i.e Good one)...
I am waiting for reply........

Thanks in Advance
Chitranjan Singh.
Aug 13 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 534
Database benchmarking is not to be taken easy, typically the tools are not very simple and require a certain level of knowledge and experience.
You can search web for pgbench, or I would suggest just start with a very simple approach - enable log_duration and log_statement in postgresql.conf and review the log file as you run your queries.
Obviously a big part of it would be building your test data and detemining what exactly you want to test.
Aug 14 '07 #2

P: 10
Database benchmarking is not to be taken easy, typically the tools are not very simple and require a certain level of knowledge and experience.
You can search web for pgbench, or I would suggest just start with a very simple approach - enable log_duration and log_statement in postgresql.conf and review the log file as you run your queries.
Obviously a big part of it would be building your test data and detemining what exactly you want to test.
I have already install postgresql-8.2.4 and it contains the pgbench .I tried to install it ,but i failed to install it .Please explain me , how can i install it..
for installation --> $make
$make install
I have done...
bash-3.1$ su -c"make"
Password:
make: *** No targets specified and no makefile found. Stop.
bash-3.1$ make install
make: stat: GNUmakefile: Permission denied
make: stat: makefile: Permission denied
make: stat: Makefile: Permission denied
make: stat: install: Permission denied
make: *** No rule to make target `install'. Stop.
bash-3.1$ su -c "make install"
Password:
make: *** No rule to make target `install'. Stop.

If above process is not correct, Please send me step by step installation process of "pgbench" .

Thanks in Advance
Chitranjan Singh.
Aug 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.