Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Cases
Courses
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info

Facebook
Postgres Pro
  • Services
    24×7×365 Technical Support Migration to PostgreSQL High Availability Deployment Database Audit Remote DBA for PostgreSQL
  • Products
    Postgres Pro Enterprise Postgres Pro Standard Postgres Pro Shardman Postgres Pro Enterprise Manager Postgres Pro ProGate Cloud Solutions Postgres Extensions
  • Cases
  • Courses
  • Resources
    Blog Documentation Webinars Videos Presentations
  • Community
    Events Books Demo Database Mailing List Archives
  • About
    Leadership team Partners Customers In the News Press Releases Press Info
Facebook
Request a Demo
39.16. Table Storage Parameters
Prev UpChapter 39. TablesHome Next

39.16. Table Storage Parameters #

  • You can specify the following storage parameters when creating or editing tables:

    • fillfactor (integer)

    • toast_tuple_target (integer)

    • parallel_workers (integer)

    • autovacuum_enabled (boolean)

    • toast.autovacuum_enabled (boolean)

    • vacuum_index_cleanup (enum)

    • toast.vacuum_index_cleanup (enum)

    • vacuum_truncate (boolean)

    • toast.vacuum_truncate (boolean)

    • autovacuum_vacuum_threshold (integer)

    • toast.autovacuum_vacuum_threshold (integer)

    • autovacuum_vacuum_scale_factor (floating point)

    • toast.autovacuum_vacuum_scale_factor (floating point)

    • autovacuum_analyze_threshold (integer)

    • autovacuum_analyze_scale_factor (floating point)

    • autovacuum_vacuum_cost_delay (floating point)

    • toast.autovacuum_vacuum_cost_delay (floating point)

    • autovacuum_vacuum_cost_limit (integer)

    • toast.autovacuum_vacuum_cost_limit (integer)

    • autovacuum_freeze_min_age (integer)

    • toast.autovacuum_freeze_min_age (integer)

    • autovacuum_freeze_max_age (integer)

    • toast.autovacuum_freeze_max_age (integer)

    • autovacuum_freeze_table_age (integer)

    • toast.autovacuum_freeze_table_age (integer)

    • autovacuum_multixact_freeze_min_age (integer)

    • toast.autovacuum_multixact_freeze_min_age (integer)

    • autovacuum_multixact_freeze_max_age (integer)

    • toast.autovacuum_multixact_freeze_max_age (integer)

    • autovacuum_multixact_freeze_table_age (integer)

    • toast.autovacuum_multixact_freeze_table_age (integer)

    • log_autovacuum_min_duration (integer)

    • toast.log_autovacuum_min_duration (integer)

    • user_catalog_table (boolean)


Prev Up Next
39.15. Deleting a Table Home Chapter 40. Indexes
epub pdf
Есть вопросы? Напишите нам!

Соглашаюсь с условиями обработки персональных данных



✖
×
Postgres Pro Enterprise Manager 2
Go to Postgres Pro Enterprise Manager 2
Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Cases
Courses
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Services
  • 24×7×365 Technical Support
  • Migration to Postgres
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Community
  • Events
  • Training Courses
  • Intro Book
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Cases
  • In the News
  • Press Releases
  • Press Info
Contacts
  • Neptune House, Marina Bay, office 207, Gibraltar, GX11 1AA
  • info@postgrespro.com
  • Facebook
Get in touch!



© Postgres Professional Europe Limited, 2015 — 2026
EULA EULA for Cloud Environments Privacy Policy GDPR Compliance Commitment
© Postgres Professional Europe Limited, 2015 — 2026
EULA
EULA for Cloud Environments
Privacy Policy
GDPR Compliance Commitment
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.