If we had a composite index on three fields: we would be able to use it for queries on the first field, for queries on the first two fields and for queries involving all three fields, but not on any other field combination.Copied directly from How to stop worrying and love your Postgres indexes
Tuesday, June 9, 2015
[PostgreSQL] Using some indexes from Composite index
Subscribe to:
Post Comments (Atom)
-
sudo su postgres supply your Mac password modify /Library/PostgreSQL/9.x/data/pg_hba.conf from local all all md5 to local all all ...
-
Put your cursor on the text box of the post/comment you want to indent Go to the menubar at the top of the screen Edit > Emoji & ... -
I have to tell you that this is my method. I'm not sure is there any better workaround to handle this. I'm on Ubuntu Intrepid Ibex. ...
No comments:
Post a Comment