Skip site navigation (1) Skip section navigation (2)

Re: Number of rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jana <jana(dot)vasseru(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Number of rows
Date: 2009-08-25 20:59:56
Message-ID: 2595.1251233996@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Jana <jana(dot)vasseru(at)gmail(dot)com> writes:
> I have a table which shows estimated number of rows 243 655 000 it has 2  
> 030 460 pages. Now i'm trying to delete some of the rows, the trouble is  
> that the number of rows is not getting any lower. The deletes are  
> successfull and subsequent select shows that the a row was indeed deleted.  

Perhaps you forgot to commit the deletion?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Jana VasseruDate: 2009-08-25 21:49:17
Subject: Re: Number of rows
Previous:From: JanaDate: 2009-08-25 19:04:11
Subject: Number of rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group