Re: Query precompilation?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Query precompilation?
Дата
Msg-id
29309.983289393@sss.pgh.pa.us
Ответ на
Query precompilation? (Steffen Emil Thorkildsen)
Список
Дерево обсуждения
Query precompilation? Steffen Emil Thorkildsen <steffent@ifi.uio.no>
Re: Query precompilation? Robert Schrem <Robert.Schrem@WiredMinds.de>
Re: Re: Query precompilation? Mario Weilguni <mweilguni@sime.com>
Re: Query precompilation? Tom Lane <tgl@sss.pgh.pa.us>
Steffen Emil Thorkildsen  writes:
> I have an application which has an queue of data it has to insert into
> a table in a local database. the insert-queries syntax is all the same,
> and the values are the only thing that differs. The insert-query looks
> like this:

>  INSERT INTO "table" VALUES(a, b, c, d, e, f, g, h)

> ...but I cannot insert more than 200/sec, and that is much too slow for
> me.

Consider using COPY FROM STDIN instead ...
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Peter Eisentraut
Дата:
FAQ