Re: Re: How to track number of connections and hosts to Postgres cluster - Mailing list pgsql-performance

From Venkat Balaji
Subject Re: Re: How to track number of connections and hosts to Postgres cluster
Date
Msg-id CAFrxt0jkFwN8VRONncj=90io9diwnF=_Z1R95y-XQSCJYM3uCg@mail.gmail.com
Whole thread Raw
In response to Re: Re: How to track number of connections and hosts to Postgres cluster  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Re: How to track number of connections and hosts to Postgres cluster
List pgsql-performance
Hi Scott,

Log generation rate -

500MB size of log file is generated within minimum 3 mins to maximum of 20 mins depending on the database behavior.

I did not understand the "fsync" stuff you mentioned. Please help me know how would fsync is related to log generation or logging host IPs in the log file ?

Thanks
Venkat

On Tue, Aug 30, 2011 at 12:09 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Mon, Aug 29, 2011 at 11:55 PM, Venkat Balaji <venkat.balaji@verse.in> wrote:
> If i notice high IO's and huge log generation, then i think Greg Spileburg
> has suggested a good idea of using tcpdump on a different server. I would
> use this utility and see how it works (never used it before). Greg
> Spileburg, please  help me with any sources of documents you have to use
> "tcpdump".

There's also a lot to be said for dumping to a dedicated local drive
with fsync turned off.  They're logs so you can chance losing them by
putting them on a cheap fast 7200 rpm SATA drive.  If your logs take
up more than a few megs a second then they are coming out really fast.
 Do you know what your log generation rate in bytes/second is?

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Summaries on SSD usage?
Next
From: Scott Marlowe
Date:
Subject: Re: Re: How to track number of connections and hosts to Postgres cluster