Re: Performance tuning?

On Sat, 2007-05-19 at 19:19 -0400, Tom Lane wrote:
> You're comparing fields of distinct types, which not only incurs
> run-time type conversions but can interfere with the ability to
> use some plan types at all.  Looking at the table definitions,
> you've got primary keys declared as SERIAL (ie, integer) and the
> referencing columns declared as NUMERIC(18,0).  This is just horrid
> for
> performance :-( --- NUMERIC arithmetic is pretty slow, and it's really
> pointless when the referenced columns are only integers.  I suspect
> you should have translated these column types as BIGINT (and
> BIGSERIAL).

Thanks again, I'll be sure to get this straightened out and tested again
tomorrow. I thought my nightly backup was analyze'ing the database
afterward, I'll be sure to check that as well.

I really appreciate your analysis! It is my first migration from another
SQL database.

--
Robert