pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to ENABLE SQL capturing???
11+ messages / 7 participants
[nested] [flat]
* How to ENABLE SQL capturing???
@ 2007-08-08 20:02 smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
0 siblings, 1 reply; 11+ messages in thread
From: smiley2211 @ 2007-08-08 20:02 UTC (permalink / raw)
To: pgsql-performance
Hello all,
I am trying to enable capturing of the submitted code via an
application...how do I do this in Postgres? Performance is SLOW on my
server and I have autovacuum enabled as well as rebuilt indexes...whatelse
should be looked at?
Thanks...Michelle
--
View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12060736
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
@ 2007-08-08 20:36 ` Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Steinar H. Gunderson @ 2007-08-08 20:36 UTC (permalink / raw)
To: smiley2211 <smiley2211@yahoo.com>; +Cc: pgsql-performance
On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
> I am trying to enable capturing of the submitted code via an
> application...how do I do this in Postgres? Performance is SLOW on my
> server and I have autovacuum enabled as well as rebuilt indexes...whatelse
> should be looked at?
Try "log_min_duration_statement = 100" in postgresql.conf; it will show all
statements that take more than 100ms. Set to 0 to log _all_ statements, or
-1 to turn the logging back off.
/* Steinar */
--
Homepage: http://www.sesse.net/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
@ 2007-08-08 20:57 ` Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
0 siblings, 1 reply; 11+ messages in thread
From: Bryan Murphy @ 2007-08-08 20:57 UTC (permalink / raw)
To: pgsql-performance
we currently have logging enabled for all queries over 100ms, and keep
the last 24 hours of logs before we rotate them. I've found this tool
very helpful in diagnosing new performance problems that crop up:
http://pgfouine.projects.postgresql.org/
Bryan
On 8/8/07, Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
> > I am trying to enable capturing of the submitted code via an
> > application...how do I do this in Postgres? Performance is SLOW on my
> > server and I have autovacuum enabled as well as rebuilt indexes...whatelse
> > should be looked at?
>
> Try "log_min_duration_statement = 100" in postgresql.conf; it will show all
> statements that take more than 100ms. Set to 0 to log _all_ statements, or
> -1 to turn the logging back off.
>
> /* Steinar */
> --
> Homepage: http://www.sesse.net/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
@ 2007-08-10 17:54 ` smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 11+ messages in thread
From: smiley2211 @ 2007-08-10 17:54 UTC (permalink / raw)
To: pgsql-performance
Hello all,
I have ENABLED this 'log_min_duration_statement = 100" but I can't figure
out WHERE it's writing the commands to ...I have it set to 'syslogs' but
this file is 0 bytes :confused:
Should I set other parameters in my postgresql.conf file???
Thanks...Michelle
Bryan Murphy-3 wrote:
>
> we currently have logging enabled for all queries over 100ms, and keep
> the last 24 hours of logs before we rotate them. I've found this tool
> very helpful in diagnosing new performance problems that crop up:
>
> http://pgfouine.projects.postgresql.org/
>
> Bryan
>
> On 8/8/07, Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
>> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
>> > I am trying to enable capturing of the submitted code via an
>> > application...how do I do this in Postgres? Performance is SLOW on my
>> > server and I have autovacuum enabled as well as rebuilt
>> indexes...whatelse
>> > should be looked at?
>>
>> Try "log_min_duration_statement = 100" in postgresql.conf; it will show
>> all
>> statements that take more than 100ms. Set to 0 to log _all_ statements,
>> or
>> -1 to turn the logging back off.
>>
>> /* Steinar */
>> --
>> Homepage: http://www.sesse.net/
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
--
View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12096180
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
@ 2007-08-10 20:10 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
0 siblings, 1 reply; 11+ messages in thread
From: Jeff Frost @ 2007-08-10 20:10 UTC (permalink / raw)
To: smiley2211 <smiley2211@yahoo.com>; +Cc: pgsql-performance
Michelle,
What platform are you on? If you're on linux, than logging to syslog will
likely show up in the /var/log/messages file.
On Fri, 10 Aug 2007, smiley2211 wrote:
>
> Hello all,
>
> I have ENABLED this 'log_min_duration_statement = 100" but I can't figure
> out WHERE it's writing the commands to ...I have it set to 'syslogs' but
> this file is 0 bytes :confused:
>
> Should I set other parameters in my postgresql.conf file???
>
> Thanks...Michelle
>
>
> Bryan Murphy-3 wrote:
>>
>> we currently have logging enabled for all queries over 100ms, and keep
>> the last 24 hours of logs before we rotate them. I've found this tool
>> very helpful in diagnosing new performance problems that crop up:
>>
>> http://pgfouine.projects.postgresql.org/
>>
>> Bryan
>>
>> On 8/8/07, Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
>>> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
>>>> I am trying to enable capturing of the submitted code via an
>>>> application...how do I do this in Postgres? Performance is SLOW on my
>>>> server and I have autovacuum enabled as well as rebuilt
>>> indexes...whatelse
>>>> should be looked at?
>>>
>>> Try "log_min_duration_statement = 100" in postgresql.conf; it will show
>>> all
>>> statements that take more than 100ms. Set to 0 to log _all_ statements,
>>> or
>>> -1 to turn the logging back off.
>>>
>>> /* Steinar */
>>> --
>>> Homepage: http://www.sesse.net/
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 6: explain analyze is your friend
>>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>>
>
>
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-08-10 21:43 ` smiley2211 <smiley2211@yahoo.com>
2007-08-10 21:50 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: smiley2211 @ 2007-08-10 21:43 UTC (permalink / raw)
To: pgsql-performance
Jeff,
You are CORRECT...my queries were going to /var/log/messages...had to get
the Linux Admin to grant me READ access to the file...
Thanks for your reply.
Michelle.
Jeff Frost wrote:
>
> Michelle,
>
> What platform are you on? If you're on linux, than logging to syslog will
> likely show up in the /var/log/messages file.
>
> On Fri, 10 Aug 2007, smiley2211 wrote:
>
>>
>> Hello all,
>>
>> I have ENABLED this 'log_min_duration_statement = 100" but I can't figure
>> out WHERE it's writing the commands to ...I have it set to 'syslogs' but
>> this file is 0 bytes :confused:
>>
>> Should I set other parameters in my postgresql.conf file???
>>
>> Thanks...Michelle
>>
>>
>> Bryan Murphy-3 wrote:
>>>
>>> we currently have logging enabled for all queries over 100ms, and keep
>>> the last 24 hours of logs before we rotate them. I've found this tool
>>> very helpful in diagnosing new performance problems that crop up:
>>>
>>> http://pgfouine.projects.postgresql.org/
>>>
>>> Bryan
>>>
>>> On 8/8/07, Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
>>>> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
>>>>> I am trying to enable capturing of the submitted code via an
>>>>> application...how do I do this in Postgres? Performance is SLOW on my
>>>>> server and I have autovacuum enabled as well as rebuilt
>>>> indexes...whatelse
>>>>> should be looked at?
>>>>
>>>> Try "log_min_duration_statement = 100" in postgresql.conf; it will show
>>>> all
>>>> statements that take more than 100ms. Set to 0 to log _all_ statements,
>>>> or
>>>> -1 to turn the logging back off.
>>>>
>>>> /* Steinar */
>>>> --
>>>> Homepage: http://www.sesse.net/
>>>>
>>>> ---------------------------(end of
>>>> broadcast)---------------------------
>>>> TIP 6: explain analyze is your friend
>>>>
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 3: Have you checked our extensive FAQ?
>>>
>>> http://www.postgresql.org/docs/faq
>>>
>>>
>>
>>
>
> --
> Jeff Frost, Owner <jeff@frostconsultingllc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
--
View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12099590
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
@ 2007-08-10 21:50 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-13 15:04 ` Re: How to ENABLE SQL capturing??? Jonathan Ellis <jonathan@utahpython.org>
0 siblings, 1 reply; 11+ messages in thread
From: Joshua D. Drake @ 2007-08-10 21:50 UTC (permalink / raw)
To: smiley2211 <smiley2211@yahoo.com>; +Cc: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
smiley2211 wrote:
> Jeff,
>
> You are CORRECT...my queries were going to /var/log/messages...had to get
> the Linux Admin to grant me READ access to the file...
You may want to actually get that to stop. Syslog is a notorious
performance bottleneck for postgresql.
>
> Thanks for your reply.
> Michelle.
>
>
> Jeff Frost wrote:
>> Michelle,
>>
>> What platform are you on? If you're on linux, than logging to syslog will
>> likely show up in the /var/log/messages file.
>>
>> On Fri, 10 Aug 2007, smiley2211 wrote:
>>
>>> Hello all,
>>>
>>> I have ENABLED this 'log_min_duration_statement = 100" but I can't figure
>>> out WHERE it's writing the commands to ...I have it set to 'syslogs' but
>>> this file is 0 bytes :confused:
>>>
>>> Should I set other parameters in my postgresql.conf file???
>>>
>>> Thanks...Michelle
>>>
>>>
>>> Bryan Murphy-3 wrote:
>>>> we currently have logging enabled for all queries over 100ms, and keep
>>>> the last 24 hours of logs before we rotate them. I've found this tool
>>>> very helpful in diagnosing new performance problems that crop up:
>>>>
>>>> http://pgfouine.projects.postgresql.org/
>>>>
>>>> Bryan
>>>>
>>>> On 8/8/07, Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
>>>>> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote:
>>>>>> I am trying to enable capturing of the submitted code via an
>>>>>> application...how do I do this in Postgres? Performance is SLOW on my
>>>>>> server and I have autovacuum enabled as well as rebuilt
>>>>> indexes...whatelse
>>>>>> should be looked at?
>>>>> Try "log_min_duration_statement = 100" in postgresql.conf; it will show
>>>>> all
>>>>> statements that take more than 100ms. Set to 0 to log _all_ statements,
>>>>> or
>>>>> -1 to turn the logging back off.
>>>>>
>>>>> /* Steinar */
>>>>> --
>>>>> Homepage: http://www.sesse.net/
>>>>>
>>>>> ---------------------------(end of
>>>>> broadcast)---------------------------
>>>>> TIP 6: explain analyze is your friend
>>>>>
>>>> ---------------------------(end of broadcast)---------------------------
>>>> TIP 3: Have you checked our extensive FAQ?
>>>>
>>>> http://www.postgresql.org/docs/faq
>>>>
>>>>
>>>
>> --
>> Jeff Frost, Owner <jeff@frostconsultingllc.com>
>> Frost Consulting, LLC http://www.frostconsultingllc.com/
>> Phone: 650-780-7908 FAX: 650-649-1954
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>>
>
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGvN2qATb/zqfZUUQRAmxSAJ96tbd3n12W79mxtad4dtD0F/7w6wCeI1uj
RpgRIKSMNrMHgm1wrCkqpjU=
=gJD2
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 21:50 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
@ 2007-08-13 15:04 ` Jonathan Ellis <jonathan@utahpython.org>
2007-08-13 15:42 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: Jonathan Ellis @ 2007-08-13 15:04 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: smiley2211 <smiley2211@yahoo.com>; pgsql-performance
On 8/10/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> smiley2211 wrote:
> > Jeff,
> >
> > You are CORRECT...my queries were going to /var/log/messages...had to get
> > the Linux Admin to grant me READ access to the file...
>
> You may want to actually get that to stop. Syslog is a notorious
> performance bottleneck for postgresql.
Can you elaborate? The only reference to this I could find was a
thread from 2004 where someone wasn't rotating his logs.
-Jonathan
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 21:50 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
2007-08-13 15:04 ` Re: How to ENABLE SQL capturing??? Jonathan Ellis <jonathan@utahpython.org>
@ 2007-08-13 15:42 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-13 16:02 ` Re: How to ENABLE SQL capturing??? Gregory Stark <stark@enterprisedb.com>
0 siblings, 1 reply; 11+ messages in thread
From: Joshua D. Drake @ 2007-08-13 15:42 UTC (permalink / raw)
To: Jonathan Ellis <jonathan@utahpython.org>; +Cc: smiley2211 <smiley2211@yahoo.com>; pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jonathan Ellis wrote:
> On 8/10/07, Joshua D. Drake <jd@commandprompt.com> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> smiley2211 wrote:
>>> Jeff,
>>>
>>> You are CORRECT...my queries were going to /var/log/messages...had to get
>>> the Linux Admin to grant me READ access to the file...
>> You may want to actually get that to stop. Syslog is a notorious
>> performance bottleneck for postgresql.
>
> Can you elaborate? The only reference to this I could find was a
> thread from 2004 where someone wasn't rotating his logs.
I am not sure what to elaborate on :). Syslog is slow, logging to file
isn't. Although both will certainly slow down your installation quite a
bit, syslog will slow it down more.
If I recall correctly, it is because syslog is blocking.
Joshua D. Drake
>
> -Jonathan
>
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGwHv6ATb/zqfZUUQRAgMlAKCcZpj+CCP50Deo/CsSCN21IyjrCACghXfN
uJQ+qsu4FI4Kjf8fpNiWgnw=
=BJ8E
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 21:50 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
2007-08-13 15:04 ` Re: How to ENABLE SQL capturing??? Jonathan Ellis <jonathan@utahpython.org>
2007-08-13 15:42 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
@ 2007-08-13 16:02 ` Gregory Stark <stark@enterprisedb.com>
2007-08-13 16:15 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: Gregory Stark @ 2007-08-13 16:02 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Jonathan Ellis <jonathan@utahpython.org>; smiley2211 <smiley2211@yahoo.com>; pgsql-performance
"Joshua D. Drake" <jd@commandprompt.com> writes:
> If I recall correctly, it is because syslog is blocking.
Are you sure it isn't just that syslog fsyncs its log files after every log
message? I don't think the individual syslogs are synchronous but if syslog
falls behind the buffer will fill and throttle the sender.
If your Postgres data is on the same device as the syslogs those fsyncs will
probably cause a big slowdown directly on Postgres's I/O as well.
You can turn off the fsyncs in syslog by putting a - before the filename.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: How to ENABLE SQL capturing???
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Re: How to ENABLE SQL capturing??? Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Re: How to ENABLE SQL capturing??? Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Re: How to ENABLE SQL capturing??? Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` Re: How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-10 21:50 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
2007-08-13 15:04 ` Re: How to ENABLE SQL capturing??? Jonathan Ellis <jonathan@utahpython.org>
2007-08-13 15:42 ` Re: How to ENABLE SQL capturing??? Joshua D. Drake <jd@commandprompt.com>
2007-08-13 16:02 ` Re: How to ENABLE SQL capturing??? Gregory Stark <stark@enterprisedb.com>
@ 2007-08-13 16:15 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 11+ messages in thread
From: Joshua D. Drake @ 2007-08-13 16:15 UTC (permalink / raw)
To: Gregory Stark <stark@enterprisedb.com>; +Cc: Jonathan Ellis <jonathan@utahpython.org>; smiley2211 <smiley2211@yahoo.com>; pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Gregory Stark wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>
>> If I recall correctly, it is because syslog is blocking.
>
> Are you sure it isn't just that syslog fsyncs its log files after every log
> message?
Nope I am not sure at all ;). Darcy actually found the issue and can
speak better to it, I never use syslog and have always logged direct to
file.
I don't think the individual syslogs are synchronous but if syslog
> falls behind the buffer will fill and throttle the sender.
>
> If your Postgres data is on the same device as the syslogs those fsyncs will
> probably cause a big slowdown directly on Postgres's I/O as well.
>
> You can turn off the fsyncs in syslog by putting a - before the filename.
>
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGwIOnATb/zqfZUUQRAqWqAKCEhoW/01Hc//cDEpREit8ipn2SZwCfUxPE
1Ir6eyuD4EcShwsn4sMAeKA=
=W2cJ
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2007-08-13 16:15 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-08 20:02 How to ENABLE SQL capturing??? smiley2211 <smiley2211@yahoo.com>
2007-08-08 20:36 ` Steinar H. Gunderson <sgunderson@bigfoot.com>
2007-08-08 20:57 ` Bryan Murphy <bryan.murphy@gmail.com>
2007-08-10 17:54 ` smiley2211 <smiley2211@yahoo.com>
2007-08-10 20:10 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-08-10 21:43 ` smiley2211 <smiley2211@yahoo.com>
2007-08-10 21:50 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-13 15:04 ` Jonathan Ellis <jonathan@utahpython.org>
2007-08-13 15:42 ` Joshua D. Drake <jd@commandprompt.com>
2007-08-13 16:02 ` Gregory Stark <stark@enterprisedb.com>
2007-08-13 16:15 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox