Dropping column in Postgres on a large dataset

by

ALTER TABLE DROP COLUMN does just only disabling columns in system tables. It is very fast, but it doesn’t remove data from heap files. You have to do VACUUM FULL later to compact allocated file space. So ALTER TABLE DROP COLUMN is very fast. And to compact files, you have to call the slower (with exclusive LOCK) VACUUM FULL.

Related Contents:

  1. Primary key for multiple columns in PostgreSQL?
  2. PostgreSQL – set a default cell value according to another cell value
  3. Permission denied for relation
  4. Postgresql – unable to drop database because of some auto connections to DB
  5. PostgreSQL query to list all table names?
  6. Export and import table dump (.sql) using pgAdmin
  7. How to make a select with array contains value clause in psql
  8. Adding comment to column when I create table in PostgreSQL?
  9. Grant all on a specific schema in the db to a group role in PostgreSQL
  10. How to Disconnect from a database and go back to the default database in PostgreSQL?
  11. Now() without timezone
  12. Socket File “/var/pgsql_socket/.s.PGSQL.5432” Missing In Mountain Lion (OS X Server)
  13. Postgresql 9.2 pg_dump version mismatch
  14. Do I need to REINDEX and VACUUM a table after deleting lots of rows?
  15. Calculating and saving space in PostgreSQL
  16. Failed to find conversion function from unknown to text
  17. PostgreSQL 9.2 – Convert TEXT json string to type json/hstore
  18. Postgresql Truncation speed
  19. How to create a user for Postgres from the command line for bash automation
  20. postgresql migrating JSON to JSONB [duplicate]
  21. currval has not yet been defined this session, how to get multi-session sequences?
  22. How to append a new item into the array-type column in PostgreSQL
  23. How to change the template database collection coding
  24. CONSTRAINT to check values from a remotely related table (via join etc.)
  25. Postgres manually alter sequence
  26. Find the host name and port using PSQL commands
  27. psql: FATAL: Peer authentication failed for user “dev”
  28. How big is too big for a PostgreSQL table?
  29. Which datatype should be used for currency?
  30. How can I get a list of all functions stored in the database of a particular schema in PostgreSQL?
  31. PostgreSQL CASE … END with multiple conditions
  32. How to import existing *.sql files in PostgreSQL 8.4?
  33. How to see active connections and “current activity” in PostgreSQL 8.4
  34. How to restore PostgreSQL database from .tar file?
  35. PgAdmin: could not send data to server: Socket is not connected could not send SSL negotiation packet: Socket is not connected [closed]
  36. call multiple Sql files in a single SQL file in Postgres
  37. Postgres – could not create any TCP/IP sockets
  38. PostgreSQL alter type timestamp without time zone -> with time zone
  39. Postgres table column name restrictions?
  40. How can I test if a column exists in a table using an SQL statement
  41. PostgreSQL: How to DROP FUNCTION IF EXISTS without specifying parameters?
  42. alembic util command error can’t find identifier
  43. Postgres multiple joins
  44. Select today’s (since midnight) timestamps only
  45. How to dump a postgres db excluding one specific table?
  46. PostgreSQL: Show all the privileges for a concrete user
  47. The forgotten assignment operator “=” and the commonplace “:=”
  48. SELECT or INSERT a row in one command
  49. Sequences not affected by transactions?
  50. How to make my postgresql database use a case insensitive collation?

Leave a Comment