Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30

    Unanswered: Does postgres support extent sizing.... ?

    extent sizing and number of extents ?

    I am pretty sure it does not but I am not 'in the know' about it yet so I thought Id ask.

    thanks
    Last edited by MGZ; 11-13-02 at 11:30.

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    extend sizing

    never heard that before

    What does this mean exactly?
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    Create table blah (
    blah varchar(10)
    )
    INITIAL 100k
    NEXT 100k
    MINEXTENTS 10
    MAXEXTENTS 1000
    ;

    So that would create a table with an initial extent size of 100k, and then all others extents would also be 100k. The table would have a minimum size of 1mb and a max size of 10mb.

    Does postgres support anything like that?

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    \h CREATE TABLE

    action=# \h CREATE TABLE
    Command: CREATE TABLE
    Description: define a new table
    Syntax:
    CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
    { column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ...
    ] ]
    | table_constraint } [, ... ]
    )
    [ INHERITS ( parent_table [, ... ] ) ]
    [ WITH OIDS | WITHOUT OIDS ]

    where column_constraint is:

    [ CONSTRAINT constraint_name ]
    { NOT NULL | NULL | UNIQUE | PRIMARY KEY |
    CHECK (expression) |
    REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
    [ ON DELETE action ] [ ON UPDATE action ] }
    [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

    and table_constraint is:

    [ CONSTRAINT constraint_name ]
    { UNIQUE ( column_name [, ... ] ) |
    PRIMARY KEY ( column_name [, ... ] ) |
    CHECK ( expression ) |
    FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ...
    ] ) ]
    [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }
    [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]


    I don't see anything like that in the reference.
    As far as i know this is not implemented
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •