Re: Number of rows - Mailing list pgsql-novice

From Tom Lane
Subject Re: Number of rows
Date
Msg-id 2595.1251233996@sss.pgh.pa.us
Whole thread Raw
In response to Number of rows  (Jana <jana.vasseru@gmail.com>)
Responses Re: Number of rows  ("Jana Vasseru" <jana.vasseru@gmail.com>)
List pgsql-novice
Jana <jana.vasseru@gmail.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

pgsql-novice by date:

Previous
From: Jana
Date:
Subject: Number of rows
Next
From: "Jana Vasseru"
Date:
Subject: Re: Number of rows