call analyze from stored procedure in C

Started by Ulli Muecksteinabout 23 years ago1 messagesgeneral
Jump to latest
#1Ulli Mueckstein
ulim@tbi.univie.ac.at

Hi everybody!

I have to insert a lot of data (more than 1.000.000 rows) in various
tables. I use stored procedures in C to insert the data. It is necessary
to run ANALYZE after inserting some thousand rows into a table. Can
someone tell me how to call ANALYZE
(or analyze_rel(Oid relid, VacuumStmt *vacstmt))
from a C stored procedure ? Any help would be appreciated.

Thanks

Ulli Mueckstein

--