Re: [GENERAL] Prefix search, word completion, full text search

On Sat, 29 Dec 2007, Vincent Bernat wrote: Hi ! I am playing with the new full text search in PostgreSQL 8.3. I would like to search for prefixes to allow to complete words. For example, if I have the lexemes 'foo', 'foobar' and 'bar', I would like to get all the words whose prefix is 'f

Re: [GENERAL] Red Hat 9

Thanks to all those who chimed in to help. My Linux box is a personal pc and I have been thinking about upgrading. At that point I will also upgrade to PostgreSQL v8.2.5. Happy New Year to all! Tony > Is it advisable or ok to install v8.2.5 to a Red Hat 9 configuration? I > tried it and there

[GENERAL] Prefix search, word completion, full text search

Hi ! I am playing with the new full text search in PostgreSQL 8.3. I would like to search for prefixes to allow to complete words. For example, if I have the lexemes 'foo', 'foobar' and 'bar', I would like to get all the words whose prefix is 'foo', i.e 'foo' and 'foobar'. GIST or GIN (I

[GENERAL] functional dependency tool

Is there an existing tool that can infer the functional dependencies implied by the keys in an existing database? Or just compute the canonical cover of a set of functional dependencies? Regards, Jeff Davis ---(end of broadcast)--- TIP 5: d

Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?

Log Analyzer : pgFouine http://pgfoundry.org/projects/pgfouine/ Regards, Le samedi 29 décembre 2007, Ivan Sergio Borgonovo a écrit : > On Sat, 29 Dec 2007 10:16:50 +0100 > > Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > > Ivan Sergio Borgonovo <[EMAIL PROTECTED]> schrieb: > > > or/and is there

Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?

On Sat, 29 Dec 2007 10:16:50 +0100 Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > Ivan Sergio Borgonovo <[EMAIL PROTECTED]> schrieb: > > > or/and is there something to spot what are the most critical sql > > queries/function behind an application? > > You can set "log_min_duration_statement" in

Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?

Ivan Sergio Borgonovo <[EMAIL PROTECTED]> schrieb: > or/and is there something to spot what are the most critical sql > queries/function behind an application? You can set "log_min_duration_statement" in your postgresql.conf to log all querys with a duration highter than that value. Andreas --

[GENERAL] Is there something like MySQL enterprise monitor for Postgres?

or/and is there something to spot what are the most critical sql queries/function behind an application? Reading http://lstigile.wordpress.com/2007/12/27/cms_mysql/ it does look more a tool to tune MySQL configuration... what about tools to spot weak places in Postgres applications? thx -- Ivan