From: | "ALFREDO ALARCON" <alfalar(at)gmail(dot)com> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Ayuda postgresql windows!!! |
Date: | 2006-11-06 19:28:59 |
Message-ID: | ad0122e80611061128i14307496g55b9eb27324b1b9c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Buen día!!!
Tengo un problema con postgresql en su version windows y quisiera saber si
alguien me puede dar una luz. El problema es el siguiente:
Tengo un sistema que esta llenando una tabla de la base de datos
aproximadamente en 300000 registros al día, pero pasados 3 o 4 dias la base
de datos me da problemas de lentitud y debo empezar a borrarle registros a
la tabla. La tabla tiene indices (btree y gist, pues es una tabla
geografico) y se le hace vacumm analize seguido. El otro problema se me
presento esta semana, el servicio de base de datos se cayo y ya no subio
mas. El log que me dejo fue el siguiente:
2006-11-04 20:37:16 LOG: database system was interrupted while in recovery
at 2006-11-04 20:37:09 Hora est. de América Central
2006-11-04 20:37:16 HINT: This probably means that some data is corrupted
and you will have to use the last backup for recovery.
2006-11-04 20:37:16 LOG: checkpoint record is at A/542596F0
2006-11-04 20:37:16 LOG: redo record is at A/5421D588; undo record is at
0/0; shutdown FALSE
2006-11-04 20:37:16 LOG: next transaction ID: 91511486; next OID: 33784
2006-11-04 20:37:16 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-11-04 20:37:16 LOG: database system was not properly shut down;
automatic recovery in progress
2006-11-04 20:37:16 LOG: redo starts at A/5421D588
2006-11-04 20:37:16 PANIC: could not access status of transaction 0
2006-11-04 20:37:16 DETAIL: could not write to file "pg_clog/0057" at offset
73728: No space left on device
This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.
2006-11-04 20:37:16 LOG: startup process (PID 1348) was terminated by signal
3
2006-11-04 20:37:16 LOG: aborting startup due to startup process failure
2006-11-04 20:37:17 LOG: logger shutting down
Agradezco su ayuda
--
Alfredo Alarcón
From | Date | Subject | |
---|---|---|---|
Next Message | darkglam darkglam | 2006-11-06 19:43:53 | Re: Ayuda postgresql windows!!! |
Previous Message | Fernanda Fueltala | 2006-11-06 19:21:28 | Re: Error en funcion con OID |