HELP: Indexes

[zeny]

Hi everybody!

I have two questions concerning postgresql indexes:

1- Does PostgreSQL support bitmap indexes?
2- How does one create GIN indexes? (If you could give me an example, that would be great)

Best Regards

[rski]

Hi everybody!

I have two questions concerning postgresql indexes:

1- Does PostgreSQL support bitmap indexes?
2- How does one create GIN indexes? (If you could give me an example, that would be great)

Best Regards

See at postgresql.org, sample links

http://www.postgresql.org/docs/current/interactive/textsearch-indexes.html

http://www.postgresql.org/docs/current/static/sql-createindex.html

http://www.postgresql.org/docs/current/static/xindex.html