Re: Purging few months old data and vacuuming in production

On 12/30/22 00:39, Ranjith Paliyath wrote: Hi, We have a PostgreSQL (slightly old version, something like - PostgreSQL 11.2 You know, of course, that you should update to the latest version. It's quick and painless. on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8

Fwd: Segmentation fault on RelationGetDescr in my first extension

Hi! I'm trying to write my first extension and open a table in it. I use check_password_hook and my function executes at the moment of changing user password. But if I try to open a table inside this function, I get Segmentation fault on the line with "RelationGetDescr". What am I doing wrong?

Inserts create new records in reporting table

Love the forum, I'm bringing 100k - 200k of AR transactions into a table from several separate ERP companies. As I insert the records, does it make sense to run a trigger event to build or insert data into a reporting table (to save generating a query to build the reporting table later.)