Re: [PERFORM] Unable to find PostgreSQL 9.5.6 software in PostgreSQL site.

2017-07-21 Thread Florent Guillaume
> intended recipient, please contact the sender by reply email and destroy > all copies of the original message. Check all attachments for viruses > before opening them. All views or opinions presented in this e-mail are > those of the author and may not reflect the opinion of Cyient or those of > our affiliates. > -- [image: Nuxeo] Florent Guillaume Head of R Twitter: @efge

Re: [PERFORM] CREATE EXTENSION postgis;

2017-07-20 Thread Florent Guillaume
; all copies of the original message. Check all attachments for viruses > before opening them. All views or opinions presented in this e-mail are > those of the author and may not reflect the opinion of Cyient or those of > our affiliates. > -- [image: Nuxeo] Florent Guillaume Head of R Twitter: @efge

Re: [ADMIN] [PERFORM] empty string Vs NULL

2015-02-10 Thread Florent Guillaume
-definition.html ) regards, Marc Mamin -- Florent Guillaume, Director of RD, Nuxeo Open Source Content Management Platform for Business Apps http://www.nuxeo.com http://community.nuxeo.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes

Re: [PERFORM] numerical primary key vs alphanumerical primary key

2013-02-12 Thread Florent Guillaume
Android phone with K-9 Mail. Please excuse my brevity. -- Florent Guillaume, Director of RD, Nuxeo Open Source, Java EE based, Enterprise Content Management (ECM) http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87 -- Sent via pgsql-performance mailing list (pgsql-performance

Re: [PERFORM] Unique values across a table of arrays - documents and tags

2012-11-07 Thread Florent Guillaume
that PostgreSQL can do much more than I thought it can. -- Florent Guillaume, Director of RD, Nuxeo Open Source, Java EE based, Enterprise Content Management (ECM) http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87 -- Sent via pgsql-performance mailing list (pgsql-performance

Re: [PERFORM] Unique values across a table of arrays - documents and tags

2012-11-07 Thread Florent Guillaume
On Wed, Nov 7, 2012 at 5:00 PM, Ivan Voras ivo...@freebsd.org wrote: On 07/11/2012 16:54, Florent Guillaume wrote: Maybe you could store the tags as fulltext words, query them using fulltext search, and use ts_stat to gather the list of words? Needs to be benched of course. You'll probably

Re: [PERFORM] Slow fulltext query plan

2012-04-16 Thread Florent Guillaume
= hierarchy.id, TO_TSQUERY('whatever') query1, TO_TSQUERY('whatever') query2 WHERE (query1 @@ nx_to_tsvector(fulltext.fulltext)) OR (query2 @@ nx_to_tsvector(fulltext.fulltext_title)) ORDER BY nxscore DESC; (as is also described in the doc mentioned btw). Florent -- Florent Guillaume, Director