I want to recover the dead data
El Martes, 12 de abril, 2016 11:38:22, David G. Johnston
<[email protected]> escribió:
Send all replies to the list please. In this specific case I'm not going to
be of much help but others should be. You are likely going to need to supply
additional context.
On Tue, Apr 12, 2016 at 9:22 AM, Juan Carlos Michaca Lucero
<[email protected]> wrote:
I want to recover the dead data.
El Martes, 12 de abril, 2016 11:16:15, David G. Johnston
<[email protected]> escribió:
On Tue, Apr 12, 2016 at 9:11 AM, Juan Carlos Michaca Lucero
<[email protected]> wrote:
Hi PostgreSQL, I'musing PostgreSQL 9.3 running on Ubuntu Server. Ihave a
complex function to populate a big table, in order to improve performance;data
is prepared in temporary tables before it will be inserted. I called
thisfunction many times from my application, but something goes wrong with the
diskassigned to my temporary tablespace and all threads were dropped. Now my
bigtable statistics shows tuples inserted and its size is in order of
gigabytes,but a simple SELECT has no rows, is there any way to recover the data
inthis table?
Do you want to recover the dead data or the space that it consumes?
David J.