Force PostgreSQL to use indexes on foreign key lookups - Was: Slow Inserts on 1 table?

Поиск
Список
Период
Сортировка
От Dan Armbrust
Тема Force PostgreSQL to use indexes on foreign key lookups - Was: Slow Inserts on 1 table?
Дата
Msg-id 42EF99DC.7040304@gmail.com
обсуждение исходный текст
Ответ на Re: Slow Inserts on 1 table?  ("Jim C. Nasby" <decibel@decibel.org>)
Список pgsql-general
An aha moment:

http://archives.postgresql.org/pgsql-bugs/2005-03/msg00183.php

Some of the ensuing conversation seemed to indicate that a change was
made in the 8.0 branch in March, that was intended to fix this issue.
Any idea if that fix would have made it into the 8.0.3 release?

Or maybe the fix didn't fix the issue.

Dan


--
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: feeding big script to psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CLUSTER equivalent