pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (11+ messages)  latest in thread

Message-ID: <505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net>
Permalink:  ../505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net/
Also on:    postgresql.org/message-id/505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net

 · 

reply

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