SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 09:17 AM
| ||||
| ||||
 table as hashtable Hi, Can I use a Postgre table as hashtable\\? when I do select where column='test', I want this to be done by hashtable, not linear, not by b-tree. I do not need to sort, sum or else I just want to get the value as fast as possible. 10x to anyone answering me Cheers, Anton ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-09-2008, 09:17 AM
| ||||
| ||||
| Re: table as hashtable Anton Andreev wrote: > > Hi, > > Can I use a Postgre table as hashtable\\? It's PostgreSQL or Postgres, BTW > when I do select where column='test', I want this to be done by hashtable, > not linear, not by b-tree. I do not need to sort, sum or else I just want > to get the value as fast as possible. There are hash indexes. Read the docs about them though. http://www.postgresql.org/docs/8.1/s...xes-types.html -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
