pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPros and Cons of 8.3.1
7+ messages / 5 participants
[nested] [flat]
* Pros and Cons of 8.3.1
@ 2008-05-02 07:31 Gauri Kanekar <meetgaurikanekar@gmail.com>
0 siblings, 3 replies; 7+ messages in thread
From: Gauri Kanekar @ 2008-05-02 07:31 UTC (permalink / raw)
To: pgsql-performance
Hi,
Can anyone who have started using 8.3.1 list out the pros and cons.
Thanx in advance
~ Gauri
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pros and Cons of 8.3.1
@ 2008-05-02 07:51 Claus Guttesen <kometen@gmail.com>
parent: Gauri Kanekar <meetgaurikanekar@gmail.com>
2 siblings, 0 replies; 7+ messages in thread
From: Claus Guttesen @ 2008-05-02 07:51 UTC (permalink / raw)
To: Gauri Kanekar <meetgaurikanekar@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pros and Cons of 8.3.1
@ 2008-05-02 16:30 Joshua D. Drake <jd@commandprompt.com>
parent: Justin <justin@emproshunts.com>
0 siblings, 0 replies; 7+ messages in thread
From: Joshua D. Drake @ 2008-05-02 16:30 UTC (permalink / raw)
To: Justin <justin@emproshunts.com>; +Cc: Gauri Kanekar <meetgaurikanekar@gmail.com>; pgsql-performance
On Fri, 02 May 2008 12:11:34 -0500
Justin <justin@emproshunts.com> wrote:
>
> don't know for sure if it is windows to linux but we moved to 8.2
> that was install on windows and moved to 8.3.1 on Ubuntu using the
> compiled version from Ubuntu
>
> We had minor annoying problem with implicit data conversion no longer
> happens
It is 8.3.x and the change was documented in the release notes.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pros and Cons of 8.3.1
@ 2008-05-02 16:35 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Gauri Kanekar <meetgaurikanekar@gmail.com>
2 siblings, 0 replies; 7+ messages in thread
From: Kevin Grittner @ 2008-05-02 16:35 UTC (permalink / raw)
To: Gauri Kanekar <meetgaurikanekar@gmail.com>; pgsql-performance
>>> On Fri, May 2, 2008 at 2:31 AM, in message
<7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com>, "Gauri
Kanekar"
<meetgaurikanekar@gmail.com> wrote:
> Can anyone who have started using 8.3.1 list out the pros and cons.
There are bugs in the 8.3.1 release which bit us when we started using
it; however, these are fixed in the 8.3 stable branch of cvs. We are
running successfully with that. These fixes will be in 8.3.2 when it is
released.
http://archives.postgresql.org/pgsql-bugs/2008-04/msg00168.php
It's generally a good idea to test with a new release before putting it
into production, especially a major release.
Since you asked on the performance list -- we have found performance to
be significantly better under 8.3 than earlier releases. Also, the data
takes less space on the disk, and checkpoint disk activity spikes are
reduced in 8.3.
-Kevin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pros and Cons of 8.3.1
@ 2008-05-02 16:46 Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 7+ messages in thread
From: Kevin Grittner @ 2008-05-02 16:46 UTC (permalink / raw)
To: Gauri Kanekar <meetgaurikanekar@gmail.com>; pgsql-performance
Attempting to resend. My first attempt was rejected with this
explanation:
Your message to the pgsql-performance list has been denied
for the following reason(s):
A message was previous posted with this Message-ID
Duplicate Message-ID - <481AFC7B.EE98.0025.0@wicourts.gov> (Fri May 2
13:36:52 2008)
Duplicate Partial Message Checksum (Fri May 2 13:36:52 2008)
>>> On Fri, May 2, 2008 at 2:31 AM, in message
<7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com>, "Gauri
Kanekar"
<meetgaurikanekar@gmail.com> wrote:
> Can anyone who have started using 8.3.1 list out the pros and cons.
There are bugs in the 8.3.1 release which bit us when we started using
it; however, these are fixed in the 8.3 stable branch of cvs. We are
running successfully with that. These fixes will be in 8.3.2 when it is
released.
http://archives.postgresql.org/pgsql-bugs/2008-04/msg00168.php
It's generally a good idea to test with a new release before putting it
into production, especially a major release.
Since you asked on the performance list -- we have found performance to
be significantly better under 8.3 than earlier releases. Also, the data
takes less space on the disk, and checkpoint disk activity spikes are
reduced in 8.3.
-Kevin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pros and Cons of 8.3.1
@ 2008-05-02 16:54 Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 7+ messages in thread
From: Kevin Grittner @ 2008-05-02 16:54 UTC (permalink / raw)
To: Gauri Kanekar <meetgaurikanekar@gmail.com>; pgsql-performance
Attempting to resend. My first attempt was rejected with this
explanation:
Your message to the pgsql-performance list has been denied
for the following reason(s):
A message was previous posted with this Message-ID
Duplicate Message-ID - <481AFC7B.EE98.0025.0@wicourts.gov> (Fri May 2
13:36:52 2008)
Duplicate Partial Message Checksum (Fri May 2 13:36:52 2008)
>>> "Gauri Kanekar" wrote:
> Can anyone who have started using 8.3.1 list out the pros and cons.
There are bugs in the 8.3.1 release which bit us when we started using
it; however, these are fixed in the 8.3 stable branch of cvs. We are
running successfully with that. These fixes will be in 8.3.2 when it is
released.
http://archives.postgresql.org/pgsql-bugs/2008-04/msg00168.php
It's generally a good idea to test with a new release before putting it
into production, especially a major release.
Since you asked on the performance list -- we have found performance to
be significantly better under 8.3 than earlier releases. Also, the data
takes less space on the disk, and checkpoint disk activity spikes are
reduced in 8.3.
-Kevin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Pros and Cons of 8.3.1
@ 2008-05-02 17:11 Justin <justin@emproshunts.com>
parent: Gauri Kanekar <meetgaurikanekar@gmail.com>
2 siblings, 1 reply; 7+ messages in thread
From: Justin @ 2008-05-02 17:11 UTC (permalink / raw)
To: Gauri Kanekar <meetgaurikanekar@gmail.com>; +Cc: pgsql-performance
Gauri Kanekar wrote:
>
> Hi,
>
> Can anyone who have started using 8.3.1 list out the pros and cons.
>
> Thanx in advance
>
> ~ Gauri
don't know for sure if it is windows to linux but we moved to 8.2 that
was install on windows and moved to 8.3.1 on Ubuntu using the compiled
version from Ubuntu
We had minor annoying problem with implicit data conversion no longer
happens
Had several pl/pgsql functions called each other where a programmer got
lazy to not making sure the variable typed matched the parameter type so
we get an error yelling at us can't find function due to data type
mismatch . Its was very easy to fix.
There is allot changes to how Text searches work and the indexes
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2008-05-02 17:11 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-02 07:31 Pros and Cons of 8.3.1 Gauri Kanekar <meetgaurikanekar@gmail.com>
2008-05-02 07:51 ` Claus Guttesen <kometen@gmail.com>
2008-05-02 16:35 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-05-02 17:11 ` Justin <justin@emproshunts.com>
2008-05-02 16:30 ` Joshua D. Drake <jd@commandprompt.com>
2008-05-02 16:46 Re: Pros and Cons of 8.3.1 Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-05-02 16:54 Re: Pros and Cons of 8.3.1 Kevin Grittner <Kevin.Grittner@wicourts.gov>
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