Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches

From: Dimitrios Apostolou <jimis(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches
Date: 2023-01-31 15:16:16
Message-ID: 505fa76e-e68f-90de-0506-3ebdab5e5a61@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-01-31 15:20:36 Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches
Previous Message Dimitrios Apostolou 2023-01-31 15:07:31 SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches