Re: huge performance penalty from constraint triggers - Mailing list pgsql-general

From Ben Liblit
Subject Re: huge performance penalty from constraint triggers
Date
Msg-id 3D4A3E18.DFF9A628@eecs.berkeley.edu
Whole thread Raw
In response to Re: huge performance penalty from constraint triggers  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Stephan Szabo wrote:
> Sites has site as a bigint while samples has it as an int.

Stephan, you're my hero.  Changing those columns to match (with bigint)
lets me insert my data in one minute, twelve seconds with indexes and
constraint triggers active.  That's slower than the twenty one seconds
it takes with neither indexes nor triggers, but I'm willing to pay that
price for referential integrity.  It's certainly an improvement over
nineteen hours!

Thanks again, Stephan.  You've saved the day.

pgsql-general by date:

Previous
From: "frank_lupo"
Date:
Subject: Re: problem insert time into column timestamp
Next
From: Xavier Bugaud
Date:
Subject: Re: very slow updates