| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Juan Carlos Michaca Lucero <jc_mich2c3c1(at)yahoo(dot)com(dot)mx> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Table seems empty but its size is in gigabytes |
| Date: | 2016-04-12 16:16:15 |
| Message-ID: | CAKFQuwaiXJp=XuhCecQRSfUffdPi0m=2JLiVuv8q4Zjks7rK9Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 12, 2016 at 9:11 AM, Juan Carlos Michaca Lucero <
jc_mich2c3c1(at)yahoo(dot)com(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2016-04-12 16:30:09 | Re: Table seems empty but its size is in gigabytes |
| Previous Message | Juan Carlos Michaca Lucero | 2016-04-12 16:11:48 | Table seems empty but its size is in gigabytes |