Re: performance for high-volume log insertion

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: performance for high-volume log insertion
Дата
Msg-id dcc563d10904270007g860a8cdo6f38acf25a2c4a43@mail.gmail.com
обсуждение исходный текст
Ответ на Re: performance for high-volume log insertion  (Kris Jurka <books@ejurka.com>)
Список pgsql-performance
On Mon, Apr 27, 2009 at 12:45 AM, Kris Jurka <books@ejurka.com> wrote:
> Scott Marlowe wrote:
>>
>> On Sun, Apr 26, 2009 at 11:07 AM, Kris Jurka <books@ejurka.com> wrote:
>>>
>>> As a note for non-JDBC users, the JDBC driver's batch interface allows
>>> executing multiple statements in a single network roundtrip.  This is
>>> something you can't get in libpq, so beware of this for comparison's
>>> sake..
>>
>> Really?  I thought that executing statements like so:
>>
>> select * from a;insert ...;delete;
>>
>> in psql / libpq would execute them all in one trip.
>
> Right, but those aren't prepared.  I suppose it's possible to issue a
> prepare and then issue a batch of comma separated "execute" statements, but
> that's not exactly a natural interface.

Oh right,.  Sorry, didn't realize you were talking about prepared statements.

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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: performance for high-volume log insertion
Следующее
От: david@lang.hm
Дата:
Сообщение: Re: performance for high-volume log insertion