call analyze from stored procedure in C

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

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-hackers by date

  From Date Subject
Next Message Robert Treat 2003-04-15 14:19:11 Re: Are we losing momentum?
Previous Message Tom Lane 2003-04-15 14:17:27 Re: [GENERAL] Problem about pgsql's column alias