On Thu, Sep 21, 2017 at 1:51 AM, Frank Millman <frank@xxxxxxxxxxxx> wrote: > On 2017-09-18 Frank Millman wrote: >> >> Here are the timings for running the query on identical data sets using >> Postgresql, Sql Server, and Sqlite3 - >> >> PostgreSQL - >> Method 1 - 0.28 sec >> Method 2 – 1607 sec, or 26 minutes >> >> Sql Server - >> Method 1 – 0.33 sec >> Method 2 – 1.8 sec >> >> Sqlite3 - >> Method 1 – 0.15 sec >> Method 2 – 1.0 sec >> >> It seems that Sql Server and Sqlite3 are able to analyse the ‘join’, and >> execute an indexed read against the underlying physical tables. >> > > I did not get any response to this, but I am still persevering, and feel > that I am getting closer. Instead of waiting 26 minutes for a result, I > realise that I can learn a lot by using EXPLAIN. This is what I have found > out. Something is not adding up here. Can you EXPLAIN ANALYZE the 26 minute query? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
