#1 2024-11-18 08:30:06

TPrami
Member
Registered: 2010-07-06
Posts: 119

Improving PostgreSQl insert speed

Yo,

dunno if this is in use, or relevant to mORMot, but take or leave it wink

https://www.timescale.com/blog/boosting … rformance/

-Tee-

Offline

#2 2024-11-18 09:13:36

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,659
Website

Re: Improving PostgreSQl insert speed

AFAIR the ORM is already using UNNEST for both INSERT and UPDATE - and also DELETE with a similar ANY() trick.

Since years. wink

Offline

#3 2024-11-19 10:12:46

TPrami
Member
Registered: 2010-07-06
Posts: 119

Re: Improving PostgreSQl insert speed

ab wrote:

AFAIR the ORM is already using UNNEST for both INSERT and UPDATE - and also DELETE with a similar ANY() trick.

Since years. wink

Nice!

Offline

Board footer

Powered by FluxBB