The patch adds support of ldap auth method to pgproto. For ldap we
request user password in clear text using corresponding protocol
message. Afterwards password is passed to tarantool `authenticate`
method which handles ldap based auth.

Important: since password is transferred as clear text it is advised to
setup ssl.

Maksim Kaitmazian authored 4 months ago and Dmitry Ivanov committed 4 months ago

With these changes, a user can specify new default values for vdbe_max_steps
vtable_max_rows options in connection string.

For example, the following connection string sets both options to 42:
postgres://postgres:Passw0rd@localhost:5432?options=vtable_max_rows%3D42,vdbe_max_steps%3D42

Maksim Kaitmazian authored 5 months ago and Maksim Kaitmazian committed 4 months ago

Previously, the plan was cloned during execution to avoid polluting
the cache. However, this appears unnecessary as it was already cloned
from the cache before binding parameters.

This commit eliminates this cloning, which can result to +7.56% of
performance improvement, as demonstrated in
https://git.picodata.io/picodata/picodata/picodata/-/issues/1026#note_107222.

Maksim Kaitmazian authored 5 months ago and Dmitry Ivanov committed 4 months ago

Disabling the tracing feature has shown a significant performance improvement
of 72.50%, as demonstrated in https://git.picodata.io/picodata/picodata/picodata/-/issues/1026#note_107222.

This commit disables "tracing" feature for sbroad and eliminates
the opentelemetry wrappers and statistics tables.

See https://git.picodata.io/picodata/picodata/sbroad/-/issues/837

godzie44 authored 6 months ago and Georgy Moshkin committed 6 months ago

Closes #664

feat: support ALTER SYSTEM. It allows to change whitelisted properties from _pico_property table. Currently, changes affect all tiers. Specifying tier will result in an error.

Co-Authored-by: Dmitry Rodionov <d.rodionov@picodata.io>

Co-Authored-by: Emir Vildanov <e.vildanov@picodata.io>

Arseniy Volynets authored 7 months ago and Arseniy Volynets committed 6 months ago

- update sbroad submodule to commit with
new normalization rules
- update integration tests

Previously, we retrieved the row count using rows.len(), where rows was an
iterator that returned the remaining number of rows instead of the
total number of rows sent.