Professional Web Applications Themes

Partitioning Postgresql - PostgreSQL / PGSQL

Hello All, I know that with Oracle you can partition the tables into logical subsets and was wondering if this was also possible in postgres. Also is postgresql supported on linux cluusters? Thanks in advance, Phil ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match...

  1. #1

    Default Partitioning Postgresql

    Hello All,
    I know that with Oracle you can partition the tables into logical subsets and
    was wondering if this was also possible in postgres.

    Also is postgresql supported on linux cluusters?

    Thanks in advance,
    Phil




    ---------------------------(end of broadcast)---------------------------
    TIP 9: the planner will ignore your desire to choose an index scan if your
    joining column's datatypes do not match

    phil campaigne Guest

  2. #2

    Default Re: Partitioning Postgresql

    phil campaigne wrote:
    > Hello All,
    > I know that with Oracle you can partition the tables into logical
    > subsets and
    > was wondering if this was also possible in postgres.
    No (except by hand, with a view layered over the top).
    > Also is postgresql supported on linux cluusters?
    And no (at least not without specialised hardware).

    It might be that with more information, someone can give more lengthy
    advice though.

    --
    Richard Huxton
    Archonet Ltd

    ---------------------------(end of broadcast)---------------------------
    TIP 5: Have you checked our extensive FAQ?

    [url]http://www.postgresql.org/docs/faq[/url]

    Richard Huxton Guest

  3. #3

    Default Partitioning Postgresql

    >phil campaigne wrote:
    > Hello All,
    > I know that with Oracle you can partition the tables into logical
    > subsets and
    > was wondering if this was also possible in postgres.
    >No (except by hand, with a view layered over the top).
    > Also is postgresql supported on linux cluusters?
    >And no (at least not without specialised hardware).
    >It might be that with more information, someone can give more lengthy
    advice though.




    Does this also mean that you cannot physically split a database over
    multiple physical servers?
    Phil



    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to [email]majordomopostgresql.org[/email] so that your
    message can get through to the mailing list cleanly

    phil campaigne Guest

  4. #4

    Default Re: Partitioning Postgresql

    phil campaigne wrote:
    >
    > Does this also mean that you cannot physically split a database over
    > multiple physical servers?
    > Phil
    Physically, yes, logically no. Suppose, for example, you have two
    servers A and B, both running PostgreSQL with corresponding databases
    dbA and dbB. Depending on what you are trying to accomplish, you can
    put table 1 in dbA and table2 in dbB. The application users don't know
    and don't care where the tables reside. If you want to hide this from
    the programmers as well, you can hide that with a very thin access
    layer. Finally, if you need to join the two tables, you can even do
    that with the dblink add-on.

    Finally, if you are using Java, ObjectWeb has a RAIDb driver that can
    transparently distribute databases over a cluster of servers. See
    [url]http://c-jdbc.objectweb.org/[/url].

    --
    Guy Rouillier


    ---------------------------(end of broadcast)---------------------------
    TIP 9: the planner will ignore your desire to choose an index scan if your
    joining column's datatypes do not match

    Guy Rouillier Guest

Similar Threads

  1. space partitioning
    By DANGH_b in forum Macromedia Director 3D
    Replies: 2
    Last Post: March 7th, 09:58 PM
  2. Advantage of partitioning?
    By no body in forum Linux Setup, Configuration & Administration
    Replies: 48
    Last Post: July 29th, 09:57 PM
  3. Partitioning HDD
    By Spinner in forum Windows XP/2000/ME
    Replies: 0
    Last Post: June 30th, 04:45 AM
  4. partitioning tables
    By Albert Punsola in forum Oracle Server
    Replies: 2
    Last Post: December 29th, 08:00 PM
  5. debunking partitioning
    By Mikito Harakiri in forum Oracle Server
    Replies: 0
    Last Post: December 5th, 06:53 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139