Re: Foreign keys and slow insert

From: Dan Black <fireworker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Foreign keys and slow insert
Date: 2005-06-08 17:39:53
Message-ID: 27f60625050608103951d73959@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've observed that inserts into slave table became slower when I use foreign
key than without one.
Can it be related to foreign key?
And I am interested how much performance of database with foreign keys can
be different from performance of database without foreign keys? In other
words, how much performance decrease on using foreign keys?

Thanks :-)
--
Verba volent, scripta manent
My ISP - http://www.netbynet.ru

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gorodowienko Daniel 2005-06-08 18:03:40 So maybe SQLERRM? Sb knows how to check it?
Previous Message Yuri B. Lukyanov 2005-06-08 17:31:17 Two updates problem