Thread: Performance Test for PostgreSQL9

On 28/02/11 16:26, Selva manickaraja wrote:

We have installed PostgreSQL9 and setup standby(s). Now we have to test the performance before we migrate all the data from Informix. The PostgreSQL9 that we installed is the Linux version from EnterpriseDB which runs on Red Hat. The documentation on PostgreSQL website shows that we have gmake from source. So for that purpose we downloaded the source into a UBuntu machine to gmake and install it. But UBuntu on the other hand complaints that it can't find gmake. So looks like we are stuck here.

What should we do?
(1) Is the a binary for the Regression Test module that can be downloaded and ran from the RedHat environment? OR
(2) If there are no binary, how to proceed if gmake does not run in UBuntu?

'gmake' means GNU make - in the case of Linux, the binary is simply 'make'. E.g on my Ubuntu 10.10 system:

$ make --version
GNU Make 3.81
Copyright (C) 2006  Free Software Foundation, Inc.

regards

Mark

On 28/02/11 18:09, Selva manickaraja wrote:

As mentioned in the documentation, I went to the directory src/test/regress and ran the command. It gives the error

GNUmakefile:15: ../../../src/Makefile.global: No such file or directory
GNUmakefile:80: /src/Makefile.shlib: No such file or directory
make: *** No rule to make target `/src/Makefile.shlib'.  Stop.

Really can't make any sense out of this.

Any ideas?

You have not run configure to generate these make files (or you have run 'make distclean' to destroy them).

generally you need to do:

$ ./configure --prefix=your-chosen-install-prefix-here
$ make
$ make install
$ make check

The last step runs the regression test.

regards

Mark

P.s: this discussion really belongs on pg-general rather than performance, as it is about building and installing postgres rather than performance, *when* you have it installed ok, then performance based discussion here is fine :-)

Resending.  Hit the send button too soon.

Use apt-get to install

sudo apt-get install libreadline-dev

sudo apt-get install  zlib1g-dev

and other dependencies mentioned in the source distribution INSTALL file.

ln -s /usr/bin/make /usr/bin/gmake

This will give you gmake which would already be installed in Ubuntu as make but allow it to be invoke as gmake.

Then follow the configure, make and install steps previously posted.

You can also get the ppa package from 

http://www.openscg.org/

Cheers, 

Mel

On Sun, Feb 27, 2011 at 11:39 PM, Selva manickaraja <mavles78@gmail.com> wrote:

Yes, true now it looks like pg-general. I started out this discussion because I couldn't get Performance Testing done. But looks like the performance cannot be done due to the tool cannot be built...:) and all evils are getting unleashed from this..

OK, I did exactly to move to the top of the directory and run the ./configure first. Everything work until the last time it reports error now....

-----------------------------------------------------------------------------------------------
checking for -lreadline... no
checking for -ledit... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure.  It is possible the compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.
-----------------------------------------------------------------------------------------------

I tried man readline and man edit, there seem to manuals on it. I checked the Synaptic Manager. There seem to be a package called readline-common. I then search the net for some assistance. Looks like there was another guy who had a similar problem like me. The URL is http://ubuntuforums.org/showthread.php?t=1638949

So I tried installing 'readline' using

->sudo apt-cache search readline
AND
->sudo apt-get install libreadline6 libreadline6-dev

Upon answering 'y' to install without verification, I get Bad Gateway error.

Install these packages without verification [y/N]? y
Err http://my.archive.ubuntu.com/ubuntu/ maverick/main libncurses5-dev i386 5.7+20100626-0ubuntu1
  502  Bad Gateway
Err http://my.archive.ubuntu.com/ubuntu/ maverick/main libreadline6-dev i386 6.1-3
  502  Bad Gateway
Failed to fetch http://my.archive.ubuntu.com/ubuntu/pool/main/n/ncurses/libncurses5-dev_5.7+20100626-0ubuntu1_i386.deb  502  Bad Gateway
Failed to fetch http://my.archive.ubuntu.com/ubuntu/pool/main/r/readline6/libreadline6-dev_6.1-3_i386.deb  502  Bad Gateway
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Looks like I'm stuck at this level. Please assist to breakaway....

Thank you.

Regards,

Selvam

On Mon, Feb 28, 2011 at 1:53 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:

On 28/02/11 18:09, Selva manickaraja wrote:

As mentioned in the documentation, I went to the directory src/test/regress and ran the command. It gives the error

GNUmakefile:15: ../../../src/Makefile.global: No such file or directory
GNUmakefile:80: /src/Makefile.shlib: No such file or directory
make: *** No rule to make target `/src/Makefile.shlib'.  Stop.

Really can't make any sense out of this.

Any ideas?

You have not run configure to generate these make files (or you have run 'make distclean' to destroy them).

generally you need to do:

$ ./configure --prefix=your-chosen-install-prefix-here
$ make
$ make install
$ make check

The last step runs the regression test.

regards

Mark

P.s: this discussion really belongs on pg-general rather than performance, as it is about building and installing postgres rather than performance, *when* you have it installed ok, then performance based discussion here is fine :-)

On Wed, 2011-03-02 at 13:19 -0500, Robert Haas wrote:
> On Sun, Feb 27, 2011 at 10:26 PM, Selva manickaraja <mavles78@gmail.com> wrote:
> > We have installed PostgreSQL9 and setup standby(s). Now we have to test the
> > performance before we migrate all the data from Informix. The PostgreSQL9
> > that we installed is the Linux version from EnterpriseDB which runs on Red
> > Hat. The documentation on PostgreSQL website shows that we have gmake from
> > source. So for that purpose we downloaded the source into a UBuntu machine
> > to gmake and install it. But UBuntu on the other hand complaints that it
> > can't find gmake. So looks like we are stuck here.
>
> I am a bit confused.  Why would you need to install from source
> instead of using an installer (either from EnterpriseDB or installing
> via apt-get)?

To be rude but honest. If you can't solve that problem you really should
contract with someone to help you with your performance tests because
you are not going to be able to adequately tune PostgreSQL for a proper
test.

That said, the reason you can't find make is that you don't have the
proper development tools installed.

+1 to what Robert said.

Sincerely,

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

Selva manickaraja wrote:

The reason I had to compile is because there are no binaries for regression tests and the documentation requires us to make-install.

The reason for that is there is little reason for users of the database to ever run those.  Most (possibly all) of the the packaged builds will run the regression tests as part of the build process.  So the odds of you finding an error with them is pretty low. 

I'm getting the impression you think that the regression tests are somehow useful for performance testing.  They aren't; they are strictly code quality tests.  The only performance testing tool that comes with the database is pgbench, which is a tricky tool to get useful test results from.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books