Re: Weird Database Performance problem!

Arash Zaryoun wrote:
> Hi,
>
> We are having a performance problem with our database. The problem
> exists when we include a constraint in GCTBALLOT. The constraint is as
> follows:
>
> alter table GCTBALLOT
> add constraint FK_GCTBALLOT_GCTWEBU foreign key (GCTWEBU_SRL)
> references GCTWEBU (SRL)
> on delete restrict on update restrict;
>
> The two tables that we insert into are the following:

> GCTBALLOT:
> gctwebu_srl | numeric(12,0) |

> GCTWEBU:
> srl | integer | not null default

Your types don't match. You have a numeric referencing an integer. PG
probably isn't using the index (it's smarter about this in 8.0 iirc).

HTH
--
Richard Huxton
Archonet Ltd