Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign keys and slow insert - Mailing list pgsql-general

From Dan Black
Subject Re: Foreign keys and slow insert
Date
Msg-id 27f60625050608103951d73959@mail.gmail.com
Whole thread Raw
In response to Foreign keys and slow insert  (Dan Black <fireworker@gmail.com>)
Responses Re: Foreign keys and slow insert  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Yuri B. Lukyanov"
Date:
Subject: Two updates problem
Next
From: "Gorodowienko Daniel"
Date:
Subject: So maybe SQLERRM? Sb knows how to check it?