From: Dimitrios Apostolou <jimis@gmx.net>
To: pgsql-general@lists.postgresql.org
Subject: Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches
Date: Tue, 31 Jan 2023 16:16:16 +0100 (CET)
Message-ID: <505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net> (raw)
In-Reply-To: <b847d458-5a03-718e-5467-422fc0e51004@gmx.net>
References: <b847d458-5a03-718e-5467-422fc0e51004@gmx.net>
I managed to double-paste different subset of my settings. FWIW all of
them are true for all the experiments. Sorry for the confusion.
On Tue, 31 Jan 2023, Dimitrios Apostolou wrote:
> Other postgres settings:
>
> shared_buffers = 1024MB
> effective_io_concurrency = 0
> wal_compression = zstd
> wal_recycle = on
> min_wal_size = 1GB
> max_wal_size = 10GB
> checkpoint_timeout = 15min
[...]
> Relevant settings:
>
> synchronous_commit = off
> wal_recycle = on
> min_wal_size = 1GB
> max_wal_size = 10GB
> track_io_timing = on
> track_wal_io_timing = on
> wal_compression = zstd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: jimis@gmx.net
Subject: Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches
In-Reply-To: <505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net>
References: <b847d458-5a03-718e-5467-422fc0e51004@gmx.net> <505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox