Search Postgresql Archives

Re: B+ versus hash maps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jun 15, 2006, at 8:07 AM, surabhi.ahuja wrote:

is there any way of specifying wht type of index i want, say hash maps instead of the B+ trees. someone told me that in the case where duplicates occur(on the indexed field), hash map are better than B+ trees.

http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html

and also please tell if i can assume that it will use index only and not go for sequential scan, again i was told for that i ll have to set the random page cost parameter to 1.

The database will use whatever it thinks is optimal. Use explain analyze to see what it's doing.

Unless your database fits (and stays) entirely in memory, you'll probably be pretty unhappy with random_page_cost=1.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@xxxxxxxxxxxxx
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux