On Tue, Apr 12, 2016 at 9:11 AM, Juan Carlos Michaca Lucero < jc_mich2c...@yahoo.com.mx> wrote:
> Hi PostgreSQL, > > I'm using PostgreSQL 9.3 running on Ubuntu Server. > > I have 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 this function many times from my application, but > something goes wrong with the disk assigned to my temporary tablespace and > all threads were dropped. Now my big table 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 in this table? > Do you want to recover the dead data or the space that it consumes? David J.
