Postgres Processing Help !!!!

From: Carlos Roberto Chamorro Mostac <carlosrchamorro(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Processing Help !!!!
Date: 2005-03-30 14:42:53
Message-ID: 20050330144253.45868.qmail@web41403.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?.

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Schapachnik 2005-03-30 14:48:46 libpq usage in Samba
Previous Message Berend Tober 2005-03-30 14:41:49 Re: Postgres mystery