Partial indexes
In PostgreSQL, I’m wondering about how partial indexes get integrated into the query optimizer. Let’s say I have a table, with 100M rows, and there are 99 indexes, which each cover 1M rows, but the last 1M rows haven’t had an index created yet. What happens? Can PostgreSQL even handle hundreds of indexes? I would think that it would complicate optimization of the query substantially.
Time to add that to the list of factors to look at. There’s an option which is to, in the lulls, rewrite the indexes, and “expand them” to potentially cover some amount of historical data.
Bah! Sometimes I wonder if RDBMS are even worth the effort?
This entry was posted at 5:11 pm on 27 January 2005 and is filed under PostgreSQL. You can follow any responses to this entry through the post-specific RSS 2.0 feed.
No comments found.
Responses are currently closed, but you can trackback from your own site.