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-07 07:28:55
Message-ID: Pine.LNX.4.44.0304070927010.21136-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 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 Peter Nixon 2003-04-07 09:39:05 extracting time from a timestamp with time zone field
Previous Message Dennis Gearon 2003-04-07 06:19:15 Re: chron scripts and pgsql