Pg pool query. In Memory Query Cache.

Pg pool query 4. Connection pool for node-postgres. username) }) By using pool. pool. rows[0]. You can't fire of two query with Clients at the same time. stringify(rows)) The connection is created via PGHOST PGPORT PGUSER PGDATABASE in the environment. query could be used to directly run the query rather than acquiring a client and then running the query with that client. How can I achieve this using the node- Apr 2, 2020 · 7. query will allow you to execute a basic single query when you need to execute from a client that would be accessed from the pool of client threads. The format of pool_hba. Here's my exports function. connect(function (err, client, done) { var query_get_value = 'SELECT * FROM '+ tablename I have a question, that fetching query result from memcache may get old value? For example: In pgpool code Implementation: DML/DDL invalidate cache in ReadyForQuery function but the DML/DDL committed , so if failed to invalidate the cache , nexted-query will get a old wrong result. This technique is explained in Section 5. The available commands differ among PostgreSQL versions. client. finally, sometimes). If you use module. query(). Installing pgpool-II. txt on any schema will trigger the segmentation fault, even if the tables specified in the query do not exist in the schema. Jul 13, 2020 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Passing the query to a pool; Borrowing a client from a pool and executing the query with it; Obtaining an exclusive client and executing the query with it; It is recommended to pass the query to a pool as often as possible. Managing Client Connections 7. 13. Oct 6, 2019 · I am attempting to return the result of a node-postgres query and store it in a variable. Examples. There are 125 other projects in the npm registry using pg-pool. Hot Network Questions Merging multiple JSON data blocks into a single entity Extend node-pg-pool Allow to connect to postgresql and execute query. And then export this data to a Node. Pgpool-II performs authentication using pool_passwd file which contains the passwords of PostgreSQL users. log('rows', JSON. Stubbing query() method of pg. query( "SELECT * FROM typeTable ORDER BY user_name desc;"); console. query methods - all you can do with the Promise is call . 13 Jun 3, 2021 · This is a promotion of your module, not an answer the question. In theory, I'm running model. reactive. I tried both promise syntax (async/await and then/catch) and callback syntax, none of them worked. Both databases have the same tables on both machines. then: pool_counter counts the number of times this connection has been used by clients; pool_backendpid is the PID of the PostgreSQL process; pool_connected is a true (1) if a frontend is currently using this backend. query delegates directly to client. At Pgpool-II pod startup, Pgpool-II automatically executes pg_md5 command to generate pool_passwd based on the environment variables defined in the format <some string>_USERNAME and <some string>_PASSWORD. This is the preferred way to query with node-postgres if you can as it removes the risk of leaking a client. The scenario I am looking at is where an array has a series of values Dec 9, 2020 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. If that isn't possible, because of long and complex transactions for example, borrow a client from a pool. You can easily change it (as we did here) by changing the corresponding setting, eg: Dec 12, 2024 · 4. current:4095 requested:111 memq_maxcache:4096 Note: For the shared memory query( 'shmem' ) cache the memqcache_maxcache must be set lower than memqcache_cache_block_size and for 'memcached' it must be lower than the size of slab (default is 1 MB). Let's Begin! 1. Implement pg_enc and pg_md5 to allow to register multiple passwords at once. I have tried various approaches provided but none of them worked. Pool() // connection using created pool pool. PostgreSQL connects to Pgpool-II (5) and Pgpool-II reply back to PostgreSQL with the result (3). query (Pool is instance of pg. 8. conf File 6. Using different methods for frontend and backend authentication 6. query() can be a drop-in replacement everywhere - I suggest it as a workaround for the case on hand. LOG: pid 13756: pool_add_temp_query_cache: data size exceeds memqcache_maxcache. config. New PCP command pcp_reload_config is added. Asking for help, clarification, or responding to other answers. You can/should get rid of your 2nd try/catch block that contains the pool. The supported log destinations are stderr and syslog. 2, last published: 4 months ago. And you only include the pg within your package. However, if your application is using the database very frequently, the pool will be a better option than using a single client. May 29, 2019 · But pool. I have a concern how to specify a optimal number for max size of Pool. But it's not fetching the parameters since they are referenced inside single quotes. Executing the query in segfault_sql. For example, give "postgres" as the command line argument, at pg_md5 displays md5-hashed text to the standard output. query method - both methods support the same API. It adds: postgres-queries/pool, support named query. I got some useful formulas to get Pgpool user: Pgpool itself needs to connect to all the Postgres clusters to monitor health and replication. Pool(config); var tablename = req. It'll always return num_init_children*max_pool lines. eclipse. Many of the articles are old which I read. js I have this code for the meantime. Configuring PCP commands. query method instead of the pool. By default, pool_hba authentication is enabled. package org. getDashboard = function(req, response, next) 5. We assume that you already know basic PostreSQL operations, so please refer to the PostgreSQL document if needed. 負荷分散. Mar 25, 2019 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. query('select 1 as x') console. Contents of query cache is not updated even if the underlying table is get updated. Performance Considerations 7. updateOne commands to update records in the DB. The problem I am having is the overall Mar 22, 2018 · const pool = new pg. 关于本文档. query(), you need to stub pg-pool prototype and method query. In memory cache saves the pair of SELECT statement and its result (along with the Bind parameters, if the SELECT is an extended query). Dec 24, 2018 · I am using node-postgres to query my database and would like to know how to use async/await and handle errors correctly An example of my use is here with a very simple query const { Pool } = requir For the sake of brevity I am using the client. Some errors 5. The query: const user = await pool. runtime. A connection pool for node-postgres. exports. 2 for more details), it is possible to distribute read queries among those database nodes to get more throughput since each database nodes processes smaller number of queries. Note here that parameters are passed via prepared queries and we do not concatenate SQL text ever. query('select username from user WHERE username= $1',[username], function(err, res) { console. You must use the same client instance for all statements within a transaction. pool. var client = new pg. inject Jul 31, 2021 · In my node app, i need to run below query and and i'm passing parameters dynamically. Would it be overkill to acquire the client from the pool, use it once and then release it? – Jan 25, 2016 · Simple usage of pg module's built-in parameterized query with flattened values. Allow to show statistics of health check by using SHOW POOL_HEALTH_CHECK_STATS command, and also allow to show statistics of issued SQL by using SHOW POOL_BACKEND_STATS command. e. connect try May 13, 2021 · I am don't understand why the await in front of a pg client request does not seem to work as the code after it runs before the code inside the client. an update statement could update many rows (so high result. Provide details and share your research! But avoid …. crud; import io. var pool = new pg. query , the library will take care of releasing the client after the query is done. StartupEvent; import io. The user should be granted the pg_monitor role (Postgres v10+). query inside a . Below are some recommended settings for reset_query_list on different PostgreSQL versions. 在本教程中，将讲解一个简单的方法来在共享内存中试用“基于内存的查询缓存”。 你需要的是一个安装有 PostgreSQL 和 pgpool-II 的 Linux 测试环境。 Feb 23, 2020 · Thanks a lot for a comprehensive answer. Read Query Load Balancing. 0. I know you do that promise implementation of node-pg but please don't take questions out of the unanswered queue just to say, hey i have a module for that. I'll digest it a bit and might accept it soon. 7. 6. Apr 9, 2019 · Trying to run multiple pg pool query functions in one command using 'make-runnable' Ask Question Asked 5 years, 7 months ago. When the underlying table gets updated, corresponding cache enrties are deleted (in case memqcache_auto_cache_invalidation is on. I'll meet your temp table, role and param and raise you a cursor, listener, table or advisory lock, prepared statement and sequence cache - basically completing the list of stuff lost on a sudden DISCARD ALL. query('SELECT * FROM songs WHERE $1 = ANY (style)', [style]);, but I'd like to know if there's a way to work with the form above. sample as pool_hba. conf and edit it if necessary. I am writing code in node. Start using pg-pool in your project by running `npm i pg-pool`. This means if you initialize or use transactions with the pool. conf. pg_md5 takes text as an command line argument, and displays its md5-hashed text. You do exports. I need to write unit test for it. Pgpool-II load balancing of SELECT queries works with any clustering mode except raw mode. local DATABASE USER METHOD [OPTION] host DATABASE USER CIDR-ADDRESS METHOD [OPTION] pg-query-stream@3. The overall functionality is pretty basic. This method allows developers to interact with the database by sending SQL queries and fetching the results. This allow us to name the parameter. query, a Promise is returned, and Promises don't have . – rotarydial Jan 2, 2021 · In short, I have a service layer, models and the client call (which calls pg's pool. Added graceful cluster failover Added default AWS TLS settings via ssl='aws-rds' Typescript is used to enforce type safety and promises are preferred over callbacks. In case (1), Pgpool-II accepts query from user (1), then forward to PostgreSQL (3). Load Balancing. Jul 21, 2016 · I would like to know if it's possible to run a series of SQL statements and have them all committed in a single transaction. We do this to avoid SQL injection attacks, where a specially crafted parameter is created to execute arbitrary SQL against your server. Oct 11, 2013 · Load Balance: If a database is replicated, executing a SELECT query on any server will return the same result. Mar 10, 2021 · I'm a total beginner attempting to make social media site with the PERN stack and I'm having trouble with my delete request, while debugging with Postman. It'll always return num_init_children * max_pool * number_of_backends lines. If your query has no parameters you do not need to include them to the query method: I need some help regarding pg npm. log(allScores); In my head, I would have thought these two blocks of code would basically be equivalent but they are not. When enabled Pgpool-II sends the writing queries to the primary node in Native Replication mode, all of the backend nodes in Replication mode, and other queries get load balanced among all backend nodes. json . conf" for more detail. connect(); var Mar 23, 2019 · I'm trying to use pg-pool to query a Postgresql database. In fact, pool. configure the AWS root Do not use transactions with the pool. Feb 24, 2023 · @Bergi No argument there. query and the object has a . query() function. catch() didn't fire so LOG: DB node id: 0 backend pid: 17749 statement: SELECT * FROM pgbench_accounts ; LOG: pool_add_temp_query_cache: data size exceeds memqcache_maxcache. js. Thought it could be what some are looking for. If you pass an object to client. length would be zero. microprofile. current:983 requested:110 memq_maxcache:1024 Specify each query not to cache. In Memory Query Caching 7. Apr 3, 2013 · While booting my Node. The script just never ends. Rewrote stream internals to better conform to node stream semantics. I have no issue using it in the plain Mar 17, 2017 · I was testing some scenarios where the connection fails and got UnhandledPromiseRejectionWarning from node. In memory query cache can be used with all modes of Pgpool-II. js app, I want to make a couple of synchronous calls to the PostgreSQL database to check some things before continuing the control flow. How can I achieve this using the node- Apr 3, 2011 · LOG: pid 13756: pool_add_temp_query_cache: data size exceeds memqcache_maxcache. Feb 17, 2020 · I have a weird problem I encountered using Postgresql and Node. Nov 1, 2021 · I have a simple function to fetch values from the Postgres database. pgpool-II takes an advantage of the replication feature to reduce the load on each PostgreSQL server by distributing SELECT queries among multiple servers, improving system's overall throughput. catch on it (or . Pgpool-II supports two destinations for logging the Pgpool-II messages. It takes the SQL query as a parameter and returns a Promise that resolves with the resulting rows from the database. Authentication Methods 6. The in memory query cache keeps the SELECT results and the results are reused. This is in my opinion the correct way to use pg pool. exports=pool in your dbHandler then your code will work as is. Configuration Files. Due to the size and nature of this change (effectively a full re-write) it's safest to bump Apr 4, 2010 · 7. Text only. In Memory Query Cache. query("SELECT * FROM users WHERE user_email = $1", [ email ]); The req. Client(conString); client. Setting up pgpool. prototype using sinon. It provides the following features: pgpool-II maintains established connections to the PostgreSQL servers, and reuses them whenever a new connection with the same properties (i. end() code snippet. Basically, I've logged in as user X, creat max_pool (integer) Pgpool-II の各子プロセスがキャッシュするコネクションの最大数です。 Pgpool-II は、受け付けた接続が同じユーザ名かつ同じ実行時パラメータで同じデータベースに接続しようとする場合に、キャッシュされたコネクションを再利用します。 note: this does not reflect the number of rows returned from a query. My Apr 3, 2013 · While booting my Node. log_destination (string) . Any help to get the parameter working would be appreciated. query syntax you do not need to worry about releasing the connection back to the pool. Pool and successfully connected to DB), it never returns. Share. submit function on it, the client will pass it's PostgreSQL server connection to the object and delegate query dispatching to the supplied object. Modified 5 years, 6 months ago. import pg from 'pg' const { Pool} = pg const pool = new Pool const client = await pool. query method. conf is true. query` method in TypeScript is used for executing SQL queries on a PostgreSQL database connection pool. 5. To check for an empty query response on a SELECT query use result. 12 If you know SQL, these functions will be self-explanatory. 13 ƒ,;QTÕ~ €FÊÂùûý¨Ú[ýoª·˜»ûöÞPB @R–èœæ_Hc„ Pá索 ©ª¶*×,K3w ¡ä 8 Á`ü¾”ý3½¢† †Zíµ·þw’: P “X¯Ö ¼:NuŽÓW はじめに前回の記事（LinuxサーバーにPostgreSQL導入～外部サーバー接続まで）で、Linuxサーバに導入したPostgreSQLにNode. Feb 26, 2012 · I would like to know how can you check the row count of the query in PostgreSQL in node. vertx. acme. I know the configuration is "almost right" because the first time I tried it I got: Caution: Current query cache implementation creates cache data on database. Apr 6, 2018 · Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand Feb 7, 2018 · const db = new Pool() const {rows} = await db. Do not use transactions with the pool. It is best to create a dedicated user for this. Feature. 12. hope reply, thank you! LOG: DB node id: 0 backend pid: 17749 statement: SELECT * FROM pgbench_accounts ; LOG: pool_add_temp_query_cache: data size exceeds memqcache_maxcache. pgclient. Using c pool_counter counts the number of times this connection has been used by clients; pool_backendpid is the PID of the PostgreSQL process; pool_connected is a true (1) if a frontend is currently using this backend. [Steps to Reproduce] Connect to pgpool using psql on any database. For the first time the query is sent, Pgpool-II saves the query result, and use it for the second query without asking anything to PostgreSQL. Suggest a solution for this. t2. If there are two queries and the query strings (parameter for prepared statements if any) are identical, two queries are regarded as "same". Follow Dec 31, 2019 · I am new in node. Resource Requirement 7. Thus enabling query cache may not contribute to boost performance. If you don't need a transaction or you just need to run a single query, the pool has a convenience method to run a query on any available client in the pool. On the other hand, it might be slower than the normal path in some The pool_hba. length === 0. If white list and black list are not enough for you, put the text "/* NO QUERY CACHE */" at the head of the queries. In memory query cache allows to save a pair of SELECT statement and its result. It searches for the query string and the database name, and it processes it by the partial agreement retrieval. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Moreover Pgpool-II does not need a restart when the cache gets outdated because of the underlying table updates Copy pool_hba. When using Client, you have one connection that needs to shared in your code. I'm using pg-pool and asyncawait, but I throw the following error: "Error: await functions, yield functions, and value-returning suspendable If there are two queries and the query strings (parameter for prepared statements if any) are identical, two queries are regarded as "same". See "6. You can also set this parameter to a list of desired log destinations separated by commas if you want the log messages on the multiple destinations. データベースシステムを運用する際、障害に強い高可用で処理性能が高いシステムが求められます。 本ページでは、単一のPostgreSQL構成では実現できないこれらのシステム要求を満たすために、Pgpool-IIを利用した高可用、高性能を実現する機能について紹介します。 Apr 3, 2011 · 5. createOne and model. var pool = new Pool() pool. 7. Also about the redundant usage of await, I know it is redundant, but I have use it as a reminder that there's a promise returning to whoever calls that function. mutiny. There were some connection timeout issues that we encountered with pg-pool and the npm was not being updated. The following is for convenience. . Since no SQL parsing nor access to PostgreSQL are involved, using in memory cache is extremely fast. Feb 26, 2019 · To stub pool. Oct 29, 2021 · The code with the query: var customerData = pool. I the catch from the client. The other method is to use a connection pool. Apr 2, 2020 · 5. 1. PgPool; import org. SHOW POOL_NODES displays the node id, the hostname, the port, the status, the weight (only meaningful if you use the load balancing mode), the role, the SELECT query counts issued to each backend, whether each node is the load balance node or not, the replication delay (only if in streaming replication mode) and last status change time. Pgpool-II can cache the results of these queries to reduce database load. PostgreSQL isolates a transaction to individual clients. Improve this answer. PostgreSQL returns the result to Pgpool-II (5) and Pgpool-II forwards the data to the user (6). There is a lot more to the overall library - all resides in the pg module. query with a Submittable. const {Pool, Client} = requir If there are two queries and the query strings (parameter for prepared statements if any) are identical, two queries are regarded as "same". Query Caching. query. I am unable to mock pg client using jest or sinon. body on Fedora 32 is parsed, so it's not a firewall problem regarding the POST request. Apr 2, 2020 · To encrypt your password into md5 hash format, use the pg_md5 command, which is installed as one of Pgpool-II 's executables. conf file follows very closely pg_hba. I've also tried pg instead of pg-pool. When using Pool, you ask the pool to query the records you need. I would like to use LIKE in my query together with % at the beginning and end of searched term. query method you will have problems. It handles closing the connection for you. but got exactly the same results, though I've since found out that it's basically the same code. Register password to pool_passwd. This should make pg-query-stream much better at respecting highWaterMark and getting rid of some edge case bugs when using pg-query-stream as an async iterator. I have read many write ups and examples and have got totally confused about using the pg pool in a right way. 8. jsから接続するところまでをまとめました。次… Apr 2, 2020 · LOG: pid 13756: pool_add_temp_query_cache: data size exceeds memqcache_maxcache. In this post, I show how to use pgpool to provide a single PostgreSQL-compatible Aurora endpoint that automatically directs write traffic to the cluster endpoint and read traffic to the reader endpoint (Figure 2). So pool. Either post what why and how and then your module or don't answer at all. Read Query Load Balancing 7. Sep 15, 2017 · I am using node-pg-pool to query my Postgres db (host in AWS, db. 1. cøÿ EUí‡h¤,œ¿ßÿªööýkª{à c‰Nñ…õŒý6Ï"\Hð M@a6WÍÿ¹ª¶*×·,}Ë D(9 x@£ÑÞó¢vo¦¿FM~ ö E ã2ÿÏ¦Ö AÙ ©hÓ]QÞKÑÌü?Åj7`*Vv 9(Ù)d evvvW` ²â;6 YÎ ·× ¹Š} E½!¬S”wÝ¥KÑß2œÕÝ_÷â 4F PKôl­§g»c›§ËW Þ Ìd| 02$%ÀnÆvŸüõUl{rj‘öd÷Ô§” !nqSÄhõv»½ úlO‡#¤J%oò2ÿ\o¿Ÿú CFÚ—‘¼–Hæ´KÙc70e…î;o ¬÷Æô,zÝw Apr 2, 2020 · reset_query_list (string) Specifies the SQL commands to be sent to reset the backend connection when exiting the user session. @sehrope has a good explanation: Sep 21, 2020 · When you . It is possible to search for the data that exists in the query cache. Pgpool-II does not need a restart when the cache gets outdated because of the underlying table updates. Pool. user name, database, protocol version) comes in. Apr 2, 2020 · Description. Multiple commands can be specified by delimiting each by ";". It is possible to cache the SELECT query, if enable_query_cache of pgpool. If there are multiple PostgreSQL nodes and Pgpool-II operates in streaming replication mode, logical replication mode, slony mode or replication mode (for those running mode see Section 3. Sep 16, 2015 · It will take a parameterized sql string and an object and converts it to pg conforming query config. js express rest API. quarkus. end() Lots of older documentation will not reflect these changes, so the example code they use won't work anymore. connect(function(err, client, done) { client. If you want to make a new query after the old finishes, call client. Using Postman, the program fails on this query (but only on Fedora 32). When the underlying table gets updated, corresponding cache entries are deleted (in case memqcache_auto_cache_invalidation is on. Latest version: 3. It is different from the query cache on disk that In memory query cache is faster because of the in memory nature of the storage. then or . /dbHandler");. It is possible to monitor, start, stop pgpool and change setting for pgpool. In many applications, specific queries are frequently executed with identical parameters, leading to redundant database access. rows. Using AES256 encrypted passwords in pool_passwd 7. 3. Dec 25, 2020 · Client is a single connection to a postgres database server while a Pool can have multiple connections to a database server. I can manage a console. g. micro) in my REST API. For example, give "postgres" as the command line argument, and pg_md5 displays md5-hashed text on its standard output. Hope this helps. query internally. query(/* etc, etc */) done() }) // pool shutdown pool. I am not sure what my mistake is. log just fine, but cannot find a way to return the result so that it is accessible Mar 28, 2019 · If you are using the await pool. Contribute to brianc/node-pg-pool development by creating an account on GitHub. Connecting to the database using the node-postgres module can be done in two ways - using a single client and using a To encrypt your password into md5 hash format, use pg_md5 command, which is installed as a part of pgpool-II executables. tablename; pool. If an identical SELECTs comes in, Pgpool-II returns the value from cache. e. log(res. Mar 6, 2020 · One of the options is to use a single client. It was also confirmed that the same SQL query can be executed directly on PostgreSQL without any issues. May 29, 2018 · However, managing two database endpoints, one for reads and one for writes, adds complexity to the application. pgpool-II is a middle ware that sits between PostgreSQL servers and a PostgreSQL database client. Thanks! Introduction The pgpool Administration Tool is management tool of pgpool. Feb 8, 2017 · I am trying to create a method for a synchronous query. that is, make a REST call which should do a postgres db query and return data. Pgpool-II のSELECTクエリの負荷分散はrawモードを除くすべてのクラスタリングモードで動作します。 有効時、 Pgpool-II は更新を伴うクエリを、ストリーミングレプリケーションモード、ロジカルレプリケーションモード、Slonyモードではプライマリノードに、レプリケーションモード Jun 20, 2017 · i am using nodejs as my REST api host. * Scenario: A reporting application generates the same statistical data frequently, leading to repeated query execution. If not just use my answer : Sep 14, 2017 · pg-pool only implements the pool itself + the querying interface. js for postgresql using pg and pg-native for serverless app. I need to test the method by mocking the database. pool = pool;, so you must call the pool propriety like this var pool = require(". Jul 30, 2020 · Note that I got this working with a different kind of query: pool. query right now). Apr 17, 2018 · No – pgpool does not analyze the weight of statements – it was a DBA with her settings again! The settings (see the lb_weight attribute) reconciles with actual query destination targets. type QueryReducerArray = [string, any[], number]; export function Mar 5, 2021 · I've tried various combinations of parameters when creating the pool, including having a keepalive: true, and none of it seems to make pg-pool actually pool connections. 5. pg_md5 takes text as a command line argument, and displays its md5-hashed text. Feb 29, 2024 · What "pool" means in Pgpool-II? By Tatsuo Ishii (2021/2/6) Various Ways to Retrieve Pgpool-II's Statistics By Bo Peng (2021/1/31) Query Load Balancing in Pgpool-II By Bo Peng (2020/12/29) Timeouts in Pgpool-II connections By Tatsuo Ishii (2020/12/27) Deploy Pgpool-II on Kubernetes to Achieve Query Load Balancing and Monitoring By Bo Peng (2020 5. As shown in the figure below, in our simple experiment, the response time of a repeating SELECT query improved by 86% with around 20% degradation in first time execution of cacheable queries, which seems an acceptable trade-off for workloads with often repeating Jan 12, 2020 · When I do Pool. The `pg. By no means am I suggesting that pool. conf's format. 2. Mar 24, 2022 · Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Often we only need to run a single query on the database, so as convenience the pool has a method to run a query on the first available idle client and return its result. body. query('SELECT * FROM customers WHERE licensenumber = $1 AND phone = $2 ORDER BY id ASC LIMIT 1 ', [Licensenumber,phone], (error, result) =&gt; { if Feb 12, 2021 · const allScores = await pool. Relation Cache 7. Aug 15, 2019 · In our previous blog post, we showed how the performance of repeating SELECT queries can be improved by leveraging an external cache. From here, you can learn how to install, setup, and run parallel queries or do replication using pgpool-II. rowCount value) but result. I'm trying to execute a query like this: SELECT * FROM table WHERE id IN (1,2,3,4) The problem is that the list of ids I want to filter against is not constant and needs to be different at every LOG: pid 13756: pool_add_temp_query_cache: data size exceeds memqcache_maxcache. You need to delete the cache data from the cache table or restart pgpool-II with -c (delete cache) option. zhfc rjw ffd ycxk jtrql rfve zrvzzq wchk yzzbr sxth