Project

General

Profile

Activity

From 03/03/2019 to 04/01/2019

04/02/2019

10:52 PM Feature #4030: improve CompoundQuery optimizer
Some time ago, I implemented a runtime optimizer for @CompoundQuery@, which would analyze the components of the compo... Eric Faulhaber
10:36 PM Feature #4030 (New): improve CompoundQuery optimizer
Eric Faulhaber

04/01/2019

06:40 PM Feature #4024: PostgreSQL shared memory JDBC driver
This concept is a more outside-the-box corollary to the idea behind #4012. In a system where lots of round trips to t... Eric Faulhaber
06:22 PM Feature #4024 (New): PostgreSQL shared memory JDBC driver
Eric Faulhaber
06:20 PM Feature #4023: PostgreSQL query planning optimization
To date, we have not made a concentrated effort to tune PostgreSQL's query planner for FWD's use, beyond some basics:... Eric Faulhaber
06:12 PM Feature #4023 (New): PostgreSQL query planning optimization
Eric Faulhaber
06:10 PM Feature #4022: upgrade to a newer PostgreSQL release
At the time of this writing, the most recent production PostgreSQL release is 11.2. We are currently working primaril... Eric Faulhaber
05:48 PM Feature #4022 (WIP): upgrade to a newer PostgreSQL release
Eric Faulhaber
03:37 PM Feature #4021: better use of session-related resources such as PreparedStatements and caches
At the moment, this task is somewhat speculative, in that I'm not sure how well we are amortizing the cost of setting... Eric Faulhaber
03:22 PM Feature #4021 (New): better use of session-related resources such as PreparedStatements and caches
Eric Faulhaber
03:19 PM Feature #4020: reduce work Hibernate does flushing session
Each time Hibernate does something that relies on the state of the database to be consistent with changes in the stat... Eric Faulhaber
02:46 PM Feature #4020 (Rejected): reduce work Hibernate does flushing session
Eric Faulhaber
02:51 PM Feature #3809: ProDataSet support
Committed r11576 of branch 3809b.
At this moment all the sources provided convert. However, the code is not 100% c...
Ovidiu Maxiniuc
11:35 AM Feature #4019: rework dirty database implementation to use persistent database
This task is meant to address two issues with the current dirty database implementation:
* it is limited, in that ...
Eric Faulhaber
11:06 AM Feature #4019 (New): rework dirty database implementation to use persistent database
Eric Faulhaber
11:02 AM Feature #4018: possibly move temp-table support into persistent database
We already do a form of optimization for @CompoundQuery@, where we attempt to determine whether a multi-table query w... Eric Faulhaber
10:55 AM Feature #4018: possibly move temp-table support into persistent database
In the early days of FWD, temp-table support was implemented in the persistent database (e.g., PostgreSQL). To avoid ... Eric Faulhaber
10:25 AM Feature #4018 (New): possibly move temp-table support into persistent database
Eric Faulhaber
11:52 PM Feature #4012 (Review): replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as ...
Greg, I think we can close this. Eric Faulhaber
11:50 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Greg Shah wrote:
> What about PGCONF changes? Are AF_UNIX sockets enabled by default?
They are, at least in the ...
Eric Faulhaber
11:43 PM Feature #4016: replace portions of Hibernate which are non-performant
We maintain a lot of information in FWD's persistence layer which is redundant with information maintained by Hiberna... Eric Faulhaber
11:35 PM Feature #4016 (Closed): replace portions of Hibernate which are non-performant
Eric Faulhaber
10:35 PM Feature #4015: upgrade to a newer Hibernate release
As [[FWD:Patching_and_Building_Customized_3rd_Party_Libraries#Hibernate|documented here]], we currently are at a cust... Eric Faulhaber
10:14 PM Feature #4015 (Rejected): upgrade to a newer Hibernate release
Eric Faulhaber

03/29/2019

07:17 AM Feature #3809: ProDataSet support
I did the refactoring as you suggested. I think it's a good solution.
I am working now on the conversion of stati...
Ovidiu Maxiniuc

03/28/2019

02:04 AM Feature #3809: ProDataSet support
I've previously created a class called @DataSource@ for use with XML and JSON serialization. However, this name alrea... Eric Faulhaber

03/27/2019

10:12 AM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
> Don't we also need to add code (jar(s) and a native library) to the system to make this work?
I see you've made ...
Greg Shah
07:25 AM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
> No other change is needed.
Don't we also need to add code (jar(s) and a native library) to the system to make th...
Greg Shah
12:24 AM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Greg Shah wrote:
> https://github.com/fiken/junixsocket
>
> This last one has a PostgresqlAFUNIXSocketFactory tha...
Eric Faulhaber

03/26/2019

04:35 PM Feature #4011: database/persistence layer performance improvements
This issue is for tracking ideas about improving the performance of the database and the persistence framework in FWD... Greg Shah
03:03 PM Feature #4011 (Closed): database/persistence layer performance improvements
Greg Shah
04:14 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Using shared memory, we could eliminate the 4 kernel space transitions (write() goes down into the kernel and returns... Greg Shah
04:13 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Early implementations of the Progress Database Server implemented connectivity using shared memory. This design, com... Greg Shah
04:08 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Eric Faulhaber wrote:
> Hynek, what did your @pg_hba.conf@ file look like to get as far as you did for this attempt?...
Hynek Cihlar
03:36 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Hynek, what did your @pg_hba.conf@ file look like to get as far as you did for this attempt? Eric Faulhaber
03:07 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Hynek's results, copied from #3992:
Hynek Cihlar wrote:
> Eric Faulhaber wrote:
> > Hynek or Constantin, could o...
Greg Shah
03:05 PM Feature #4012: replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as PostgreSQ...
Copied from #3992, from Eric:
This may be worth a look: https://impossibl.github.io/pgjdbc-ng/
The guy behind t...
Greg Shah
03:04 PM Feature #4012 (Review): replacing TCP/IP (AF_INET) sockets with Unix Domain Sockets (AF_UNIX) as ...
Greg Shah

03/22/2019

05:01 PM Feature #3809: ProDataSet support
Eric Faulhaber wrote:
> My intention was to rebase 3809a when 3750b was merged to trunk, because I didn't think we h...
Ovidiu Maxiniuc
04:57 PM Feature #3809: ProDataSet support
My intention was to rebase 3809a when 3750b was merged to trunk, because I didn't think we had dependencies on 3750b ... Eric Faulhaber
04:54 PM Feature #3809: ProDataSet support
Ovidiu Maxiniuc wrote:
> I will commit my changes for ProDataSet conversion to 3809a.
I added conversion support ...
Ovidiu Maxiniuc
03:29 PM Feature #3809: ProDataSet support
Here it is, attached.
I will commit my changes for ProDataSet conversion to 3809a.
Ovidiu Maxiniuc
03:21 PM Feature #3809: ProDataSet support
Constantin Asofiei wrote:
> Greg/Eric, can we postpone committing Ovidiu's changes until Monday?
Yes.
Ovidiu, ...
Eric Faulhaber
03:16 PM Feature #3809: ProDataSet support
Greg/Eric, can we postpone committing Ovidiu's changes until Monday? Constantin Asofiei
08:35 AM Feature #3809: ProDataSet support
Eric Faulhaber wrote:
> Ovidiu, how safe are these changes?
>
> Greg, Constantin, is it ok to commit this to 3750...
Constantin Asofiei
08:29 AM Feature #3809: ProDataSet support
Eric Faulhaber wrote:
> Ovidiu, how safe are these changes?
They are only token declarations. However, since the to...
Ovidiu Maxiniuc
08:25 AM Feature #3809: ProDataSet support
Ovidiu, how safe are these changes?
Greg, Constantin, is it ok to commit this to 3750b, or are we only allowing pe...
Eric Faulhaber
08:22 AM Feature #3809: ProDataSet support
Eric Faulhaber wrote:
> As of 3750b/11512, the parser is missing token-types for the following dataset-related featu...
Ovidiu Maxiniuc

03/21/2019

03:08 PM Feature #3809: ProDataSet support
As of 3750b/11512, the parser is missing token-types for the following dataset-related features:... Eric Faulhaber

03/20/2019

06:29 PM Feature #3809: ProDataSet support
These are procedures defined in @dataset/log_hlp.i@ or functions defined in @dataset/help/log_hlp.i@. I'm not sure wh... Eric Faulhaber
06:20 PM Feature #3809: ProDataSet support
I tried to convert the provided testcases an I encountered some unknown token: @assert-true@, @assert-err@, @assert-n... Ovidiu Maxiniuc
02:38 PM Feature #3809: ProDataSet support
I have created task branch 3809a for this work. It is based on trunk 11301, but I think that's ok. I don't know of an... Eric Faulhaber
12:40 PM Feature #3809 (WIP): ProDataSet support
Eric Faulhaber

03/14/2019

03:38 PM Bug #3960: localedef problems in Ubuntu 18.04
Can someone that is running on Ubuntu 16.04 test this new locale definition on the old localedef? I'd also like to k... Greg Shah
03:34 PM Bug #3960: localedef problems in Ubuntu 18.04
The attached locale definition uses the same string that is used in all other locales. It seems that this must be ha... Greg Shah
09:51 AM Bug #3960: localedef problems in Ubuntu 18.04
I had a fully functioning PostgreSQL 9.5 environment for FWD in Ubuntu 16.04.
I recently upgraded to Ubuntu 18.04....
Greg Shah
09:46 AM Bug #3960 (Closed): localedef problems in Ubuntu 18.04
Greg Shah
10:23 AM Bug #3961: "Unexpected code path" failure when using H2 in MVCC mode
When using H2 as a database, the following failure has been seen:... Greg Shah
10:17 AM Bug #3961 (New): "Unexpected code path" failure when using H2 in MVCC mode
Greg Shah

03/13/2019

02:15 PM Feature #3958: BUFFER-COPY optimization
BUFFER-COPY
The current implementation uses reflection to invoke the getters and setters of each property of the s...
Eric Faulhaber
02:01 PM Feature #3958 (Closed): BUFFER-COPY optimization
Eric Faulhaber
 

Also available in: Atom