Re: AI for query-planning?

2024-06-22 Thread Pyrote
The current forms of “AI” have no concept of state or long term memory. On each invocation of the AI you have to tell it,This is a Postgres database.This is my database schema.These are the indexes I have.After providing that information the “AI” “might” generate a valid query for your particular

Re: Initiate backup from routine?

2024-01-17 Thread Pyrote
On Wednesday, January 17, 2024, Troels Arvin wrote: Is it possible to call pg_dump (or equivalent action) through a procedure/function? You could create a new schema and table that holds a flag column or a simple queue. Then setup a script/app on a 5 minute cron that checks the status of the