sunhk25
V2EX  ›  问与答

postgresql 有什么命令来设置限制一个 datafile 的大小

  •  
  •   sunhk25 · Jun 17, 2016 · 1314 views
    This topic created in 3648 days ago, the information mentioned may be changed or developed.

    结果查到 orcal 的有如下写法

    ALTER TABLESPACE users
        ADD DATAFILE '/u02/oracle/rbdb1/users03.dbf' SIZE 10M
          AUTOEXTEND ON
          NEXT 512K
          MAXSIZE 250M;
    
    ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf' 
        AUTOEXTEND OFF;
    

    不知道 postgresql 是否有类似的写法

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3007 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 06:54 · PVG 14:54 · LAX 23:54 · JFK 02:54
    ♥ Do have faith in what you're doing.