Re: a JOIN to a VIEW seems slow

From: "Frank Millman" <frank(at)chagford(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: a JOIN to a VIEW seems slow
Date: 2017-10-05 07:51:28
Message-ID: 10F03730D0E54EC08F10553310F12B9C@FrankLaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 5 Oct 2017, at 8:20 AM, Frank Millman wrote:

> If anyone wants to take this further, maybe this is a good place to start.

I should have re-stated the reason for my original post.

Exactly the same query, on exactly the same data, takes 1.8 seconds on Sql Server, 1.0 seconds on SQLite3, and 1607 seconds, or 26 minutes, on PostgreSQL 9.4.4.

Frank

Browse pgsql-general by date

  From Date Subject
Next Message athinivas 2017-10-05 14:04:27 delete a file everytime pg server starts/crashes
Previous Message Frank Millman 2017-10-05 06:20:42 Re: a JOIN to a VIEW seems slow