Re: Database restore speed

Поиск
Список
Период
Сортировка
От Mitch Skinner
Тема Re: Database restore speed
Дата
Msg-id 1133580366.3367.123.camel@enzian
обсуждение исходный текст
Ответ на Re: Database restore speed  ("Luke Lonergan" <llonergan@greenplum.com>)
Список pgsql-performance
On Fri, 2005-12-02 at 13:24 -0800, Luke Lonergan wrote:
> It's a matter of safety and generality - in general you
> can't be sure that client machines / OS'es will render the same conversions
> that the backend does in all cases IMO.

Can't binary values can safely be sent cross-platform in DataRow
messages?  At least from my ignorant, cursory look at printtup.c,
there's a binary format code path.  float4send in utils/adt/float.c uses
pq_sendfloat4.  I obviously haven't followed the entire rabbit trail,
but it seems like it happens.

IOW, why isn't there a cross-platform issue when sending binary data
from the backend to the client in query results?  And if there isn't a
problem there, why can't binary data be sent from the client to the
backend?

Mitch

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Small table or partial index?
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Database restore speed