Home > mailing lists

Foreign key constraints compile faster in 7.4 - Mailing list pgsql-performance

From	Ashish Arte
Subject	Foreign key constraints compile faster in 7.4
Date	May 3, 2005 15:11:33
Msg-id	1115133083.3961.5.camel@skyserver1.openskysoftware.com Whole thread Raw
In response to	Citation for "Bad n_distinct estimation; hacks suggested?" (Gurmeet Manku <manku@CS.Stanford.EDU>)
Responses	Re: Foreign key constraints compile faster in 7.4 (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-performance

Tree view

Hello Everybody,

We recently upgraded to Postgres 7.4 from 7.3.9 and noticed that the
foreign key constraints compile noticeably faster. In 7.3 the
constraints would typically take more than an hour to run on our
production data. Now they take a minute or two.

Can anybody explain such a major performance improvement ?

Thanks

--
Ashish Arte
Open Sky Software

pgsql-performance by date:

From: Markus Schaber
Date: 03 May 2005, 14:42:42
Subject: Re: batch inserts are "slow"

From: Josh Berkus
Date: 03 May 2005, 15:41:53
Subject: Re: batch inserts are "slow"

Foreign key constraints compile faster in 7.4 - Mailing list pgsql-performance

Previous

Next