er mentioned above) and PgBouncer use the binary
format. The performance gains can be significant especially with types such
as timestamptz that are very slow to parse.
As far as only sending binary types that the client can understand, the
client driver would call `set format_binary` at the beginning of the
session.
Jack Christensen
On Mon, Aug 16, 2021 at 7:01 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Mon, Aug 16, 2021 at 4:37 PM Paul Martinez wrote:
>
>>
>> It seems like a somewhat useful feature. If people think it would be
>> useful to
>> implement, I might take a stab at it when I have time.
>>
>>
>
On Tue, Nov 17, 2020 at 1:36 PM Pavel Stehule
wrote:
>
> Personally in your example I very much like notation "update_item.id",
> because there is a clean signal so "id" is the function's argument. When
> you use "$id", then it is not clean if "id" is a local variable or
> function's argument. So
When arguments and other local variables in pl/pgsql functions have the
same name as columns referenced in queries it is necessary to disambiguate
the names. This can be done by prefixing the function name (e.g.
my_func.name), using the argument number is the case of an argument (e.g.
$1), or renam
Regarding decoding binary vs text performance: There can be a significant
performance cost to fetching the binary format over the text format for
types such as text. See
https://www.postgresql.org/message-id/CAMovtNoHFod2jMAKQjjxv209PCTJx5Kc66anwWvX0mEiaXwgmA%40mail.gmail.com
for the previous discu
On Mon, May 18, 2020 at 7:07 AM Laurenz Albe
wrote:
> Did you profile your benchmark?
> It would be interesting to know where the time is spent.
>
Unfortunately, I have not. Fortunately, it appears that Tom Lane recognized
this as a part of another issue and has prepared a patch.
https://www.po
I'm the creator of the PostgreSQL driver pgx (https://github.com/jackc/pgx)
for the Go language. I have found significant performance advantages to
using the extended protocol and binary format values -- in particular for
types such as timestamptz.
However, I was recently very surprised to find th
On 12/29/2017 9:56 AM, Tom Lane wrote:
In https://postgr.es/m/1514541656508-0.p...@n3.nabble.com
it's reported that "SELECT pg_ls_dir('c:')" works to allow
display of the root directory on drive C. If true, this
would be a violation of the principle that the core file
access functions only let
