>-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
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
I've got a weird problem that I can't work out...
A customer was complaining that their system was running slowly. They've only
been using it for a few days, so we tested it on our copy of their data and
it's running at normal speed.
Uploaded our backup to the live server and it's still quick.
R
