On Thu, Dec 11, 2003 at 16:27:25 +0100, arnaud Betoule <[EMAIL PROTECTED]> wrote: > 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. > - 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. > - 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. > 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
