Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to know how indexing works in postgresql? Is it something like hash-map? Can indexing be a drawback in any situation?

share|improve this question
1  
Please consult with PostrgeSQL documentation. – dezso Jun 27 '12 at 9:50
1  
Feel free to update the question to make it more specific and flag it for moderator attention, and I'll reopen it. As currently written, it would take a rather lengthy book to answer the question. – JNK♦ Jun 27 '12 at 10:40
If you try to reformulate the question, please note that PostgreSQL has a somewhat "pluggable" indexing system, with many types of indexes already plugged in and more added all the time. Btree, GIN, GiST, and hash have been around for years, with KNN-GiST and NPGiST (both useful for spacial indexes) being recent additions. Your question needs to be narrower or (as @JNK said) it would take a book to really respond. – kgrittn Jun 29 '12 at 12:25

closed as not a real question by JNK♦ Jun 27 '12 at 10:39

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

Browse other questions tagged or ask your own question.