Re: foreign key performance

От: Alvaro Herrera
Тема: Re: foreign key performance
Дата: ,
(см: обсуждение, исходный текст)
Ответ на: foreign key performance  (Enrico Weigelt)
Список: pgsql-performance

On Fri, Apr 22, 2005 at 02:06:15AM +0200, Enrico Weigelt wrote:

> do foreign keys have any influence on performance (besides slowing
> down huge inserts) ? do they bring any performance improvement ?

No.  They only cause additional tables to be visited to enforce them.

Alvaro Herrera (<alvherre[@]>)
"Ciencias políticas es la ciencia de entender por qué
 los políticos actúan como lo hacen"  (

В списке pgsql-performance по дате сообщения:

От: Andreas Pflug
Сообщение: Re: Joel's Performance Issues WAS : Opteron vs Xeon
От: Dawid Kuroczko
Сообщение: Re: immutable functions vs. join for lookups ?