PostgreSQL features

[arnaud Betoule]

Hy,
I'm a newbie and i'm looking for several informations of PostgreSQL to help me for the choice of my next
database.
- What's the number max of keys ?
- Is thre a max lenght for the name of database, table, index, column ?
- Is it possible to make partions of a table ?and how ?
Thank's

E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Bruno Wolff III]

On Thu, Dec 11, 2003 at 16:27:25 +0100,

Post by arnaud Betoule
Hy,
I'm a newbie and i'm looking for several informations of PostgreSQL to help me for the choice of my next
database.
- What's the number max of keys ?

By default the limit is 32 keys on a single multicolumn index. You can
recompile the code with a larger limit if you want. I don't think there
is a limit on the number of indexes on a single table.

Post by arnaud Betoule
- Is thre a max lenght for the name of database, table, index, column ?

The default maximum is 63 characters. By recompiling you can use a larger
value. Howeber I think you need to make sure all of the tools that anyone
uses must also be built this way, so it isn't a change to make lightly.

Post by arnaud Betoule
- Is it possible to make partions of a table ?and how ?

No. However you can use partial indexes to solve some of the problems
you might try to solve by partitioning tables.

Post by arnaud Betoule
Thank's
E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org