[GENERAL] OR vs UNION vs UNION ALL

2015-09-23 Thread Etienne Champetier
Hi, I've reworked a bit an application to make 1 query (with many OR) instead of thousands (2900 in this bench), but was a bit disappointed with the perf. Here follow a quick bench and 2 questions at the end: Here is my table CREATE TABLE properties ( item_id text NOT NULL, calendar_id uuid N

Re: [GENERAL] looking for old rpm

2015-09-21 Thread Etienne Champetier
Hi, 2015-09-21 17:46 GMT+02:00 John R Pierce : > On 9/21/2015 12:31 AM, Etienne Champetier wrote: > >> I'm looking for old postgres rpm, like >> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm >> >> (one of our software is "certified" with this

[GENERAL] looking for old rpm

2015-09-21 Thread Etienne Champetier
Hi, I'm looking for old postgres rpm, like postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm (one of our software is "certified" with this minor version ...) Thanks in advance Etienne

Re: [GENERAL] Postgresql C extension and SIGSEGV

2015-09-04 Thread Etienne Champetier
Hi and thanks for the answer 2015-09-04 11:45 GMT+02:00 Albe Laurenz : > Etienne Champetier wrote: > > We are planning to add a C extension ( > https://github.com/petropavel13/pg_rrule) to our shared > > postgresql cluster, and wondering what are the risk? (looking for the >

[GENERAL] Postgresql C extension and SIGSEGV

2015-09-03 Thread Etienne Champetier
Hi, We are planning to add a C extension ( https://github.com/petropavel13/pg_rrule) to our shared postgresql cluster, and wondering what are the risk? (looking for the worst case scenario here) If there is a SIGSEGV, SIGBUS, SIGABRT ..., is the whole server stopping, or just the request? Knowin

Re: [GENERAL] Reset permissions on table

2013-02-15 Thread etienne . champetier
- Mail original - > De: "Albe Laurenz" > À: "etienne.champet...@free.fr *EXTERN*" , > pgsql-general@postgresql.org > Envoyé: Vendredi 15 Février 2013 13:25:14 > Objet: RE: [GENERAL] Reset permissions on table > > etienne champetier wrote: > &

[GENERAL] Reset permissions on table

2013-02-15 Thread etienne . champetier
Hi By default there is no permissions on table (\dp return 0 row) If I make a GRANT, doing a REVOKE will not get me in the 'default' state How to return in the default state, where permission are 'inherited' from owner. Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@p