calling analyze from a stored procedure in C - Mailing list pgsql-performance

From Ulli Mueckstein
Subject calling analyze from a stored procedure in C
Date
Msg-id Pine.LNX.4.44.0303281751290.4731-100000@mescalin.tbi.univie.ac.at
Whole thread Raw
List pgsql-performance
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 few 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

--


pgsql-performance by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: slow query - where not in
Next
From: Bruno Wolff III
Date:
Subject: Re: slow query - where not in