Re: Adding foreign key performance - Mailing list pgsql-performance

From John K. Herreshoff
Subject Re: Adding foreign key performance
Date
Msg-id 200310281338.43414.jkherr@centurytel.net
Whole thread Raw
In response to Re: Adding foreign key performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Adding foreign key performance
List pgsql-performance
I'm not sure about the analyze stats...  Where would I find that  (in
postgresql.conf I suppose)  I'll go see what I have set up, and get back to
you in 30 minutes or less...

John.

On Tuesday 28 October 2003 13:34, Bruce Momjian wrote:
> John K. Herreshoff wrote:
> > FWIW:  I'm fiddling with that right now, and the FK think was quick...  a
> > few seconds...  the tables in question have 1400 records, 343000 records
> > and 7200 records...  I'm running Beta5...
>
> Did those tables have analyze statistics?  Can you try it without
> statistics (I think you have to drop the tables to erase the
> statistics).


pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Re: Adding foreign key performance
Next
From: "Cestmir Hybl"
Date:
Subject: Ignoring index on (A is null), (A is not null) conditions