I was reading this post the other day:
http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/
I suspected some of the claims in the post may not have been accurate. This
one in particular:
"Without lateral joins, we would need to resort to PL/pgSQL to do this
analysis. Or, if
On Wed, Dec 3, 2014 at 01:15:50AM -0800, Guyren Howe wrote:
> GIN is certainly not the “three times” size suggested in the docs, but perhaps
> that just hasn’t been updated for the 9.4 improvements. Certainly, there isn’t
> sufficient difference here to make the BTree advantage compelling in most
On Mon, Nov 10, 2014 at 05:09:10PM -0800, Adrian Klaver wrote:
> >Would there be any issues then just leaving the columns as "timestamp
> >without time zone"? I know that's not ideal, but that would be a big
> >project to try and convert every single one of those columns.
>
> The plus for converti
