call analyze from stored procedure in C

From: Ulli Mueckstein <ulim(at)tbi(dot)univie(dot)ac(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: call analyze from stored procedure in C
Date: 2003-04-03 11:01:16
Message-ID: Pine.LNX.4.44.0304031259230.10673-100000@mescalin.tbi.univie.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 a 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

--

Browse pgsql-general by date

  From Date Subject
Next Message Thierry Missimilly 2003-04-03 11:28:54 Problem to add a delay to a date
Previous Message Hubert Krenske 2003-04-03 07:38:41 turning auto-commit off