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

Re: Number of rows

From: "Jana Vasseru" <jana(dot)vasseru(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Number of rows
Date: 2009-08-25 21:49:17
Message-ID: op.uy8mwfde7w3on8@truhlik (view raw or flat)
Thread:
Lists: pgsql-novice
thanks for reply, but that's not it, i am running the deletes thru a  
simple PHP script without transactions.
and i checked that the deleted rows are non-existent over pgadmin

> 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

pgsql-novice by date

Next:From: Jignesh ShahDate: 2009-08-26 05:06:17
Subject: Re: Install new perl test function in PostgreSQL
Previous:From: Tom LaneDate: 2009-08-25 20:59:56
Subject: Re: Number of rows

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