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