Re: [GENERAL] log slow queries and hints

Vasiliy G Tolstov wrote: > user=dbu_vase_1,db=db_vase_1 HINT: Use the escape string syntax for > backslashes, e.g., E'\\'. > > How can i disable this hints, or (i'm use drupal for this database) fix > queries? See the manual section on configuration, "escape_string_warning". -- Richard Huxto

[GENERAL] log slow queries and hints

Hello. I'm new with postgresql, some times ago i'm turn on log slow queries, but log file contains not only queries , nor Oct 28 13:03:44 selfip postgres[18072]: [5-1] user=dbu_vase_1,db=db_vase_1 WARNING: nonstandard use of \\ in a string literal at character 90 Oct 28 13:03:44 selfip postgres[18

Re: [GENERAL] Log Slow Queries

On Tue, Apr 04, 2006 at 12:25:09PM +1000, Chris wrote: > MaRCeLO PeReiRA wrote: > >Hi Guys, > > > >Is there a feature in PostgreSQL like > >"--log-slow-queries"(MySQL) ??? > > Unfortunately not. > > What you can do is edit your postgresql.conf file and set: > > log_min_duration_statement You ca

Re: [GENERAL] Log Slow Queries

MaRCeLO PeReiRA wrote: Hi Guys, Is there a feature in PostgreSQL like "--log-slow-queries"(MySQL) ??? Unfortunately not. What you can do is edit your postgresql.conf file and set: log_min_duration_statement See http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html#RUNT

[GENERAL] Log Slow Queries

Hi Guys, Is there a feature in PostgreSQL like "--log-slow-queries"(MySQL) ??? Regards, Marcelo P. ___ Abra sua conta no Yahoo! Mail: 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz. http://br.info.