<a href="https://www.postgresql.org/docs/9.6/static/rangetypes.html" rel="nofollow">https://www.postgresql.org/docs/9.6/static/rangetypes.html</a><p><a href="https://www.postgresql.org/docs/9.6/static/functions-range.html" rel="nofollow">https://www.postgresql.org/docs/9.6/static/functions-range.h...</a><p>Holy shit. Why hasn't anyone talked about it sooner? I've seen literally dozens of tables with<p><pre><code> begin TIMESTAMP,
end TIMESTAMP,
</code></pre>
and with handmade validation against intersection. And there is even a union operation! Seriously, my mind is blown.<p>Rails even supports it!<p><a href="http://edgeguides.rubyonrails.org/active_record_postgresql.html#range-types" rel="nofollow">http://edgeguides.rubyonrails.org/active_record_postgresql.h...</a>
Far too brief.<p>I would appreciate a really long text that would in a convincing manner explain why Postgres Is so awesome.<p>I work in the industry, and all I see are Oracle and Sybase everywhere. The experts are zealots also, not even having heard of Postgres. Not willing to believe a word I'm saying about Postgres.<p>I am already convinced of course, but the industry is not. Not finance, not trading, not telecom.
great read, but may I also suggest Array?<p>being able to have a field like:<p><pre><code> ingredients VARCHAR[]
</code></pre>
and index like:<p><pre><code> USING GIN (ingredients)
</code></pre>
and using an operator like @><p><pre><code> SELECT * FROM table WHERE ingredients @> ARRAY['mushrooms', 'sour cream']
</code></pre>
gives you such amazing flexibility and speed, it's not even funny.<p>also, while I was sad to not see PLV8 up there with PostGIS (an amazing extension, btw), I was still happy to see it mentioned with such gusto.
Postgres seems to have become the go-to relational database ever since MySQL fell in the hands of Oracle. Can anyone speak to how its json tree compares to MongoDB's document store in practice?
I rented some time on a vultr server recently and chose a prepackaged build which included a MySql install. Coming from a MS SQL background it felt positively medieval. I haven't migrated yet but from my research Postgres seems the closest competitor in the relational db space.<p>I considered MS SQL for Linux but the server alone required 3GB RAM...
HyperLogLog sounds interesting, but looking at the Github page of that extension it mentions that it has been tested with the versions 9.0, 9.1, 9.2, 9.3 and the last commit is 2014. Is it just finished and doesn't need any updates to keep up with newer Postgres versions? Or is it more of an abandonded project?
Is there a new way around the requirement to rebuild your entire replication topology after upgrading versions? (say 9.4 to 9.5) You get a new master ID when running the initdb step, and doing this throws everything else in the topology off. TIA
From reading the documentation [0] I can't help but feel a bit underwhelmed by the feature set of a GIST index. Maybe I'm not looking in the right place, but what index provide near mathes (fuzzy, prefix) as well as exact term matches?
Has anyone done a serious implementation on top of full-text search functionality in Postgres? I have a pretty large dataset that's currently in Postgres and I'm deciding between it and Elasticsearch.
Interestingly, I just yesterday published a post about pglogical. <a href="http://thedumbtechguy.blogspot.com/2017/04/demystifying-pglogical-tutorial.html" rel="nofollow">http://thedumbtechguy.blogspot.com/2017/04/demystifying-pglo...</a><p>Postgres is an amazing piece of software.
Even with the inclusion of JSONB, I think Postgres is still lagging behind MongoDB by enforcing schema. After so many years doing web apps, I am seeing very little interest to have to enforce 2 times the schema: one time in the DB via migtations and one time in the app itself via ORMs. Maybe I am missing something really obvious.<p>ps: I don't mind the downvoting. I am truly looking for answers.