Re: Database not browsable during COPY on PostgreSQL

On Tue, March 6, 2012 4:09 am, Majid Azimi wrote:
> On 3/6/12, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> wrote:
>>
>>
>>
>> Majid Azimi <majid(dot)merkava(at)gmail(dot)com> hat am 6. März 2012 um 10:01
>> geschrieben:
>>
>>> On 3/6/12, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> wrote:
>>> >
>>> >
>>> >
>>> > Majid Azimi <majid(dot)merkava(at)gmail(dot)com> hat am 6. März 2012 um 09:36
>>> > geschrieben:
>>> >
>>> >> Hi guys,
>>> >>
>>> >> When using COPY to restore a CSV file, PostgreSQL shows alot of
>>> >>
>>> >> CONTEXT: COPY tbl_vbvdata, line 8039085:
>>> >> "1648469982,20431325,1314343300,4.5,87,1,643160,1"
>>> >>
>>> >> Also phppgadmin shows that the real database size(4GB) but when I
>>> >> choose to browse the table it shows Estimated row count to 0. I did
>>> a
>>> >> VACUUM ANALYZE. After that simple SELECT queries returns 0 rows,
>>> Also:
>>> >>
>>> >> SELECT count(*) FROM tbl_vbvdata
>>> >>
>>> >> return 0. Can anyone help?
>>> >
>>> >
>>> > Your COPY is running inside a Transaction, PhpPgAdmin is outside, it
>>> > can't
>>> > see
>>> > the not-commited rows.
>>> >
>>> >
>>> > Andreas
>>> >
>>>
>>> I pressed CTRL+C when COPY was running and cancelled the process. Now
>>> the DB size is still 4GB but no data is available for SELECT. How can
>>> I commit that?
>>
>>
>> You can't, the whole transaction is canceled now.
>>
>>
>> Andreas
>>
>
>
> I cannot regain the disk space too?

Disk space should be regained during the next vacuum. This will either
happen with the autovacuum, or you can issue the vacuum command manually.

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------