Re: Reversing NULLS in ORDER causes index not to be used?

2020-12-18 Thread Ken Tanzer
On Fri, Dec 18, 2020 at 6:03 PM Tom Lane wrote: > Ken Tanzer writes: > > Hi. I'm wondering if this is normal or at least known behavior? > > Basically, if I'm specifying a LIMIT and also NULLS FIRST (or NULLS LAST > > with a descending sort), I get a sequence scan and a couple of orders of > >

Re: Reversing NULLS in ORDER causes index not to be used?

2020-12-18 Thread Tom Lane
Ken Tanzer writes: > Hi. I'm wondering if this is normal or at least known behavior? > Basically, if I'm specifying a LIMIT and also NULLS FIRST (or NULLS LAST > with a descending sort), I get a sequence scan and a couple of orders of > magnitude slower query. Perhaps not relevantly, but defini

Reversing NULLS in ORDER causes index not to be used?

2020-12-18 Thread Ken Tanzer
Hi. I'm wondering if this is normal or at least known behavior? Basically, if I'm specifying a LIMIT and also NULLS FIRST (or NULLS LAST with a descending sort), I get a sequence scan and a couple of orders of magnitude slower query. Perhaps not relevantly, but definitely ironically, the sort fi

Re: Oracle to postgresql

2020-12-18 Thread Ian Lawrence Barwick
2020年12月18日(金) 19:43 bangalore umesh : > > Hi > > Please help me with document for oracle to postgresql > useing Ora2pgtool AFAIK the main documentation is the extensive README file, as available here: https://github.com/darold/ora2pg Regards Ian Barwick

Oracle to postgresql

2020-12-18 Thread bangalore umesh
Hi Please help me with document for oracle to postgresql useing Ora2pgtool -- Thanks and Regards Rajshekhariah Umesh