Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

2019-02-16 Thread Tom Lane
Thomas Munro writes: >>> Really? The specification says that it starts I/O, not that it waits >>> around for any to finish. > Right, there was some discussion of that, and I didn't (and still > don't) think it'd be wise to rely on undocumented knowledge about > which flags can eat errors based o

Re: Problems pushing down WHERE-clause to underlying view

2019-02-16 Thread Nicklas Avén
On 16 February 2019 06:02:50 GMT+01:00, Tom Lane wrote: >=?UTF-8?Q?Nicklas_Av=c3=a9n?= writes: >> I also, in the first query, changed the where clause to filter on >> machine_key in table contractor _access. Just to illustrate the >problem >> better. > >> Both queries filter on the same table

Re: How to setup only one connection for the whole event loop?

2019-02-16 Thread Francisco Olarte
Dominic: On Fri, Feb 15, 2019 at 3:35 PM Dominic Gua�a wrote: > I am new to postgresql and I am creating a c program that can receive request > from different users. I want to maximize the performance of postgresql so I > intend to just create 1 connection that would service all queries of > d

Using NOTIFY from a java application.

2019-02-16 Thread Philippe Ebersohl
Hello, we plan to use the NOTIFY feature in our java application. We have yet not seen many bugs about this feature on pgsql-bugs. Is this feature widely used ? Are there known limitations that we should be aware of ? Are there benefits to use PG 11 over PG10 regarding NOTIFY ? Are there a

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

2019-02-16 Thread Hans Schou
On Fri, Feb 15, 2019 at 1:34 AM Bruce Klein wrote: > > If you are running Postgres inside Microsoft WSL > https://docs.microsoft.com/en-us/windows/wsl/faq Who is WSL for? This is primarily a tool for developers ... --- One problem with WSL is that the I/O performance is not