Re: exponential performance decrease in ISD transaction

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(at)localhost postgresql-9.1.3]$ pwd
/postgresql/postgresql-9.1.3
[postgsql(at)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(dot)janes(at)gmail(dot)com>:
> On Fri, Aug 31, 2012 at 5:27 AM, John Nash
> <postgres(dot)dba(dot)needs(dot)help(at)gmail(dot)com> 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