Re: index used when casting to different type? - Mailing list pgsql-general

From Tom Lane
Subject Re: index used when casting to different type?
Date
Msg-id 10901.982637728@sss.pgh.pa.us
Whole thread Raw
In response to Re: index used when casting to different type?  (adb <adb@Beast.COM>)
List pgsql-general
adb <adb@beast.com> writes:
> Ah.. This explains the performance I was getting with rserv, I have
> int4 keys on my replicated tables and _rserv_log_ uses a text column
> to be generic and support keys of different types.  Problem is the
> replicate function does a join from the text column to my key cast
> as text and thus after running for a little bit, slows to a crawl.

> Adding explicit text indexes on my int key columns seems to have
> fixed the problem.

Hmm.  Sounds like room exists for improvement in rserv here ...

            regards, tom lane

pgsql-general by date:

Previous
From: adb
Date:
Subject: Re: index used when casting to different type?
Next
From: Larry Rosenman
Date:
Subject: Re: index used when casting to different type?