-Original Message-
From: Laurenz Albe
Sent: 07 January 2021 02:06
To: Rob Northcott ; pgsql-gene...@postgresql.org
Subject: Re: Keep needing to run manual analyze
On Wed, 2021-01-06 at 17:28 +, Rob Northcott wrote:
>> We have an application that uses a Postgres database (cur
From: Michael Lewis
Sent: 06 January 2021 18:11
To: Rob Northcott
Cc: pgsql-gene...@postgresql.org
Subject: Re: Keep needing to run manual analyze
On Wed, Jan 6, 2021 at 10:29 AM Rob Northcott
mailto:rob.northc...@compilator.com>> wrote:
We have an application that uses a Postgres da
x27;ve had a search around but there seem to be lots of differing opinions on
what needs to be done manually and what should be handled by the autovacuum.
Any hints most welcome...
Med vänlig hälsning / Best Regards
Rob Northcott
Software Developer (UK Office, formerly TEAM Systems)
Phone
From: Alex Magnum
Sent: 16 April 2020 09:36
To: Postgres General
Subject: Recursive Queries
Hi,
I have a simple table with singup timestamps
What I would like to do is to create a table as shown below that displays the
counts per our for the past n dates.
I can do this with a function but is
>-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
o the group -
otherwise what's the best way to post it?)
I'm completely stumped - any suggestions most welcome!
Med vänlig hälsning / Best Regards
Rob Northcott
Software Developer (UK Office, formerly TEAM Systems)
Phone +44 1752 712052
Compilator AB
Södergatan 22
SE-211 3
ANALYZE after pg_restore, since pg_restore doesn't populate the statistics
tables.
On 4/5/19 4:35 AM, Rob Northcott wrote:
Hi Ron,
Thanks for that. I did just run analyse and vacuum on the live database before
I saw your message and it has sorted it out.
Do you think the analyse on its own
than on 9.3.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
it help if I post the analyse output on here? (can we post
attachments to the group or should it just be text in the email?)
Many thanks for any hints
Med vänlig hälsning / Best Regards
Rob Northcott
Software Developer (UK Office, formerly TEAM Systems)
Phone +44 1752 712052
Compilator AB
Söderg
