Re: Postgres Processing Help !!!!

"Carlos Roberto Chamorro Mostac" <carlosrchamorro@yahoo.com> writes
> Hello to all, I have a problem with the use of
> temporary tables to have if somebody has an idea.
> Handling an application that it requires to process
> 6,000 registries Parents and the processing of each
> one requires to process N registries Children;  Each
> teacher is sent to process in an own session (you do
> not synchronize) creating temporary tables and
> unloading them after which he finishes this session
> and he initiates with another one. The problem this in
> which the first registries soon process relatively
> fast but the response time grows exponentially and
> finally a considered process of 2 hours takes 14.  And
> but it is that the about data base that when single
> initiating weighed 600 Mg turns to 12 GB.  and after
> applying to him to a VACUUM and a REINDEX returns to
> 600 Mb.  Somebody has an idea of because?.
>

Here is why -
http://www.postgresql.org/docs/8.0/static/sql-vacuum.html

Regards,
Qingqing