Обсуждение: Query about pg asynchronous processing support
Dear hacker:
I am an undergraduate from Nanjing University. I use pgsql source code for my own development. During processing each sql query in function 'exec_simple_query', I'm going to add some extra functions such as index recommendation, which should be asynchronous in respect to the sql query in order to ensure the effectiveness of query processing. So my problem is whether pg has some mechanisms supporting asnchronous processing while processing each sql query?
I am also pleased to dig into some detailed blogs or docs you recommend me. Looking forward to your reply!
Yours, sincerely.
Hi, You should search informations about postgres hooks like thoses used in extension pg_stat_statements https://github.com/postgres/postgres/blob/master/contrib/pg_stat_statements/pg_stat_statements.c And about background capabilities as thoses used in extension pg_background https://github.com/vibhorkum/pg_background There are also extensions working with indexes like hypopg https://github.com/HypoPG/hypopg Good luck Regards PAscal -- Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html