hm...
I have provided examples? Tables definitions and plan for each query? (in
another thread..)
I am not sure I can buy it that that are *very* different queries I
would say - they are the same - why would you need to evalute 100 rows and
reduce end result on one?
execute function - is
On Mon, Mar 25, 2013 at 4:32 PM, Misa Simic wrote:
> Thanks Merlin,
>
> Well... sorry, It could be and my bad english... but let me explain
> chronologicaly things...
>
> I have first written concrete case...
>
> http://postgresql.1045698.n5.nabble.com/PostgreSQL-planner-tp5749427.html
>
> But bec
Thanks Merlin,
Well... sorry, It could be and my bad english... but let me explain
chronologicaly things...
I have first written concrete case...
http://postgresql.1045698.n5.nabble.com/PostgreSQL-planner-tp5749427.html
But because of I recognized the pattern - always is problem with JOIN to a
On Sat, Mar 23, 2013 at 9:25 PM, Misa Simic wrote:
> HI,
>
> When I have met PostgreSQL for a first time - I have been really amazed -
> with many things...
>
> But how we started to use it - and data jumps in - we meet performance
> problems...
>
> Now, it is a bit tricky... any concrete performa
Hi Serge,
here are the some examples I posted in PERFORM list:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-planner-tp5749427.html
No - I do not compare Pg to anything - I am developer - before, I used SQL
Server - but two years ago I moved to Postgres - and I have no idea what
SQL Server
Hi a couple of things:
from some unknown reason - gives bad plan - then if we "refactor" query and
> send different question - we get good result... I am pretty sure planner
> should be capable to "rephrase" my question instead of me...
You seem to be comparing PostgreSQL performance to some oth
HI,
When I have met PostgreSQL for a first time - I have been really amazed -
with many things...
But how we started to use it - and data jumps in - we meet performance
problems...
Now, it is a bit tricky... any concrete performance problem - can be solved
on some way...
However, I am more conc
