Hello,
Sorry for the re-post - not sure list is the relevant one, I included
slightly changed query in the previous message, sent to bugs list.
I have an ORM-generated queries where parent table keys are used to
fetch the records from the child table (with relevant FK indicies),
where child tabl
l runtime: 585.566 ms
(28 rows)
Time: 588.102 ms
Would be grateful for any pointers as the server restart is the only option
now once such a query starts trashing the disk.
Best Regards,
Krzysztof
Krzysztof Nienartowicz writes:
> surveys-> SELECT t1.SURVEY_PK, t1.SOURC
and I set statistics on
sources(srcid) to 1000 from default 10. It fixed the plan! Sources table was
around 100M so skewness in this range must have been looking odd for the
planner..
Thank you for the hints!
Best Regards,
Krzysztof
On May 27, 2010, at 6:41 PM, Tom Lane wrote:
> Krzysz
Hello Daniel,
We have the same scenario for the native Java arrays, so we are storing bytea
and doing conversion at the client side, but for the server side SQL, plJava
comes very handy:
No sure how you want to create stored procedures to convert internally but this
is how we do this:
One has
