|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
Sql command to reclaim empty space in .data file in Postgres
A CHECKPOINT operation does not normally reclaim the empty spaces.
What is the sql command to reclaim the empty space in the .data file? Is there a way to actually truncate the log file? (When I surfed the internet, read that the only way to truncate the log file is to stop and start the server.) Thanks. |
|
#2
|
||||
|
||||
|
I'm not sure what you're looking for, but it sounds like VACUUM.
http://www.postgresql.org/docs/8.3/static/maintenance.html |
![]() |
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Sql command to reclaim empty space in .data file in Postgres |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|