Re: Potential autovacuum optimization: new tables

From: Joshua Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Potential autovacuum optimization: new tables
Date: 2012-10-13 20:26:47
Message-ID: 238109055.55809.1350160007233.JavaMail.root@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Ah. Okay, maybe we can agree that that wasn't a good idea.

Oh, I'd say there's no question it was a mistake. We just didn't have the data at the time to realize it.

> I don't really see that we need to bend over backwards to exactly
> match
> some data points that you made up out of thin air. How about
> ceil(sqrt(N)) to start with?

We can start with anything, including Jeff Jane's equation (for my part, I think sqrt(N) will result in analyzing very large tables a bit too often) The tough part will be coming up with some way to test it.

--Josh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-10-13 20:28:21 Re: Optimizer regression
Previous Message Joshua Berkus 2012-10-13 20:15:16 Re: Deprecating RULES