call analyze from stored procedure in C

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

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

--

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mel Jamero 2003-04-03 12:30:05 ERROR: More than one tuple returned by a subselect used as an expression.
Previous Message Josh Berkus 2003-04-02 23:12:45 Re: errors using COPY from MySQL data