{"id":65624,"date":"2025-03-20T14:19:25","date_gmt":"2025-03-20T14:19:25","guid":{"rendered":"https:\/\/www.cloudthat.com\/resources\/?post_type=blog&#038;p=65624"},"modified":"2025-03-20T14:19:25","modified_gmt":"2025-03-20T14:19:25","slug":"optimizing-postgresql-queries-with-the-right-index-type","status":"publish","type":"blog","link":"https:\/\/www.cloudthat.com\/resources\/blog\/optimizing-postgresql-queries-with-the-right-index-type","title":{"rendered":"Optimizing PostgreSQL Queries with the Right Index Type"},"content":{"rendered":"","protected":false},"author":628,"featured_media":65626,"parent":0,"comment_status":"open","ping_status":"closed","template":"","blog_category":[3607,3640],"user_email":"yaswanth@cloudthat.com","published_by":"325","primary-authors":"","secondary-authors":"","acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/65624"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/users\/628"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/comments?post=65624"}],"version-history":[{"count":2,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/65624\/revisions"}],"predecessor-version":[{"id":65695,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/65624\/revisions\/65695"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media\/65626"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media?parent=65624"}],"wp:term":[{"taxonomy":"blog_category","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog_category?post=65624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}