Re: Slow Foreign Key

Поиск
Список
Период
Сортировка
От Sam Barnett-Cormack
Тема Re: Slow Foreign Key
Дата
Msg-id Pine.LNX.4.58.0403222134180.2639@short.lancs.ac.uk
обсуждение исходный текст
Ответ на Re: Slow Foreign Key  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Slow Foreign Key  (Ricardo Vaz Mannrich <rvm_l1@silcom.com.br>)
Список pgsql-admin
On Mon, 22 Mar 2004, Tom Lane wrote:

> Ricardo Vaz Mannrich <rvm_l1@silcom.com.br> writes:
> > Is FOREIGN KEY so slow like that?
>
> Not normally.  Have you checked that the referencing and referenced
> columns are of the same datatype?  Have you done ANALYZE on both tables
> recently?

Other question that seems, from my experience, to be relevant - are the
referenced/referencing columns indexed?

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Subbiah, Stalin"
Дата:
Сообщение: Databases Vs. Schemas
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Databases Vs. Schemas