Unix Technical Forum

Re: pgstat: delayed write of stats file

This is a discussion on Re: pgstat: delayed write of stats file within the Pgsql Patches forums, part of the PostgreSQL category; --> > > > Magnus Hagander wrote: > > >> Per some earlier discussion, here is an attempt at > ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Patches

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-18-2008, 12:33 AM
Magnus Hagander
 
Posts: n/a
Default Re: pgstat: delayed write of stats file

> > > Magnus Hagander wrote:
> > >> Per some earlier discussion, here is an attempt at

> implementing a
> > >> "delayed write" of the pgstats file, to decrease the

> write activity
> > >> on that file.

> >
> > This was not ready to be applied, was it? "An attempt"

> doesn't sound
> > to me like Magnus thought it was ready for prime time, and my
> > recollection of the thread is that there were objections.

>
> I don't remember any objection. Magnus, Tom, revert?


I don't recall any specific objections that weren't answered. There was
some (short) talk about having a "backoff" so it won't update the file
too often if the user requests it, but I don't think we ever concluded
if that was necessary or not. If it is, I think we can add that on top
of what's there now, and there's no need to revert.

If there were/are other objections that I missed, a revert might be
needed. Can't really comment since I missed them in that case ;-)

I think the use of "attempt" was more that I expected more comments, and
also somewhat in light of the concurrent discussions about getting rid
of the code to accept delayed destroy messages.

//Magnus

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-18-2008, 12:34 AM
Tom Lane
 
Posts: n/a
Default Re: pgstat: delayed write of stats file

"Magnus Hagander" <mha@sollentuna.net> writes:
>>> This was not ready to be applied, was it?


> I don't recall any specific objections that weren't answered.


How about the fact that it's already caused one buildfarm failure?

http://www.pgbuildfarm.org/cgi-bin/s...-30%2003:05:01

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:06 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com