Re: Windows slowness?

2020-06-10 Thread Mikkel Lauritsen
Hi David, Many thanks for your response - you wrote: On 2020-06-10 23:08, David Rowley wrote: On Thu, 11 Jun 2020 at 07:41, Mikkel Lauritsen wrote: I have a query that runs much slower in Postgres on Windows than on Linux Using explain analyze on the database running on Windows I get ->

Re: Windows slowness?

2020-06-10 Thread David Rowley
On Thu, 11 Jun 2020 at 07:41, Mikkel Lauritsen wrote: > I have a query that runs much slower in Postgres on Windows than on > Linux > Using explain analyze on the database running on Windows I get > > -> Index Scan using event_pkey on event t1 (cost=0.56..0.95 rows=1 > width=295) (actual time=0

Re: Windows slowness?

2020-06-10 Thread mountain the blue
mikkel, sorry for being so stupid: did you exclude antivirus/firewall related issue? Le mer. 10 juin 2020 à 21:41, Mikkel Lauritsen a écrit : > Hi all, > > I have a query that runs much slower in Postgres on Windows than on > Linux, and I'm so far unable to explain why - the execution plans are

Windows slowness?

2020-06-10 Thread Mikkel Lauritsen
Hi all, I have a query that runs much slower in Postgres on Windows than on Linux, and I'm so far unable to explain why - the execution plans are identical and the hardware is reasonably the same caliber. Using explain analyze on the database running on Windows I get -> Index Scan using eve