Search Postgresql Archives

Re: nonremovable row ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, May 04, 2005 at 18:24:53 +0200,
  Hervé Piedvache <herve@xxxxxxx> wrote:
> 
> Why I get 26927405 nonremovable row versions in 185707 pages ?
> How to remove them ? I need to free the space quickly !

Those rows will still be visible to transactions that started before
the delete was committed. Once all those transactions have committed
or rolled back, then you can free up the space with a vacuum full.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux