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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jignesh Shah | 2009-08-26 05:06:17 | Re: Install new perl test function in PostgreSQL |
Previous Message | Tom Lane | 2009-08-25 20:59:56 | Re: Number of rows |