Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Bryce Nesbitt <bryce2(at)obviously(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Date: 2015-03-06 14:19:34
Message-ID: 20150306141934.GX3291@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bryce Nesbitt wrote:

> That all sounded really reasonable. So I checked into turning off vac
> for this particular laptop
> and discovered:
>
> /etc/postgresql/9.3/main/postgresql.conf
> #autovacuum = on
> #autovacuum_naptime = 1min
>
> (At Ubuntu's default).

You need to uncomment and set off.

> So autovacuum is *not the droid we're looking for...*

Use "SHOW autovacuum" in psql to avoid being confounded by
mind-controlling superpowers.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bryce Nesbitt 2015-03-06 17:57:56 Re: BUG #12834: Avoiding Disk Control Writes for better Laptop / SSD compatibility. pgstats
Previous Message suman.c 2015-03-06 08:01:53 BUG #12836: pljava.dll for postgres 9.4.1-64 bit