Re: [GENERAL] Foreign keys and slow insert

2005-06-08 Thread Dan Black
I think 21 interns will be enough :)2005/6/8, Scott Marlowe <[EMAIL PROTECTED]>: On Wed, 2005-06-08 at 12:39, Dan Black wrote:> 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  perfo

Re: [GENERAL] Foreign keys and slow insert

2005-06-08 Thread Scott Marlowe
On Wed, 2005-06-08 at 12:39, Dan Black wrote: > 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

Re: [GENERAL] Foreign keys and slow insert

2005-06-08 Thread Dan Black
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

Re: [GENERAL] Foreign keys and slow insert

2005-06-08 Thread Richard Huxton
Dan Black wrote: I read in documentation that primary key doesn't require additional indexes but I could find nothing about foreign keys. Do I need to create additional indexes when I create foreign keys? Example: create table master create table slave Do I need to create index CREATE IN

Re: [GENERAL] Foreign keys and slow insert

2005-06-08 Thread Stephan Szabo
On Wed, 8 Jun 2005, Dan Black wrote: > I read in documentation that primary key doesn't require additional indexes > but I could find nothing about foreign keys. > Do I need to create additional indexes when I create foreign keys? > Example: > create table master > { > master_id INT4, > master_nam