Re: Number of rows

Поиск
Список
Период
Сортировка
От Jana Vasseru
Тема Re: Number of rows
Дата
Msg-id op.uy8mwfde7w3on8@truhlik
обсуждение исходный текст
Ответ на Re: Number of rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Number of rows
Следующее
От: Jignesh Shah
Дата:
Сообщение: Re: Install new perl test function in PostgreSQL