Обсуждение: Large update operations and performance

Поиск

Рассылки

Список Везде pgsql-general pgsql-hackers buildfarm-members pgadmin-hackers pgadmin-support pgsql-admin pgsql-advocacy pgsql-announce pgsql-benchmarks pgsql-bugs pgsql-chat pgsql-cluster-hackers pgsql-committers pgsql-cygwin pgsql-docs pgsql-hackers-pitr pgsql-hackers-win32 pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-patches pgsql-performance pgsql-php pgsql-pkg-debian pgsql-pkg-yum pgsql-ports pgsql-rrreviewers pgsql-ru-general pgsql-sql pgsql-students pgsql-testers pgsql-translators pgsql-www psycopg

Период Все Вчера Неделя Месяц Полгода Год

Сортировка По дате, новые По дате, старые По релевантности

Large update operations and performance

От

"Jon Asher"

Дата:

01 октября 2004 г., 23:17:12

I'm running some very large table update operations (on 2 mil + records) and the queries are taking 5 + hours to complete.  Is there a way to turn off row-level index updates or something else to make it run more quickly?

 

Jon