Thread: PostgreSQL features

PostgreSQL features

From
"arnaud Betoule "
Date:
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


Re: PostgreSQL features

From
Bruno Wolff III
Date:
On Thu, Dec 11, 2003 at 16:27:25 +0100,
  arnaud Betoule  <anubis2@caramail.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@postgresql.org)