wilmoore/readme.md Secret

Last active March 16, 2025 18:28

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wilmoore/ff8eae770a72d31edf389150c1a2efa8.js"></script>
Save wilmoore/ff8eae770a72d31edf389150c1a2efa8 to your computer and use it in GitHub Desktop.

Download ZIP

Software Engineering :: Database :: PostgreSQL :: HStore

Raw

Software Engineering :: Database :: PostgreSQL :: HStore

⪼ Made with 💜 by Polyglot.

..

`research`

Intro to HStore

HStore

Perhaps one of the best parts of hstore is that you can index on it. In particular Postgres gin and gist indexes allow you to index all keys and values within an hstore. A talk by Christophe Pettus of PgExperts actually highlights some performance details of hstore with indexes. To give away the big punchline in several cases hstore with gin/gist beats mongodb in performance.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment