Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Re: Hundreds of...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 16 Topic 3157 of 3269
 Post > Topic >>

Re: Hundreds of columns, index on all of those.

by Thomas Kellerer <YQDHXVLMUBXG@[EMAIL PROTECTED] > May 6, 2008 at 03:15 PM

Marco Mariani, 06.05.2008 10:05:
> I don't have the docs at hand for other DBs, but postgres sup****ts 32 
> indexes per table, 

According to 

http://www.postgresql.org/docs/faqs.FAQ.html#item4.4


the number of indexes on a table is "unlimited"

But the number of columns is limited: depending on the data type this
varies from 250 to 1600

Thomas




 16 Posts in Topic:
Hundreds of columns, index on all of those.
 rock_sand81@[EMAIL PROTEC  2008-05-06 00:05:09 
Re: Hundreds of columns, index on all of those.
 Jeff North <jnorth@[EM  2008-05-06 07:54:21 
Re: Hundreds of columns, index on all of those.
 Marco Mariani <marco@[  2008-05-06 10:05:27 
Re: Hundreds of columns, index on all of those.
 Thomas Kellerer <YQDHX  2008-05-06 15:15:31 
Re: Hundreds of columns, index on all of those.
 Marco Mariani <marco@[  2008-05-06 10:09:02 
Re: Hundreds of columns, index on all of those.
 rock_sand81@[EMAIL PROTEC  2008-05-06 03:25:50 
Re: Hundreds of columns, index on all of those.
 Marco Mariani <marco@[  2008-05-06 13:08:06 
Re: Hundreds of columns, index on all of those.
 rock_sand81@[EMAIL PROTEC  2008-05-06 04:41:23 
Re: Hundreds of columns, index on all of those.
 Marco Mariani <marco@[  2008-05-06 15:06:57 
Re: Hundreds of columns, index on all of those.
 Ed Prochak <edprochak@  2008-05-06 05:45:54 
Re: Hundreds of columns, index on all of those.
 --CELKO-- <jcelko212@[  2008-05-07 09:51:29 
Re: Hundreds of columns, index on all of those.
 "David Cressey"  2008-05-07 19:26:47 
Re: Hundreds of columns, index on all of those.
 rock_sand81@[EMAIL PROTEC  2008-05-07 22:23:56 
Re: Hundreds of columns, index on all of those.
 rock_sand81@[EMAIL PROTEC  2008-05-07 23:34:52 
Re: Hundreds of columns, index on all of those.
 Ed Prochak <edprochak@  2008-05-08 05:29:54 
Re: Hundreds of columns, index on all of those.
 rock_sand81@[EMAIL PROTEC  2008-05-09 04:04:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Sat Oct 11 1:24:15 CDT 2008.