Recently had a problem where autovacuum was accidentally left off
and the database took 6 seconds for every task from PHP.
I had no clue the database was the issue because I
had the minimal
log_duration = on
log_line_prefix = '<%t>'
With those settings all queries seen were roughly 1ms
I need th
line_prefix = '<%t>'
I know it does sound strange, but this is what we battled with for 2.5 days
until the light
came on that the vacuum had been set to off on the target system during
server migration.
On Wed, Aug 28, 2019 at 11:07 AM Adrian Klaver
wrote:
> On 8/28/19 5:36
On Wed, Aug 28, 2019 at 4:51 PM Tom Lane wrote:
> francis picabia writes:
> > The server was running Moodle. The slow load time was noticed when
> loading
> > a quiz containing
> > multiple images. All Apache log results showed a 6 seconds or a multiple
> > of