FWD » Core Development » Database

12/27/2015

08:33 PM Feature #2581: improve performance of non-preselect, multi-table joins

Paul Eames wrote:
> [...]
> What I've done is start the P2J server with collection-statistics enabled and ran one t... Eric Faulhaber

12/23/2015

09:32 AM Feature #2581: improve performance of non-preselect, multi-table joins

To complete the picture, it probably would be useful to perform CPU sampling on the server (and perhaps on the client... Eric Faulhaber

05:41 AM Feature #2581: improve performance of non-preselect, multi-table joins

Using @pg_stat_statements@ to gather similar data in the DB gives similar results (unsurprisingly).
It's probably ... Paul E

12/22/2015

09:03 AM Bug #2347: hql to SQL name mapping issue

The proposed update was merged to 2332a task branch from #2332 and committed to trunk. This can be closed now. Ovidiu Maxiniuc

06:58 AM Feature #2581: improve performance of non-preselect, multi-table joins

I've been looking into using the statistic collection DB as a way of understanding slow queries. I think it's really ... Paul E

12/21/2015

06:41 AM Bug #2942: shared temp-tables can use fields with different extent than the master temp-table

Testcases which show this problem:
# master temp-table (st1.p):... Constantin Asofiei

06:35 AM Bug #2942: shared temp-tables can use fields with different extent than the master temp-table

From #2795 note 22:
> Finally, about shared temp-tables and extent fields: there is a new issue which is (I think) o... Constantin Asofiei

06:34 AM Bug #2942 (New): shared temp-tables can use fields with different extent than the master temp-table

Constantin Asofiei

12/17/2015

12:57 PM Bug #2937: improved sequence support in H2

The H2 database engine is active developed. Starting at version 1.3.176 (2014-04-05) it fixes support for MINVALUE, M... Ovidiu Maxiniuc

12:44 PM Bug #2937 (New): improved sequence support in H2

Ovidiu Maxiniuc

12/02/2015

09:03 AM Feature #2618 (Closed): add some buffer/query/temp-table attributes

Greg Shah

08:35 AM Feature #2618: add some buffer/query/temp-table attributes

The update was merged into task branch 2677a as revision 11046. 2677a is already in trunk.
I believe we can close th... Ovidiu Maxiniuc

12/01/2015

06:16 PM Bug #2896: Close dynamically defined query when an underlying buffer is closed

The discussion has started in #2819.
Last letter from Eric:
My understanding of your work so far is that you've f... Stanislav Lomany

06:13 PM Bug #2896 (New): Close dynamically defined query when an underlying buffer is closed

Stanislav Lomany

10:19 AM Feature #2692: table-level VALEXP/VALMSG support

Greg Shah wrote:
> Can we close this?
All the work with the code is done and merged to trunk. I just left this open... Eric Faulhaber

08:17 AM Feature #2692: table-level VALEXP/VALMSG support

Can we close this? Greg Shah

08:17 AM Feature #2618: add some buffer/query/temp-table attributes

Can we close this? Greg Shah