Re: JIT on Windows with Postgres 12.1

2021-01-30 Thread 109 ktke
On Wed, Feb 12, 2020 at 12:05:11PM -0800, Andres Freund wrote: > Yes, LLVM would work on windows. I'd not even be surprised if one could > make it work on windows already when using a mingw based build, instead > of msvc. In my mingw environment, postgresql build with option "--with-llvm" failed wi

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Michael Paquier
On Wed, Feb 12, 2020 at 07:32:08PM -0800, Andres Freund wrote: > That's not really the hard part. That's integrating the generation of > LLVM bitcode files into the buildsystem. As the absolute minimum > llvmjit_types.bc needs to be generated, but to be meaningfully supported > we'd need to generat

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Andres Freund
Hi, On 2020-02-13 12:25:40 +0900, Michael Paquier wrote: > On Wed, Feb 12, 2020 at 12:05:11PM -0800, Andres Freund wrote: > > Yes, LLVM would work on windows. I'd not even be surprised if one could > > make it work on windows already when using a mingw based build, instead > > of msvc. > > For MS

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Michael Paquier
On Wed, Feb 12, 2020 at 12:05:11PM -0800, Andres Freund wrote: > Yes, LLVM would work on windows. I'd not even be surprised if one could > make it work on windows already when using a mingw based build, instead > of msvc. For MSVC, assuming that you have the proper dependencies for JIT compilation

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Andres Freund
Hi, On 2020-02-12 14:54:56 -0500, Tom Lane wrote: > Andres Freund writes: > > On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote: > >> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled. > > > It's not currently supported by the windows buildsystem. I don't > > personally have the

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Justin
Here is a link to build LLVM on windows http://llvm.org/docs/GettingStartedVS.html On Wed, Feb 12, 2020 at 2:55 PM Tom Lane wrote: > Andres Freund writes: > > On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote: > >> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled. > > > It's

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Tom Lane
Andres Freund writes: > On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote: >> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled. > It's not currently supported by the windows buildsystem. I don't > personally have the expertise to change that (I've not worked on windows > after ~

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Andres Freund
Hi, On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote: > I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled. It's not currently supported by the windows buildsystem. I don't personally have the expertise to change that (I've not worked on windows after ~2003). So somebody would ha

Re: JIT on Windows with Postgres 12.1

2020-02-12 Thread Josef Šimánek
Hello. If I understand it well, JIT is enabled only for builds with "--with-llvm" flag. Seems EDB Windows PG 12.1 installer is not build with llvm (and jit) support. I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled. út 11. 2. 2020 v 22:41 odesílatel Catch All napsal: > I am u

JIT on Windows with Postgres 12.1

2020-02-11 Thread Catch All
I am using the EDB Windows PG 12.1 installer and it seems not to have JIT enabled: C:\Program Files\PostgreSQL\12\bin>pg_config --configure --enable-thread-safety --enable-nls --with-ldap --with-openssl --with-ossp-uuid --with-libxml --with-libxslt --with-icu --with-tcl --with-perl --with-python I