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 1rqd7W-00DOUG-6G for pgsql-general@arkaria.postgresql.org; Sat, 30 Mar 2024 18:07:58 +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 1rqd7U-009tas-9K for pgsql-general@arkaria.postgresql.org; Sat, 30 Mar 2024 18:07:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rqd7T-009tak-Sd for pgsql-general@lists.postgresql.org; Sat, 30 Mar 2024 18:07:55 +0000 Received: from mail-ed1-x52f.google.com ([2a00:1450:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rqd7R-007gLY-CZ for pgsql-general@lists.postgresql.org; Sat, 30 Mar 2024 18:07:55 +0000 Received: by mail-ed1-x52f.google.com with SMTP id 4fb4d7f45d1cf-55a179f5fa1so3404018a12.0 for ; Sat, 30 Mar 2024 11:07:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1711822070; x=1712426870; darn=lists.postgresql.org; h=cc:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=gkjTxVcYECqbfkfwEukSeazohE9109fi6k+Ll8zRCfI=; b=IiteG3cbUH9yyUtiVO6lD3wkrcQW39j6AGrE2mo9S3WbJnR/Q4iML40C/MwFxihhdt sZpj5HDiY75NbT/Maeotz6hVGLL3Ang7LQBOLhKVfUnCJg1J0iIjrI5EuEMXp1YRzwy3 mNhsFLS/uaJVjyZ4/9unOalPcKkZBZWWSc46/fwJnahrTbxUglXB22kqDx5qNpnGEuNs BjhSdQSwgmSpIx6w9/WjznOuUVeuJmE5VzSajNmR+Sdh+KpqPyycH+5AEUikIXtEfr76 xBJPgVycEJZUaYZLxeELvuni3nCtOt/Lx9H9NT7/fBOQoEN71ANbOkl840Zdn9OOYs9S JRZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1711822070; x=1712426870; h=cc:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=gkjTxVcYECqbfkfwEukSeazohE9109fi6k+Ll8zRCfI=; b=h5Ozw/zN6fsQQgqYJTLPr5vWXV+sw2xKKStDw6O3Mv66hv5sZFtHXtY8PpcsO3gIVz 2StCga5Y2qSnxEdeZe0B6XsGwLO0/f2y2kNWlnIEm8hC6hebQ7hGPG707cfbX7eE4045 9Bi+ZDqc612IDyop0Bao07Dh6MO9M00KKb1WlgrZDv0ebpnFOkbHbEeE5Xp7pEjIoo2v hYX19T4NJv1ArcALQHNYEEO9x0IrehWbfXNe6namDAzoslaHTuMmsz9k4W2BoF0wZjHO xJdJC33aUW7tFVisjsYPIatJp5XKABjT5uPfsuT0dgEE8KmdNGWD6b+bUPv0juLtw8Xh KlnQ== X-Gm-Message-State: AOJu0Yz29hu9lrPXwNCrMUkbCwOdvS/2G5gA35mzTAdNIL6dYIJfQ+QR kKPlmDpR2gYmh4TfYd6Xv3+6FKfj3NsfQdY7asbUhMqGl37z//HBJM1LYlezszNCdgOeIMetb9h 7PT4hE4h+7/Ofem9ujFQyiVd4+HpKXrq/YJW4f706 X-Google-Smtp-Source: AGHT+IEvw93XdgPboFws/Mi1SKNSb/W6YGqXMBONMoIFzTnRd/qKYPZeVWhCq2XBXgoxiCOFOR2ebljIXlGhqO601hY= X-Received: by 2002:a05:6402:348a:b0:568:a4b6:9828 with SMTP id v10-20020a056402348a00b00568a4b69828mr5026540edc.30.1711822070421; Sat, 30 Mar 2024 11:07:50 -0700 (PDT) MIME-Version: 1.0 References: <98df75338710b3cb63817f3db532cdf6@postgresql.org> In-Reply-To: From: Alexander Farber Date: Sat, 30 Mar 2024 19:07:38 +0100 Message-ID: Subject: Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000006d26900614e4a280" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006d26900614e4a280 Content-Type: text/plain; charset="UTF-8" Turning fsync = off has resulted in no noticable build time reduction for my Dockerfile with OSM Europe data, but still thank you for the suggestion! > --0000000000006d26900614e4a280 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Turning fsync =3D off has resulted in no noticable bu= ild time reduction for my Dockerfile with OSM Europe data, but still thank = you for the suggestion!
--0000000000006d26900614e4a280--