473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Benchmarking tools for PostgreSQL on Linux (fedora)

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
2 4894
michaelb
534 Expert 512MB
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
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

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

Similar topics

4
by: Logan | last post by:
Several people asked me for the following HOWTO, so I decided to post it here (though it is still very 'alpha' and might contain many (?) mistakes; didn't test what I wrote, but wrote it - more or...
0
by: Flash | last post by:
I have been playing with postgresql at home. This is on a fedora core 2 linux box. Here are the packages yum installed: $ rpm -qa | grep postgres postgresql-libs-7.4.2-1...
125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
4
by: Daniel Secomb | last post by:
Hi, I'm curious to know whether PostgreSQL works well with Fedora RedHat Linux? If there are any issues, I would like to know about them. Many thanks. Dan
6
by: Devrim GUNDUZ | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, We were performing some tests on PostgreSQL and found that it fails on the following query: SELECT 512*18014398509481984 AS result;
2
by: Devrim GUNDUZ | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, (S)RPMs for new point releases (per http://archives.postgresql.org/pgsql-announce/2004-10/msg00010.php) have been built for Fedora Core...
1
by: Devrim GUNDUZ | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --------------------------------------------------------------------- PostgreSQL RPM Set Update 2004-10-26 Version(s): 7.3.8, 7.4.6
2
by: SmoothJazz | last post by:
Hi All! I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro) but I'm not quite sure which way to go. I have a few books on PostgreSQL but they don't seem to match the...
1
by: Robert Uhl | last post by:
Well, I upgraded to Fedora Core 4 and now PostgreSQL won't start, since my data files are from a previous version. A little Googling shows that I should have exported my data before...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.