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