| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
| Subject: | Re: temporary statistics option at initdb time |
| Date: | 2008-08-12 23:23:53 |
| Message-ID: | 629C4BE5-CBE9-4C0D-AAC2-6B56906FE298@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Aug 12, 2008, at 12:27 PM, Magnus Hagander wrote:
> I don't think it'd be that hard to handle the SIGHUP case - just have
> the stats collector start writing it in the new location the next time
> it writes it out, and backends will start reading from there.
> There's a
> short window where the backends would get no data, but I think that's
> quite acceptable..
I disagree. While we don't guarantee stats are absolutely up-to-date,
or atomic I don't think that gives license for them to just magically
not exist sometimes.
Would it really be that hard to have the system copy the file out
before telling all the other backends of the change?
BTW, it would be nice if it would actually remove the old file, but
that sounds like a lot more work...
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Raney | 2008-08-12 23:53:50 | Planner question |
| Previous Message | Webb Sprague | 2008-08-12 23:21:41 | Re: Plugin system like Firefox |