From: Claus Guttesen <kometen@gmail.com>
To: Gauri Kanekar <meetgaurikanekar@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Pros and Cons of 8.3.1
Date: Fri, 2 May 2008 09:51:09 +0200
Message-ID: <b41c75520805020051i4c14472ap8831dddc56a27ffd@mail.gmail.com> (raw)
In-Reply-To: <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com>
References: <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com>
> Can anyone who have started using 8.3.1 list out the pros and cons.
I upgraded to 8.3.1 yesterday from 8.3.0. I've used 8.3.0 since it was
released and it's working fine. I upgraded from 7.4 (dump/restore) and
it was working out of the box. We have somewhat simple sql-queries so
there was no need to change/alter these. The largest table has approx.
85 mill. records (image-table).
One thing I had newer seen before was that duplicate rows was inserted
into our order-table but I don't know whether this is due to changes
in the web-app or 8.3.0. Now that I upgraded to 8.3.1 I will wait a
few weeks and see if I get the same error before I alter the column
and add a unique contraint.
So from a 7.4-perspective and fairly simple queries I don't see any issues.
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.
Shakespeare
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kometen@gmail.com, meetgaurikanekar@gmail.com
Subject: Re: Pros and Cons of 8.3.1
In-Reply-To: <b41c75520805020051i4c14472ap8831dddc56a27ffd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox