News for hackers. Stuff that matters.

A comment on PostgreSQL Indexes: First principles. Parent comment

Re:PostgreSQL Indexes: First principles by dragonwriter on Friday February 26, 2016 @04:45PM (#11184509)
> There may be people that don't care how their query is actually executed, but I doubt it's the common case.

I'm 100% sure its common.

> Or been surprised to find out that production doesn't have that index but staging does.

That's the same problem as having different application code on staging then what gets deployed to production; this isn't a problem with queries working independent of indexes its a problem of broken release processes, which requiring more ceremony to make queries work will not fix.

[ Parent | on HN ]
Re:PostgreSQL Indexes: First principles by krylon on Saturday February 27, 2016 @03:21AM (#11186519)
> > There may be people that don't care how their query is actually executed, but I doubt it's the common case.

> I'm 100% sure its common.

The nice thing about the current state of affairs is that you can first build your queries / views until you get the results you need, then look what indices you can add to improve the performance of those queries. And if you get the results you need and find that performance is acceptable, you can just omit (or at least delay) the final step.

[ Parent | on HN ]