On 2020-02-13 21:03:48 -0800, Adrian Klaver wrote:
> On 2/13/20 9:02 PM, Adrian Klaver wrote:
> > On 2/13/20 7:54 PM, Jason Swails wrote:
> > > The problem is that after my machine boots, I'm unable to connect to
> > > the server from anywhere except localhost. Running a simple
> > > "systemctl re
Hello,
1. I was told that M$ SQLServer provides huge performance deltas over
PostgreSQL when dealing with index-unaligned queries :
create index i on t (a,b, c);
select * from t where b=... and c=...;
Columnar storage has been tried by various companies, CitusData,
EnterpriseDB, 2ndQuadrant, F
On Sun, Feb 16, 2020 at 10:38:29PM +0100, maxzor wrote:
Hello,
1. I was told that M$ SQLServer provides huge performance deltas over
PostgreSQL when dealing with index-unaligned queries :
create index i on t (a,b, c);
select * from t where b=... and c=...;
Perhaps index-only scans might help
...
Thank you will look into it!
I'm not really sure what's the point / benefit here. Initially it seemed
you simply propose a syntax saying "do a join using the columns in the
FK constraint" but it's unclear to me how this implies any writing
speedup?
This is exactly what I mean. If you know
> 3. What is the status of making the internal parser of PostgreSQL less
coupled to the core, and easier to cherry-pick from outside?
imho:
One of the current solutions is: https://github.com/lfittl/libpg_query C
library
"C library for accessing the PostgreSQL parser outside of the server.
Th
