471,073 Members | 1,362 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

8.0.0beta3 vacuum analyze


I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?

My settings:

#vacuum_cost_delay = 0 # 0-1000 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 0-10000 credits

Ed
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
4 1883
On Mon, 2004-10-18 at 14:49, Ed L. wrote:
I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
No.
#vacuum_cost_delay = 0 # 0-1000 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 0-10000 credits


Vacuum cost delay affects the way that VACUUM behaves, not the frequency
with which it is executed.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2
In the last exciting episode, pg***@bluepolka.net ("Ed L.") wrote:
I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?

My settings:

#vacuum_cost_delay = 0 # 0-1000 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 0-10000 credits


None of this would cause vacuums to be initiated.

The above configuration settings allow making vacuums "relatively
lazy;" instead of them running full-bore, and killing cache/chewing
I/O, they can do a few blocks worth of work, and then sleep a bit.

They are all commented out, so they won't have _any_ effect.

Note that this "lazier vacuuming" can be run alongside ARC to get some
synergistic benefit:

- ARC prevents vacuums from trashing the shared memory cache;

- "lazy vacuum" / "vacuum delay" prevents vacuums from taking over
all I/O
--
let name="cbbrowne" and tld="linuxfinances.info" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/
Fatal Error: Found [MS-Windows] System -> Repartitioning Disk for
Linux...
-- <cb******@hex.net> Christopher Browne
Nov 23 '05 #3
On 10/18/2004 12:49 AM, Ed L. wrote:
I *think* I'm seeing "vacuum analyze" queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?


Are you running Slony by any chance?
Jan

--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #4
On Monday October 18 2004 2:39, Jan Wieck wrote:
On 10/18/2004 12:49 AM, Ed L. wrote:
I *think* I'm seeing "vacuum analyze" queries launched automatically on
an 8.0.0beta3 (unless I have a rogue autovac running that I haven't
spotted). Is this something new in 8.0 and to be expected?


Are you running Slony by any chance?


Not on the system in question. Problem has ceased.

Ed
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Holger Marzen | last post: by
2 posts views Thread by lnd | last post: by
6 posts views Thread by Alex | last post: by
5 posts views Thread by Gavin Scott | last post: by
reply views Thread by Jim Seymour | last post: by
reply views Thread by Rajesh Kumar Mallah | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.