Re: postgres in swap space

On Mon, Nov 17, 2025 at 09:49:59PM +0100, Laurenz Albe wrote: > On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > > Can someone point me to any doc describing why and how much space postgres > > uses on the swap of a debian machine ? > > it's an old postgres 10, because it is used by a produ

Re: postgres in swap space

On Mon, Nov 17, 2025 at 4:41 PM Adrian Klaver wrote: > On 11/17/25 13:12, Ron Johnson wrote: > > On Mon, Nov 17, 2025 at 3:50 PM Laurenz Albe > > wrote: > > > > On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > > > Can someone point me to any doc d

Re: failure to drop table due to pg_temp_7 schema

On 11/17/25 14:08, Peter 'PMc' Much wrote: On Sat, Nov 15, 2025 at 02:10:49PM -0800, Adrian Klaver wrote: ! Where is delightfulness short changed in?: ! ! https://www.postgresql.org/docs/18/release-18.html#RELEASE-18-HIGHLIGHTS Oh yes, these are fine things, and I know people will be delighte

Re: failure to drop table due to pg_temp_7 schema

On Sat, Nov 15, 2025 at 02:10:49PM -0800, Adrian Klaver wrote: ! On 11/15/25 12:25, Peter 'PMc' Much wrote: ! > required. So it's a balance. And in recent years, the modernizations ! > often happened to curtate in delightfulness (with PostgreSQL sadly ! > not being an exception). ! ! Where is del

Re: postgres in swap space

On 11/17/25 13:12, Ron Johnson wrote: On Mon, Nov 17, 2025 at 3:50 PM Laurenz Albe > wrote: On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > Can someone point me to any doc describing why and how much space postgres uses on the swap of a debia

Re: postgres in swap space

On Mon, Nov 17, 2025 at 3:50 PM Laurenz Albe wrote: > On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > > Can someone point me to any doc describing why and how much space > postgres uses on the swap of a debian machine ? > > it's an old postgres 10, because it is used by a product for whic

Re: postgres in swap space

On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > Can someone point me to any doc describing why and how much space postgres > uses on the swap of a debian machine ? > it's an old postgres 10, because it is used by a product for which only this > version is certified. > (no comment on that,

Re: postgres in swap space

Putting memory pages to swap is the decision of the linux virtual memory manager not postgres.  If your db machine is swapping, first make sure you have set sensible values for the ram related settings like shared_buffers (25%), effective_cache_size (75%) and work_mem (keep it modest at 4 to 16

Re: postgres in swap space

On Mon, Nov 17, 2025 at 12:25 PM Marc Millas wrote: > hello, > Can someone point me to any doc describing why and how much space postgres > uses on the swap of a debian machine ? > it's an old postgres 10, because it is used by a product for which only > this version is certified. > (no comment o

postgres in swap space

hello, Can someone point me to any doc describing why and how much space postgres uses on the swap of a debian machine ? it's an old postgres 10, because it is used by a product for which only this version is certified. (no comment on that, please) regards Marc MILLAS Senior Architect +3360785033

Re: Redo CREATE DATABASE

On Mon, 2025-11-17 at 09:59 +, COURTAULT Francois wrote: > I am looking to an old document where we (I was not there at that time) setup > a database. > Unfortunately, I was not able to find the CREATE DATABASE instruction used. > It is not in any of our docs☹ > At https://www.postgresql.org/

Re: Redo CREATE DATABASE

On 11/17/25 01:59, COURTAULT Francois wrote: THALES GROUP LIMITED DISTRIBUTION to email recipients Hello everyone, I am looking to an old document where we (I was not there at that time) setup a database. Unfortunately, I was not able to find the CREATE DATABASE instruction used. It is not

Re: Redo CREATE DATABASE

If you had log_statement set to something other than 'none', the create database statement will appear in your database logs. If you don't have it set, today would be a great day to set it to 'ddl'. https://www.postgresql.org/docs/17/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT Cheer

Re: Redo CREATE DATABASE

Hi, On 17/11/2025 10:59, COURTAULT Francois wrote: THALES GROUP LIMITED DISTRIBUTION to email recipients Hello everyone, I am looking to an old document where we (I was not there at that time) setup a database. Unfortunately, I was not able to find the CREATE DATABASE instruction used. It

Redo CREATE DATABASE

THALES GROUP LIMITED DISTRIBUTION to email recipients Hello everyone, I am looking to an old document where we (I was not there at that time) setup a database. Unfortunately, I was not able to find the CREATE DATABASE instruction used. It is not in any of our docs ☹ At https://www.postgresql.or