Syslog does that, I believe. Have a look at the man page for syslog.conf.
On Wed, Jul 27, 2011 at 5:11 AM, shailesh singh shaileshj...@gmail.com wrote:
Hi,
I want to configure Logging of postgres in such a way that messages of
different severity should be logged in different log file. eg: all
I wrote:
Mark Kirkwood mark.kirkw...@catalyst.net.nz writes:
[ assorted examples showing that commit
7f3eba30c9d622d1981b1368f2d79ba0999cdff2 has got problems ]
...
So, not only are you correct that we should revert the changes to
eqjoinsel_inner, but what's happening in eqjoinsel_semi is
On Aug 30, 2011, at 12:23 PM, Stefan Keller wrote:
I'm looking for summaries (or best practices) on SSD usage with PostgreSQL.
My use case is mainly a read-only database.
Are there any around?
I'm not sure, but for read-only why not just put more memory in the server?
It'll be a lot cheaper
On 02/09/11 11:13, Tom Lane wrote:
I wrote:
Mark Kirkwoodmark.kirkw...@catalyst.net.nz writes:
[ assorted examples showing that commit
7f3eba30c9d622d1981b1368f2d79ba0999cdff2 has got problems ]
...
So, not only are you correct that we should revert the changes to
eqjoinsel_inner, but what's
You mean something like Unlogged Tables in PostgreSQL 9.1 (=
in-memory database) or simply a large ramdisk?
Yours, Stefan
2011/9/1 Jim Nasby j...@nasby.net:
On Aug 30, 2011, at 12:23 PM, Stefan Keller wrote:
I'm looking for summaries (or best practices) on SSD usage with PostgreSQL.
My use
On 02/09/11 11:18, Mark Kirkwood wrote:
On 02/09/11 11:13, Tom Lane wrote:
I wrote:
Mark Kirkwoodmark.kirkw...@catalyst.net.nz writes:
[ assorted examples showing that commit
7f3eba30c9d622d1981b1368f2d79ba0999cdff2 has got problems ]
...
So, not only are you correct that we should revert
On 2011-09-01 23:28, Jim Nasby wrote:
On Aug 30, 2011, at 12:23 PM, Stefan Keller wrote:
I'm looking for summaries (or best practices) on SSD usage with PostgreSQL.
My use case is mainly a read-only database.
Are there any around?
I'm not sure, but for read-only why not just put more memory in
On Tue, Aug 30, 2011 at 11:23 AM, Stefan Keller sfkel...@gmail.com wrote:
Hi,
I'm looking for summaries (or best practices) on SSD usage with PostgreSQL.
My use case is mainly a read-only database.
Are there any around?
How big is your DB?
What kind of reads are most common, random access or
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