Sorry I forgot to attach the mentioned file with performance results.
Please find it enclosed now.
Regards
2012/9/7 John Nash :
> Hi,
>
> We have investigated further and have observed the following:
>
> We have another host with postgres installed in another IP. Called host 190.
>
> The host we
Hi,
We have investigated further and have observed the following:
We have another host with postgres installed in another IP. Called host 190.
The host we have reported to have the issue is host174
We have observed that if we launch the java program from host 190
towards host 174 through the ne
On 09/03/2012 01:27 PM, Jeff Janes wrote:
In any case, the behavior you report is exactly would would be
expected if autovacuum is not running. The config file you posted
shows autovac is turned on, but I suspect that is not the config file
actually being used by the running server.
It's also
On Mon, Sep 3, 2012 at 4:22 AM, John Nash
wrote:
> 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 t
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.
On Fri, Aug 31, 2012 at 5:27 AM, John Nash
wrote:
> -Postgresql version installed is : postgresql-9.1.3 although when
> querying the database we retrieve this output.
>
> postgres=# select * from version();
> version
> -
On 31.08.2012 15:27, John Nash wrote:
Program 1: dbtransfromfile: this program creates a simple table
consisting of a one int column table. After the creation, the program
inserts 1000 tuples in the table, which are never deleted, after that
the program reads a transaction pattern from a given fi
Hello,
We are doing some testing and have a very strange behaviour in the
performance obtained with postgres while executing a
Insert/select/delete transaction.
Software and Hardware details:
- O.S = Red hat 6.2
$ uname -a
Linux localhost.localdomain 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9
08:03
