Postgres Pro
Downloads
Home   >   mailing lists

Re: HOT pgbench results - Mailing list pgsql-hackers

From Tom Lane
Subject Re: HOT pgbench results
Date
Msg-id 20852.1186496351@sss.pgh.pa.us
Whole thread Raw
In response to HOT pgbench results  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: HOT pgbench results  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: HOT pgbench results  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
List pgsql-hackers
Tree view 
Heikki Linnakangas <heikki@enterprisedb.com> writes:
>         unpatched    HOT    
> autovacuums    116        43
> autoanalyzes    139        60

> HOT greatly reduces the number of vacuums needed. That's good, that's
> where the gains in throughput in longer I/O bound runs comes from.

But surely failing to auto-analyze after a HOT update is a bad thing.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: HOT patch - version 13
Next
From: Gregory Stark
Date:
Subject: More logging for autovacuum