Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] a JOIN to a VIEW seems slow - Mailing list pgsql-general

From Frank Millman
Subject Re: [GENERAL] a JOIN to a VIEW seems slow
Date
Msg-id 10F03730D0E54EC08F10553310F12B9C@FrankLaptop
Whole thread Raw
In response to [GENERAL] a JOIN to a VIEW seems slow  ("Frank Millman" <frank@chagford.com>)
List pgsql-general
Tree view

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
 

pgsql-general by date:

Previous
From: "Frank Millman"
Date:
Subject: Re: [GENERAL] a JOIN to a VIEW seems slow
Next
From: athinivas
Date:
Subject: [GENERAL] delete a file everytime pg server starts/crashes