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

> postgres sup****ts 32
> indexes per table, mysql 16

Do you have a source for that information?
I could not quickly find that information.

Or did you refer to the max amount of columns per one index?
Those kinds of amounts are mentioned on this page (that is why I would
double check this issue):
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
-> Multi-column Indexes

>
> It would probably be useful. But you need to test.

Yes it might be required.

I will check the Art of SQL.

>
> Also, did you tell which DBMS you're using?

Oracle might be one. Maybe MySQL would be good too, but I am not sure
what kinds of functionalities would be required in the end. Maybe I
will try to check some other DBMSs too.

> I still cannot fathom the application domain you're working in,

I will give only the information which I gave already. The new items
arrive, those will be kept in the DB for analysis (not for a very long
time) and then the old items will be deleted. Items are not kept in
the DB for a long time.

Thank you for the comments and the information!