Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHPCx-0073x8-Qu for pgsql-general@arkaria.postgresql.org; Wed, 12 Jun 2024 14:44:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sHPCw-001FKQ-9E for pgsql-general@arkaria.postgresql.org; Wed, 12 Jun 2024 14:44:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHPCv-001FKH-RS for pgsql-general@lists.postgresql.org; Wed, 12 Jun 2024 14:44:14 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHPCp-000yAM-KI for pgsql-general@lists.postgresql.org; Wed, 12 Jun 2024 14:44:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1718203445; x=1718808245; i=shammat@gmx.net; bh=tKqSJiKrI9NK5cP6bdlsX/1qgIdAk6eH+kDcItMJoSk=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=fzf+WQrwkuEFDDMY8CD8g7al07DBVBOtbXbYl2LB+c0lhUfETweNV72hPObdDyzj IZqkHhwYFYtPnIGDgARogay9FN9q6mEmXF7xd1GG/tVoI1czpyiw0MFz9vEhMmTtG PZ4NfW7BxbjjZVkJvUmHnKXACkR87Alw0WgnZ5yjiCAfL1dMVt05LPcFikGnoF/Mz B+jANyAh7yhmwpn40UshOejffS8VzHsJvnNkTEW/9huVOv7hRWMFXzqVSwLOOrz+H s/gpwXcBzGFoC46PWHJy+Cri5q8Z8dRgd5ofTObBJG8lhs/FGdcsfae1WUjQ6RgYD W4AldjZvCJmQjaUDfA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.152] ([185.40.248.10]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MrQEx-1snO9y2CZT-00bivu for ; Wed, 12 Jun 2024 16:44:05 +0200 Message-ID: Date: Wed, 12 Jun 2024 16:44:05 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: postgres table statistics To: pgsql-general@lists.postgresql.org References: <1204595253.3110982.1718178463166.ref@mail.yahoo.com> <1204595253.3110982.1718178463166@mail.yahoo.com> Content-Language: de-DE From: Shammat In-Reply-To: <1204595253.3110982.1718178463166@mail.yahoo.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Az3XoElq3+lBfcisrdv4YEq+1+EmMA6D8DKY2Ye4sFp4Uqlae0e Woo3cVpx534cfjCADJ9NxcxW0yD/FoJSDcNOQTbK3LiiAgg2P01c06oXssGX027lTmXxrJa /TDOgI0yl71QtL4qiU5+udn/d0xQ4MQoNqDdBwx7IN61k8DJ8Ke8psJ9gpz5q6PgvNQK95Q 0VYbCAWVNgiVIrKmJhLHg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:KpnaiCa/3ss=;7BRXo2lWT2Y4M+jqGSKf0gNA8sT 0hVzKCiuEE5x5OG8Z+foeC7U+X8x8SbWEHkdJpA+yVAkX8fPFYD/GNGeqm9298IyIFx1rb2SV TneBVxgY7Gjjrv6UNJkJVifubvvcgsARJ9mUzqZnxsA/7dD/sh4FgMDWYq8buv5JGGAs0x9eK xUtJG2aRdnM/Ql3W49VZMRzO7AXg4eFBWg3vBxkcWz6fIM0onWbm+tG4jiN4Y8MKXw3cgTFkt wud2knRFTfgDKx+FXPZhaFtagZwWoeqRA8bG2Ej/fulRWrz3yLG51CmVcODMc8ksQH2NRuwoG 3I0QsI2hEmNjqyCZ8WUWerkw30Jp3MsmWp3C69FMyQtf9CeY4+PUKKx0LPOkaKwvAcy2Mqtwv MsWSAwcawCbxyhGBqpfrj9DeQNgB6F7CCzVji3Acek9QLxmp/np/lWaOExsuu+Ou437IFT+og 8HAiWdVuY9rveKNtwQAOpimQktEmIfP9MCkud4kIqRfww19MVYQtPPZI3KbdPqWB8C9okqXtW ZL7F5Zg7HoPH7165z+mUV6n+C4Vs5Pan0LqZUnPEC3LVJkjF2EIL1ZcLzpecJZoZy1OjrSzqq JvLtYn1BaZC9au5QqXFGvN0kcYlTn0wPFfrFoPzzAIavqT5ovMRQgCNDHShaZt1RcIF6rm0Tq 1tU/oDHQ3BTTmbIOELPaTKsVlN8R72+ifASOc7+Igm2w0LNgmKeYkey96mGuTcN9rPYWNUeyE wY7cPHPfr7ppeysOG48pGqNStFjoAVnvCGAbkkWQt9Bx9VT8qXU97KyO4K7VSUSsSOigmNY/i LqstoPLfPNO7sYpIRSGPLfBmCTF6BKEVYuLof17QjEEKc= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Chandy G schrieb am 12.06.2024 um 09:47: > Eventhough pg jdbc driver provides a way to set fetch size to tune > the driver to achieve better throughput, the JVM fails at the driver > level when records of large size (say 200mb each) flows through. > this forces to reduce the fetch size (if were to operate at a fixed > Xmx setting of client jvm). Did you try the driver's "adaptive fetch" feature? https://jdbc.postgresql.org/documentation/use/#connection-parameters