Skip site navigation (1) Skip section navigation (2)

calling analyze from a stored procedure in C

From: Ulli Mueckstein <ulim(at)tbi(dot)univie(dot)ac(dot)at>
To: pgsql-performance(at)postgresql(dot)org
Subject: calling analyze from a stored procedure in C
Date: 2003-03-28 17:04:47
Message-ID: Pine.LNX.4.44.0303281751290.4731-100000@mescalin.tbi.univie.ac.at (view raw or flat)
Thread:
Lists: 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

Next:From: Bruno Wolff IIIDate: 2003-03-28 17:53:56
Subject: Re: slow query - where not in
Previous:From: Michael PaesoldDate: 2003-03-28 16:53:46
Subject: Re: slow query - where not in

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group