Re: PostgreSQL features

On Thu, Dec 11, 2003 at 16:27:25 +0100,
arnaud Betoule <anubis2(at)caramail(dot)com> 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 majordomo(at)postgresql(dot)org)