Re: [ADMIN] [PERFORM] Vs NULL

2015-02-09 Thread sridhar bamandlapally
Mon, Feb 9, 2015 at 6:32 PM, Marc Mamin wrote: > > >>>Hi > >>> > >>>2015-02-09 12:22 GMT+01:00 sridhar bamandlapally >: > >>> > >>>Hi All > >>> > >>>We are testing our Oracle compatibl

[PERFORM] Vs NULL

2015-02-09 Thread sridhar bamandlapally
Hi All We are testing our Oracle compatible business applications on PostgreSQL database, the issue we are facing is Vs NULL In Oracle '' () and NULL are treated as NULL but, in PostgreSQL '' not treated as NULL I need some *implicit* way in PostgreSQL where '' can be treated as NULL Please

Re: [PERFORM] PostgreSQL Parallel Processing !

2012-01-27 Thread sridhar bamandlapally
technology at SQL-Query level On 1/27/12, Thomas Kellerer wrote: > sridhar bamandlapally, 27.01.2012 05:31: >> SQL> explain plan for select * from hr.emp ; >> Explained. >> PLAN >> -- >> | I

Re: [PERFORM] PostgreSQL Parallel Processing !

2012-01-26 Thread sridhar bamandlapally
*Hi ALL* ** *Please have a look into this,* *this may help us to think on PARALLEL option* ** *WITHOUT PARALLEL Option* SQL> explain plan for select * from hr.emp ; Explained. PLAN -- | Id | Operation | Name | Rows |

Re: [PERFORM] PostgreSQL Parallel Processing !

2012-01-25 Thread sridhar bamandlapally
an be very exclusive parallelism solution with proper error handling as it is part of SQL-Query syntax On Wed, Jan 25, 2012 at 7:13 PM, Claudio Freire wrote: > On Wed, Jan 25, 2012 at 6:18 AM, sridhar bamandlapally > wrote: > > I just want to illustrate an idea may possible for bri

Re: [PERFORM] PostgreSQL Parallel Processing !

2012-01-25 Thread sridhar bamandlapally
Hi Everyone I just want to illustrate an idea may possible for bringing up parallel process in PostgreSQL at SQL-Query level The PARALLEL option in Oracle really give great improvment in performance, multi-thread concept has great possibilities In Oracle we have hints ( see below ) : SELECT /*+P