>>> Jakov Sosic wrote:
> How do you mean, do fewer updates?
Well, without knowing the application it's hard for me to say; but, as
a guess, perhaps the application could be modified to accumulate, say,
a minute's worth of data and update it in summary, rather than
updating each sample once per
On Tue, Mar 3, 2009 at 5:51 PM, Jakov Sosic wrote:
> Scott Marlowe wrote:
>
>> That might not be much smaller if you're doing a lot of updates /
>> inserts / deletes. Also, SQL ain't the same as what was committed. If
>> you insert now() it won't be the same when you run it in two days.
>
> Well
Scott Marlowe wrote:
> That might not be much smaller if you're doing a lot of updates /
> inserts / deletes. Also, SQL ain't the same as what was committed. If
> you insert now() it won't be the same when you run it in two days.
Well I think I miscalculated a little bit... It's more like a 120
On Tue, Mar 3, 2009 at 4:49 PM, Jakov Sosic wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Kevin Grittner wrote:
>
>> What you are copying is all the information required to restore the
>> database to the state it was in after the commit of any one of these
>> transactions. Out of c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Grittner wrote:
> What you are copying is all the information required to restore the
> database to the state it was in after the commit of any one of these
> transactions. Out of curiosity, how much space would you have thought
> that would ta
>>> Jakov Sosic wrote:
> I have a problem with WAL files... I have a fairly busy server, with
> lots of transactions every second. Database is backend for Zabbix
> monitoring application, and it writes performance counters of 500+
> hosts every few seconds.
>
> I'm trying to implement "Continuou
Hi!
I have a problem with WAL files... I have a fairly busy server, with
lots of transactions every second. Database is backend for Zabbix
monitoring application, and it writes performance counters of 500+
hosts every few seconds. DB is approx 150GB.
I'm trying to implement "Continuous Archiving"
