On 4/5/19 6:23 AM, Rob Northcott wrote:
> Ah, fair enough – I’ll get into the habit of doing that then. Thanks again.
>
> Rob
> *From:*Ron
> *Sent:* 05 April 2019 11:07
> *To:* pgsql-general@lists.postgresql.org
> *Subject:* Re: Query much slower on 9.6.5 than on 9.3.5
Ah, fair enough – I’ll get into the habit of doing that then. Thanks again.
Rob
From: Ron
Sent: 05 April 2019 11:07
To: pgsql-general@lists.postgresql.org
Subject: Re: Query much slower on 9.6.5 than on 9.3.5
Rob,
pg_dump/restore gets rid of all the dead space, and you should always run an
same effect as a vacuum?
Anyway, looks like I was panicking prematurely, but thanks for the help
anyway 😊
Rob
*From:*Ron
*Sent:* 05 April 2019 10:13
*To:* pgsql-general@lists.postgresql.org
*Subject:* Re: Query much slower on 9.6.5 than on 9.3.5
On 4/5/19 3:43 AM, Rob Northcott wrote:
I’ve
. Presumably the backup removes
any dead stuff, so backup/restore has the same effect as a vacuum?
Anyway, looks like I was panicking prematurely, but thanks for the help anyway 😊
Rob
From: Ron
Sent: 05 April 2019 10:13
To: pgsql-general@lists.postgresql.org
Subject: Re: Query much slower on 9.6.5
On 4/5/19 3:43 AM, Rob Northcott wrote:
I’ve had a couple of customers complaining of slow searches and doing some
testing last night it seems to be much slower on the live server than on
my test setup.
It’s quite a messy query built up by the search code, with lots of joins
and subqueries.
