[GENERAL] How to generate are own apt packages for ubuntu?

2016-02-23 Thread David Grelaud
ns if possible)? Is there a better solution? Thank you, *David Grelaud*

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-09 Thread David Grelaud
inserts, updates and deletes every day as you. Hopefully, we've never experienced a data corruption until now ("crossed fingers"). *David Grelaud* 2016-02-10 8:06 GMT+01:00 Josh berkus : > On 02/10/2016 05:10 AM, ioan ghip wrote: > >> I have a Firebird SQL database r

Re: [GENERAL] Why PG uses nested-loop join when no indexes are available?

2016-01-20 Thread David Grelaud
to complete. The performance difference is huge. I mean, even if the plan is not the best one 100% of the time, it should at least choose a "risk-free" plan, without these "bad" nested-loops. It is maybe easier said than done but we want to try. Regards, *David Grelaud* 20

Re: [GENERAL] Why PG uses nested-loop join when no indexes are available?

2016-01-13 Thread David Grelaud
loop). We thought at the beginning we were alone but it seems to be a problem of most database systems. What do you think about the paragraph 4.1 of this paper http://www.vldb.org/pvldb/vol9/p204-leis.pdf ? Regards, ------- David Grelaud, Ideolys. 2016-01-13 16:02 GMT+01:00 Tom Lane :

[GENERAL] Why PG uses nested-loop join when no indexes are available?

2016-01-13 Thread David Grelaud
d like to find a "simple" long-term solution to this under-estimation cost problem, which generate hazarduous performance regressions in our production environments. We would like to hear critiques or other solutions from PostgreSQL experts. We would like to help developing and testing the solution. Thank you very much! Regards, --- David Grelaud, Ideolys.