Re: [GENERAL] nonremovable row ?

2005-05-04 Thread Bruno Wolff III
On Wed, May 04, 2005 at 18:24:53 +0200, Hervé Piedvache <[EMAIL PROTECTED]> 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 com

[GENERAL] nonremovable row ?

2005-05-04 Thread Hervé Piedvache
Hi, I have a strange problem ... Look at what I have done ... # select count(*) from domains_ranks; count 26927405 (1 row) # DELETE from domains_ranks where date_rank < now() - '3 days'::interval; DELETE 26232918 # select count(*) from domains_ranks; count 694487 (1 row) #