Hi,
suppose there is a DataBase named "mydb" and a table of it "log" ,
when i list dir "/var/lib/pgsql/base/mydb/", the size of "log" is
"45678901" . then i run this query "DELETE from log where ..... ;" and get
message "1000 rows deleted successfully".
then i see the size of log WITHOUT any changes "45678901" !!!
i think that postgresql DELETE command don't delete rows permanently.
so let me know how to DELETE some things from a TABLE permanently. and
increase my DAtaBase's size.
thanks alot.
M.Roomi
roomi@safineh.net