Re: [PERFORM] Planning hot/live backups?

2008-03-24 Thread Miguel Arroz
ing, but I've never done it (have been using SQL dumps), so... Yours Miguel Arroz On 2008/03/24, at 22:28, Matthew T. O'Connor wrote: Steve Poe wrote: At this point, I am just moving the pg_dumpall file to another server. Pardon my question: how would you 'ship the log

Re: [PERFORM] UPDATE 66k rows too slow

2008-03-10 Thread Miguel Arroz
s OK. Yours Miguel Arroz On 2008/03/10, at 23:56, Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 10 Mar 2008 23:46:10 +0000 Miguel Arroz <[EMAIL PROTECTED]> wrote: tty ad4 ad6 cpu tin tout KB/t tps MB/s KB/

Re: [PERFORM] UPDATE 66k rows too slow

2008-03-10 Thread Miguel Arroz
x27;s surely a lot of disk activity going on. With this figures, I could have written some hundred gigabytes during the query execution! Something is definitely not right here. Yours Miguel Arroz On 2008/03/10, at 23:22, Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA

Re: [PERFORM] UPDATE 66k rows too slow

2008-03-10 Thread Miguel Arroz
that? Like "the working mem is too low" or anything else. I know the problem is not the checkpoints, at least nothing appears on the log related to that. But it irritates me to be in front of a such complex system and not being able to know what's going on. Yours Miguel Arroz

[PERFORM] UPDATE 66k rows too slow

2008-03-09 Thread Miguel Arroz
. Of course I don't need to say I'm relatively new to this kind of problems. :) Yours Miguel Arroz Miguel Arroz http://www.terminalapp.net http://www.ipragma.com smime.p7s Description: S/MIME cryptographic signature