PostgreSQL features

Поиск
Список
Период
Сортировка
Искать

PostgreSQL features

От:
"arnaud Betoule " <anubis2@caramail.com>
Дата:
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

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Thu, Dec 11, 2003 at 16:27:25 +0100,
  arnaud Betoule   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)
FAQ