Gregory Smith (@postgresperf) 's Twitter Profile
Gregory Smith

@postgresperf

#PostgreSQL startup founder @crunchydata, author, lapsed #planetpostgresql blogger. Family advocate for #MyalgicEncephalomyelitis #POTS #PwME #MEcfs patients.

ID: 370215554

calendar_today08-09-2011 17:05:26

215 Tweet

458 Followers

95 Following

Gregory Smith (@postgresperf) 's Twitter Profile Photo
Gregory Smith
@postgresperf

a year ago

All true. The way the VACUUM truncation works confuses people sometimes. The database has to exclusive lock the very last page of the table to shrink the file. It does that over and over again, until it finds a page that's still live.