Re: psql: add \create_function command

2024-01-26 Thread Adam S
idea: what about custom functions for (each) IDE, which calls psql -c "CREATE FUNCTION ..." when the user saves the file? (it would easy to prototype for emacs...) (obviously, this isn't a core feature...) On Fri, Jan 26, 2024 at 3:19 PM Pavel Stehule wrote: > > > pá 26. 1. 2024 v 21:17

INSERT performance: less CPU when no indexes or triggers

2024-01-08 Thread Adam S
I've been thinking about INSERT performance and noticed that copyfrom.c (COPY FROM) performs ~4 unnecessary pointer-deferences per record in the case when there's no indexes and no AFTER ROW INSERT triggers (i.e. when you just want to load data really fast!). I moved the for-loop inside the