Re: Why so long between archive calls? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Why so long between archive calls?
Date
Msg-id 25848.1157153334@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why so long between archive calls?  ("Chris Hoover" <revoohc@gmail.com>)
Responses Re: Why so long between archive calls?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
"Chris Hoover" <revoohc@gmail.com> writes:
> I just ran this for several minutes and have about an 11MB trace file.  Is
> there anything particular you want to see?

> Also, is the data in the file deciferable or have actual database data in
> it?  The reason I ask, is that I work under HIPPA regulations, so I can't
> release anything if it has potential personal/patient data in it.

Yeah, you probably want to strip out the data portion of any read() or
write() calls shown in the trace.

BTW, I forgot to ask for timestamp information in the trace --- if you
didn't use -t please do it over.  It might be possible to get strace
to skip the read/write data by itself so you don't have to do it
manually, but I don't see anything obvious in its help output.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Re: Why so long between archive calls?
Next
From: Alvaro Herrera
Date:
Subject: Re: Why so long between archive calls?