Re: MySQL is faster than PgSQL but a large margin in

Поиск
Список
Период
Сортировка
Искать
От
Markus Schaber
Тема
Re: MySQL is faster than PgSQL but a large margin in
Дата
Msg-id
43AAAB58.6050109@logix-tt.com
Ответ на
Список
Дерево обсуждения
Re: MySQL is faster than PgSQL but a large margin in "Luke Lonergan" <LLonergan@greenplum.com>
Re: MySQL is faster than PgSQL but a large margin in Madison Kelly <linux@alteeve.com>
Re: MySQL is faster than PgSQL but a large margin in "Luke Lonergan" <llonergan@greenplum.com>
Re: MySQL is faster than PgSQL but a large margin in Markus Schaber <schabi@logix-tt.com>
Re: MySQL is faster than PgSQL but a large margin in Juan Casero <caseroj@comcast.net>
Re: MySQL is faster than PgSQL but a large margin in Vivek Khera <vivek@khera.org>
Hi, Madison,
Hi, Luke,

Luke Lonergan wrote:

> Note that indexes will also slow down loading.

For large loading bunches, it often makes sense to temporarily drop the
indices before the load, and recreate them afterwards, at least, if you
don't have normal users accessing the database concurrently.

Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
В списке pgsql-performance по дате отправления
От: Merlin Moncure
Дата:
От: Carlos Benkendorf
Дата:
Сообщение: Re: ORDER BY costs
FAQ