Home > mailing lists

call analyze from stored procedure in C - Mailing list pgsql-general

From	Ulli Mueckstein
Subject	call analyze from stored procedure in C
Date	April 7, 2003 06:28:57
Msg-id	Pine.LNX.4.44.0304070927010.21136-100000@mescalin.tbi.univie.ac.at Whole thread Raw
List	pgsql-general

Tree view

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

--

pgsql-general by date:

From: Dennis Gearon
Date: 07 April 2003, 05:19:20
Subject: Re: chron scripts and pgsql

From: Justin Clift
Date: 07 April 2003, 09:33:51
Subject: Postgresql & AMD x86-64

call analyze from stored procedure in C - Mailing list pgsql-general

Previous

Next