Re:PL/Rust 1.0: now a trusted language for Postgres
by ixfo on Sunday April 09, 2023 @02:27PM
(#35505165)
Doing in-database computation can be very advantageous for some applications, and writing those functions in Rust would be fantastic for some uses, not least for the library ecosystem. I did some work on video similarity search with in-DB search which would've certainly benefited.
Re:PL/Rust 1.0: now a trusted language for Postgres
by ttfkam on Sunday April 09, 2023 @05:19PM
(#35506566)
DB performance also comes from size efficiency of user-defined data types, user-defined operator functions (typically for use with those user-defined data types), etc.
Smaller, more efficient types directly translate to less disk usage and smaller indexes, both of which measurably improve database performance.
Re:PL/Rust 1.0: now a trusted language for Postgres
by pjmlp on Monday April 10, 2023 @03:07AM
(#35509876)
I assume PL/pg is not behind the curve in relation to PL/SQL and T-SQL for UDTs.
Re:PL/Rust 1.0: now a trusted language for Postgres
by doctor_eval on Sunday April 09, 2023 @05:26PM
(#35506635)
> DB performance, comes from indexes , table partitioning and in-memory tables and to compile query execution plans, so you save some time the very first you run a procedure
The network round trip to the database can also be a pretty significant performant penalty, especially when iterating over large sets.
Using a text oriented language like Perl with a good regexp engine might
DB performance, comes from indexes , table partitioning and in-memory tables and to compile query execution plans, so you save some time the very first you run a procedure