Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread basti
Please use this http://www.postgresql.org/community/lists/subscribe/ link. On 28.01.2015 12:01, Quirin Hamp wrote: Please unsubscribe me from mailing list. Thank you! Bien cordialement, / Mit freundlichen Grüßen / Yours sincerely, Quirin HAMP _ Viessmann

Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread Andreas Kretschmer
Leon Dang ld...@nahannisys.com wrote: Hi I've implemented a completely new Redis FDW module which has little to do with github.com/pg-redis-fdw/redis_fdw; although I did take some inspiration from in on how the tables were to be designed but most I got from looking at the oracle-fdw.

Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread Leon Dang
The code has been posted to https://github.com/nahanni/rw_redis_fdw Anyone interested can test it out or review it. cheers Leon Leon Dang wrote on 01/24/2015 04:17 PM: Hi I've implemented a completely new Redis FDW module which has little to do with github.com/pg-redis-fdw/redis_fdw

Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread Quirin Hamp
Please unsubscribe me from mailing list. Thank you! Bien cordialement, / Mit freundlichen Grüßen / Yours sincerely, Quirin HAMP _ Viessmann Faulquemont S.A.S Responsable développement systèmes thermiques Avenue André GOUY F 57380 Faulquemont Tel.: +33

Re: [GENERAL] Conflicting function name in dynamically-loaded shared library

2015-01-28 Thread Albe Laurenz
Adam Mackler wrote: I am wanting to define some functions as described in section 35.9 of the manual, C-Language Functions. I am compiling pre-existing files of c-code from another project into object files, and then linking those object files into a shared library along with my own functions

Re: [GENERAL] segmentation fault postgres 9.3.5 core dump perlu related ?

2015-01-28 Thread Day, David
It has been some time since we have seen this problem. See earlier message on this subject/thread for the suspect plperl function executing at the time of the core. Someone on our development team suggested it might relate to some build options of perl. In particular MULTIPLICITY or

[GENERAL] vacuum full post 9.0 - reindex needed?

2015-01-28 Thread Anand Kumar, Karthik
I haven’t been able to find clear information online about what happens with existing indexes on a postgres post-9.0 database (we specifically use 9.3) after a vacuum full. There is a lot of information on how a vacuum differs from a vacuum full, but my question is – is a re-index needed after

Re: [GENERAL] vacuum full post 9.0 - reindex needed?

2015-01-28 Thread Guillaume Lelarge
Hi, 2015-01-28 21:39 GMT+01:00 Anand Kumar, Karthik karthik.anandku...@classmates.com: I haven’t been able to find clear information online about what happens with existing indexes on a postgres post-9.0 database (we specifically use 9.3) after a vacuum full. There is a lot of

Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread Leon Dang
George Silva wrote on 01/28/2015 11:49 AM: Great. Congratulations. How big is the latency in the FDW? This opens up new possibilities using redis. Very cool. # explain analyze insert into rstr values ('k4434', '3234234'); QUERY PLAN

Re: [GENERAL] segmentation fault postgres 9.3.5 core dump perlu related ?

2015-01-28 Thread Alex Hunsaker
On Wed, Jan 28, 2015 at 1:23 PM, Day, David d...@redcom.com wrote: It has been some time since we have seen this problem. See earlier message on this subject/thread for the suspect plperl function executing at the time of the core. Someone on our development team suggested it might

[GENERAL] How does Delete Query work ??

2015-01-28 Thread sri harsha
Hi, I want to know about the flow in which delete query is executed in postgres . Assume i have a following query. *Delete from table_a * where column_a = 'something'* How is this query executed ? Are the rows first filtered out and then deleted one by one ?? Or is the row deleted as and

Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread Leon Dang
Andreas Kretschmer wrote on 01/28/2015 03:36 AM: I've implemented a completely new Redis FDW module which has little to do with github.com/pg-redis-fdw/redis_fdw; although I did take some inspiration from in on how the tables were to be designed but most I got from looking at the

Re: [GENERAL] Request for review of new redis-fdw module

2015-01-28 Thread George Silva
Great. Congratulations. How big is the latency in the FDW? This opens up new possibilities using redis. Very cool. On Wed, Jan 28, 2015 at 5:19 PM, Leon Dang ld...@nahannisys.com wrote: Andreas Kretschmer wrote on 01/28/2015 03:36 AM: I've implemented a completely new Redis FDW module