Re: insert vs select into performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: insert vs select into performance
Дата
Msg-id 5666.1184704280@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: insert vs select into performance  (Michael Glaesemann <grzm@seespotcode.net>)
Ответы Re: insert vs select into performance  (Thomas Finneid <tfinneid@student.matnat.uio.no>)
Список pgsql-performance
Michael Glaesemann <grzm@seespotcode.net> writes:
> It would be helpful if you included the actual queries you're using,
> as there are a number of variables:

Not to mention which PG version he's testing.  Since (I think) 8.1,
SELECT INTO knows that it can substitute one fsync for WAL-logging
the individual row inserts, since if there's a crash the new table
will disappear anyway.

            regards, tom lane

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

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: insert vs select into performance
Следующее
От: Thomas Finneid
Дата:
Сообщение: Re: insert vs select into performance