Re: [GENERAL] Vacuum
От | K.T. |
---|---|
Тема | Re: [GENERAL] Vacuum |
Дата | |
Msg-id | 004a01be7442$401f28c0$43d8a5ce@p2-400-death обсуждение исходный текст |
Список | pgsql-general |
I had same problem...tables that have heavy deletes/inserts start to eat up tons of disk space and the vacuum seemed to hang. I posted too, but got no replies...so my solution was to dump the table and delete the database and recreate it all. Also I run the vaccum more often to avoid the prob in the future... -----Original Message----- From: Tim Stoddard <tims@dcs.state.ar.us> To: pgsql-general@postgresql.org.pgsql-sql@postgreSQL.org <pgsql-general@postgresql.org.pgsql-sql@postgreSQL.org> Date: Thursday, March 18, 1999 2:34 PM Subject: [GENERAL] Vacuum >When I delete 2k-3k of records from a table the vacuum process seems >to take forever. I have let the vacuum run for 24 hours before with >not luck. > >Can someone one explain to me what is going on? > >-- >Tim Stoddard >====================================================================== > > Open Systems UNIX > > In a world without fences, who needs Gates? -- Unknown >====================================================================== > > > >
В списке pgsql-general по дате отправления: