RE: Query very different speeds on seemingly similar data

2019-06-05 Thread Rob Northcott
>-Original Message- >From: David Rowley >Sent: 05 June 2019 01:48 >To: Rob Northcott >Cc: pgsql-general@lists.postgresql.org >Subject: Re: Query very different speeds on seemingly similar data >On Wed, 5 Jun 2019 at 04:55, Rob Northcott >wrote: >> Ex

Re: Query very different speeds on seemingly similar data

2019-06-04 Thread David Rowley
On Wed, 5 Jun 2019 at 04:55, Rob Northcott wrote: > Explain files attached (assuming attachments will get through to the group – > otherwise what’s the best way to post it?) You're best to post the EXPLAIN ANALYZE output to https://explain.depesz.com what you attached is pretty horrible to read