Re: Problem to manage OID on the space disk
От
Manfred Koizar
Тема
Re: Problem to manage OID on the space disk
Дата
Msg-id
00f39vce04emaunkt1dt8guqsskvl28ghf@4ax.com
Ответ на
Problem to manage OID on the space disk (abremond@voila.fr)
Список
Дерево обсуждения
Problem to manage OID on the space disk "abremond@voila.fr" <abremond@voila.fr>
Re: Problem to manage OID on the space disk Manfred Koizar <mkoi-pg@aon.at>
On Fri, 4 Apr 2003 09:23:12 +0200, "abremond@voila.fr" wrote: >When I delete many rows (with OID) the free space of disk doesn't changed ! That's to be expected. >I make a vacuumdb, but I doesn't notice an increase of the free space disk. VACUUM (vacuumdb) does not free disk space, use VACUUM FULL (vacuumdb --full) instead. >In a last step, I make a backup and a restoration but, it's the same. Strange! I'm sure I'm missing something ... >How can I remove the OID on my disk without corrupt my databases ? Annie, I don't quite understand whether you want to remove rows or the oid column. Can you give an example of what you tried? Servus Manfred
В списке pgsql-general по дате отправления