Re: [PERFORM] Performance Test for PostgreSQL9

2011-03-02 Thread Joshua D. Drake
On Thu, 2011-03-03 at 13:16 +0800, Selva manickaraja wrote: > Thanks for the enlightenment. I will then look into other tools that > help > with performance testing. Is pgbench really useful? We need to produce > the > reports and statistics to our management as we are planning to migrate > one > s

Re: [PERFORM] Performance Test for PostgreSQL9

2011-03-02 Thread Selva manickaraja
Thanks for the enlightenment. I will then look into other tools that help with performance testing. Is pgbench really useful? We need to produce the reports and statistics to our management as we are planning to migrate one system at a time from Informix. This is to ensure that we do not overload t

Re: [PERFORM] Performance Test for PostgreSQL9

2011-03-02 Thread Greg Smith
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 buil

Re: [PERFORM] Performance Test for PostgreSQL9

2011-03-02 Thread Selva manickaraja
I followed the advice from Melton Low and was able to make and make-install. The reason I had to compile is because there are no binaries for regression tests and the documentation requires us to make-install. On Thu, Mar 3, 2011 at 2:29 AM, Joshua D. Drake wrote: > On Wed, 2011-03-02 at 13:19

Re: [PERFORM] Performance Test for PostgreSQL9

2011-03-02 Thread Joshua D. Drake
On Wed, 2011-03-02 at 13:19 -0500, Robert Haas wrote: > On Sun, Feb 27, 2011 at 10:26 PM, 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

Re: [PERFORM] Performance Test for PostgreSQL9

2011-03-02 Thread Robert Haas
On Sun, Feb 27, 2011 at 10:26 PM, 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. T

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-28 Thread Heikki Linnakangas
On 28.02.2011 11:10, Selva manickaraja wrote: OK, somehow I got these modules installed. Finally I successfully built and installed PostgreSQL! I must thank you guys so much for helping. Now coming to the real issue of the matter. According to the documentation the "gmake installcheck" can be ru

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-28 Thread Selva manickaraja
OK, somehow I got these modules installed. Finally I successfully built and installed PostgreSQL! I must thank you guys so much for helping. Now coming to the real issue of the matter. According to the documentation the "gmake installcheck" can be run in various directories. However it seem to be

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Melton Low
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 in

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Melton Low
Use apt-get to install sudo apt-get install libreadline-dev and zlib1g-dev. Then do a symbolic link for make to gmake. On Sun, Feb 27, 2011 at 11:39 PM, Selva manickaraja wrote: > Yes, true now it looks like pg-general. I started out this discussion > because I couldn't get Performance Testin

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Jochen Erwied
Monday, February 28, 2011, 7:39:30 AM you wrote: > 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 > --

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Selva manickaraja
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 dire

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Mark Kirkwood
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

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Selva manickaraja
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

Re: [PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Mark Kirkwood
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

[PERFORM] Performance Test for PostgreSQL9

2011-02-27 Thread Selva manickaraja
Hi, 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