The PGJDBC docs describe how one can include a URL parameter of options in order to set session variables: https://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters

This is important because PGJDBC does not allow one to set session variables directly in the URL. That is, you need to specify like this:

postgresql://user@host:port/database?options=-c%20serial_nor

Now insert and query share the resource ( Max Process Count control) 。 When the query with high TPS，the insert will get error (“error: too many process”). I think separator the resource for Insert and Query will makes sense. Ensure enough resource for insert。It looks like Use Yarn， Insert and Query use the different resource quota。
Or the simple way , Can we set Ratio for Insert and

The network option setting code uses the default option code, which interprets the bytes passed to the option as a binary encoded 8 byte integer. The only way to set an integer value is to set the environment variable to the 8 byte binary encoding.

Hello Philip!
I think there is an issue with this part of the code of rqlite (store/store.go).

func (s *Store) Database(leader bool) ([]byte, error) {
	if leader && s.raft.State() != raft.Leader {
		return nil, ErrNotLeader
	}
	// Ensure only one snapshot can take place at once, and block all queries.
	s.mu.Lock()
	defer s.mu.Unlock()

	f, err := ioutil.TempFile("", "rqlilte-snap-

See referenced comment:

Originally posted by @bmatican in yugabyte/yugabyte-db#6894 (comment)

Creating more than 100 partitions fails with the following error:

[84148226] Query failed (#20210118_061400_09812_m328m): Exceeded limit of 100 open writers for partitions

https://github.com/trinodb/trino/blob/690d9663e76efdb5bbdc10beb8aa461cf86cbdc6/plugin/trino-iceberg/src/main/java/io/trino/plugin/iceberg/IcebergPageSink.java#L85

Possible solution is to take advantage of `hive.

Currently we don't have any mechanism to limit the maximum number of clients that could be handled simultaneously.

This feature should be designed properly. Here is some clue: https://redis.io/topics/clients#maximum-number-of-clients

Now that we support more than 1 data type, we should include the values data type in cache nodes. This give us a way of easily identifying what type of data a key points to e.g. string, queue (and more types in the future)

Currently a cache node object consists of a Key, a Value and a TTL. We should also add a field specifying the type of the Value