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  (Juan Casero <caseroj@comcast.net>)
Список pgsql-performance
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"
Дата:
Сообщение: Re: Speed of different procedural language
Следующее
От: Carlos Benkendorf
Дата:
Сообщение: Re: ORDER BY costs