Re: exponential performance decrease in ISD transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

We can try installing version 8.4.9, but when downloading the
software, we installed the binaries and files given in postgresql web
page named as version 9.1.3. This is the tar file downloaded:

postgresql-9.1.3.tar

Containing the following when un-tar-ed:

[postgsql@localhost postgresql-9.1.3]$ pwd
/postgresql/postgresql-9.1.3
[postgsql@localhost postgresql-9.1.3]$ ll
total 2528
-rwxrwxrwx  1 postgsql gpostgre     385 Feb 23  2012 aclocal.m4
drwxrwxrwx  2 postgsql gpostgre    4096 Feb 24  2012 config
-rwxrwxrwx  1 postgsql gpostgre  326754 Jun  4 10:30 config.log
-rwxrwxrwx  1 postgsql gpostgre   37900 Jun  4 10:30 config.status
-rwxrwxrwx  1 postgsql gpostgre  866562 Feb 23  2012 configure
-rwxrwxrwx  1 postgsql gpostgre   63599 Feb 23  2012 configure.in
drwxrwxrwx 51 postgsql gpostgre    4096 Feb 24  2012 contrib
-rwxrwxrwx  1 postgsql gpostgre    1192 Feb 23  2012 COPYRIGHT
drwxrwxrwx  3 postgsql gpostgre    4096 Feb 24  2012 doc
-rw-r--r--  1 postgsql gpostgre    3741 Jun  4 10:30 GNUmakefile
-rwxrwxrwx  1 postgsql gpostgre    3741 Feb 23  2012 GNUmakefile.in
-rwxrwxrwx  1 postgsql gpostgre 1165183 Feb 24  2012 HISTORY
-rwxrwxrwx  1 postgsql gpostgre   76550 Feb 24  2012 INSTALL
-rwxrwxrwx  1 postgsql gpostgre    1489 Feb 23  2012 Makefile
-rwxrwxrwx  1 postgsql gpostgre    1284 Feb 23  2012 README
drwxrwxrwx 14 postgsql gpostgre    4096 Jun  4 10:30 src


2012/8/31 Jeff Janes <jeff.janes@xxxxxxxxx>:
> On Fri, Aug 31, 2012 at 5:27 AM, John Nash
> <postgres.dba.needs.help@xxxxxxxxx> wrote:
>
>> -Postgresql version installed is : postgresql-9.1.3 although when
>> querying the database we retrieve this output.
>>
>> postgres=# select * from version();
>>                                                      version
>> -----------------------------------------------------------------------------------------------------------------
>>  PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc
>> (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit
>
> Hi John,
>
> You have two versions of pgsql installed, and the one you are running
> is not the one you think you are running.
>
> That's probably the first thing to sort out--repeat the experiment
> with the correct version.
>
> Also, rather than posting the entire config file, you can get just the
> non-default settings:
>
> https://wiki.postgresql.org/wiki/Server_Configuration
>
>
> Cheers,
>
> Jeff


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux