Re: Problems with "CREATE CAST"

From: John Shott <shott(at)stanford(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with "CREATE CAST"
Date: 2010-03-21 20:20:53
Message-ID: 4BA67FA5.20002@stanford.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane et al:

Thank you for your comments and observations. In particular, you make
me realize that I likely don't know how the JDBC connection is handling
things. I find that I often tend to assume that what I see and use on
the interactive command like is exactly what is coming across the wire
on a JDBC connection. In fact, you are exactly correct about the
inability to use an index on the oid column. We do have an index and
yet have seen performance problems for a table that rarely exceeds a few
hundred rows.

I'll take your advice and see what the JDBC folks suggest and see if we
can handle things in a better fashion.

Thanks again,

John

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-03-21 20:29:30 Re: Transaction table
Previous Message dev mas 2010-03-21 20:18:42 unsubscribe