RT + postgres 8.2?

RT Users
1

Does anyone have any experience using RT w/ postgres 8.2? We are
upgrading postgres from v7.4. Any comments or pointers would be
welcome. Unfortunately, I have not had any hits on the mailing list
archives.

Thanks,
Scot

2

Scot,

PostgreSQL 8.2 works well with RT. There was a post or two to
the mailing list that had some needed tuning suggestions. Also,
be sure to add my patch to DBIx/SearchBuilder/Handle/Pg.m to
make the Tickets query builder usable. I posted it to rt-users
but it has not been incorporated in DBIx::SearchBuilder as of
the 1.48 release. Here is the change needed:

diff Pg.pm Pg.pm_ORIG
238c238
< $$statementref = "SELECT main.* FROM ( SELECT DISTINCT main.id FROM $$statementref ) distinctquery, $table main WHERE (main.id = distinctquery.id) ";

    $$statementref = "SELECT DISTINCT main.* FROM $$statementref";

Also, dump the OID columns when you move to 8.2. If you have
any questions, let me know.

KenOn Fri, Mar 16, 2007 at 02:42:58PM -0500, Scott Kronenfeld wrote:

Does anyone have any experience using RT w/ postgres 8.2? We are
upgrading postgres from v7.4. Any comments or pointers would be
welcome. Unfortunately, I have not had any hits on the mailing list
archives.

Thanks,
Scot

3

I did a fresh install of RT 3.6.3 with Postgre 8.2.3 on Linux (CentOS 4) and
it went relatively well. The most difficult issues were due to the fact
that much of the environment was set up by the hosting provider, so a mess
in terms of dependencies. As far as getting RT going with Postgres 8.2, it
went very smoothly.

Again, these were not upgrades but rather fresh installs of all of the
above.

Cheers,
Steven C. Buttgereit
Dir. IT, Enterprise Applications Group
Party America

Message: 2Date: Fri, 16 Mar 2007 14:42:58 -0500
From: Scott Kronenfeld kronenfe@cs.wisc.edu
Subject: [rt-users] RT + postgres 8.2?
To: rt-users@lists.bestpractical.com
Message-ID: 45FAF342.6060006@cs.wisc.edu
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Does anyone have any experience using RT w/ postgres 8.2? We are
upgrading postgres from v7.4. Any comments or pointers would be
welcome. Unfortunately, I have not had any hits on the mailing list
archives.

Thanks,
Scot

4

Scot,

If you are still running RT 3.4.4, you can ignore the part on
the patch to the DBIx::SearchBuilder module. You are almost
certainly running too old a version for it to apply. Our current
system is 3.4.5 and we had trouble with upgrading the module to
the latest release. I had assumed that you were going to be
running the 3.6.3 release. In the 3.4 series, you need to be
running 3.4.5 at a minimum to take advantage of some key
performance enhancements that affect the PostgreSQL support.
We could only use DBIx::SearchBuilder 1.36 with RT 3.4.5.
Everything works well except that the Tickets search page is
too slow to be usable. If you are not running 3.4.5 or later
it is actually another factor of 2-5 slower which made it
completely unusable.

I would really, really recommend that you upgrade to 3.6.3
with the latest SearchBuilder module and the patch that I sent
you. The performance of the Tickets query builder page draw
time goes from 8+secs in 3.4.5 to ~1sec in 3.6.3 with my patch.
The upgrade is pretty painless with the stickiest part being the
integration of local changes into the new release. Please let me
know if you have any further questions but if you are currently
running 3.4.4 with MySQL you will really see a difference on the
speed of the Tickets query screen when you go to PostgreSQL. This
is a direct result of the development taking place under MySQL
and tuning for other database backends takes place second. It is
easy to test both 3.4.5 and 3.6.3 with a dump of your current
installation and see if the performances problems with the pre-
3.6.3 release are acceptable to your users.

Regards,
KenOn Fri, Mar 16, 2007 at 05:19:35PM -0500, Scott Kronenfeld wrote:

Ken,
Thanks for your quick response. I found the PostgreSQL tuning posts
(but not any that are 8.2 specific).

I neglected to include my version number in the post, but we are running
RT 3.4.4. We apparently don’t have SearchBuilder installed (I’m
inheriting this installation of RT, and learning as I go). I found it
on CPAN, but we don’t have a Pg.pm installed.

I just wanted to verify that our versions were close enough that your
comments apply. We are exploring the OID comment now.

Thanks for your help.
Scot

Kenneth Marshall wrote:

Scot,

PostgreSQL 8.2 works well with RT. There was a post or two to
the mailing list that had some needed tuning suggestions. Also,
be sure to add my patch to DBIx/SearchBuilder/Handle/Pg.m to
make the Tickets query builder usable. I posted it to rt-users
but it has not been incorporated in DBIx::SearchBuilder as of
the 1.48 release. Here is the change needed:

diff Pg.pm Pg.pm_ORIG
238c238
< $$statementref = "SELECT main.* FROM ( SELECT DISTINCT main.id
FROM $$statementref ) distinctquery, $table main WHERE (main.id =
distinctquery.id) ";

   $$statementref = "SELECT DISTINCT main.* FROM $$statementref";

Also, dump the OID columns when you move to 8.2. If you have
any questions, let me know.

Ken

On Fri, Mar 16, 2007 at 02:42:58PM -0500, Scott Kronenfeld wrote:

Does anyone have any experience using RT w/ postgres 8.2? We are
upgrading postgres from v7.4. Any comments or pointers would be
welcome. Unfortunately, I have not had any hits on the mailing list
archives.

Thanks,
Scot