Re: savepoint problems

Поиск
Список
Период
Сортировка
От Linos
Тема Re: savepoint problems
Дата
Msg-id 48939061.1050500@linos.es
обсуждение исходный текст
Ответ на Re: savepoint problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane escribió:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> On Fri, Aug 01, 2008 at 06:30:36PM +0200, Linos wrote:
>>> i have migrated from Maxdb to Postgresql recently and i am having a
>>> speed problem in large transactions over slow links because of autorollback
>
>> If the goal is to reduce latency costs, the best way could be:
>> [ move it to the server side ]
>
> Or move the logic into a server-side function, if you prefer to stick
> with your existing procedural approach.
>
>             regards, tom lane
>

when you say move the logic into a server-side function do you mean send the data in a
copy command (or many inserts) to a temporary table and load from here with a server-side
functions like David or Martijn or are you telling me other way to do it, could you
elaborate this please? Thanks.

Regards,
Miguel Angel.

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

Предыдущее
От: Linos
Дата:
Сообщение: Re: savepoint problems
Следующее
От: Glen Parker
Дата:
Сообщение: Re: non-WAL btree?