Re: Pros and Cons of 8.3.1

From: "Claus Guttesen" <kometen(at)gmail(dot)com>
To: "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Pros and Cons of 8.3.1
Date: 2008-05-02 07:51:09
Message-ID: b41c75520805020051i4c14472ap8831dddc56a27ffd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message chirag.dave 2008-05-02 14:09:49 Re: Vacuum statistics
Previous Message Gauri Kanekar 2008-05-02 07:31:28 Pros and Cons of 8.3.1