Uncategorized

postgresql: incorrect table sizes

do a

VACUUM FULL

 

if you want to run this on python you need to set autocommit = True otherwise it will not work.

 

 


conn.set_session(readonly=True, autocommit=True)

sql = """
VACUUM FULL
"""

cur.execute(sql)
conn.commit()

conn.set_session(readonly=True, autocommit=False)

Leave a Reply

Your email address will not be published. Required fields are marked *