Re: Does PostgreSQL cache all columns of a table after SELECT?
От
Tim Schwenke
Тема
Re: Does PostgreSQL cache all columns of a table after SELECT?
Дата
Msg-id
1888c20926e.d2fc55ae8791.8729366224157085719@trallnag.com
Ответ на
Re: Does PostgreSQL cache all columns of a table after SELECT? (David G. Johnston)
Список
Дерево обсуждения
Does PostgreSQL cache all columns of a table after SELECT? Tim Schwenke <tim@trallnag.com>
Re: Does PostgreSQL cache all columns of a table after SELECT? William Alves Da Silva <william_silva@unochapeco.edu.br>
Re: Does PostgreSQL cache all columns of a table after SELECT? Tim Schwenke <tim@trallnag.com>
Re: Does PostgreSQL cache all columns of a table after SELECT? Laurenz Albe <laurenz.albe@cybertec.at>
Re: Does PostgreSQL cache all columns of a table after SELECT? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Does PostgreSQL cache all columns of a table after SELECT? Tim Schwenke <tim@trallnag.com>
Re: Does PostgreSQL cache all columns of a table after SELECT? Tim Schwenke <tim@trallnag.com>
Re: Does PostgreSQL cache all columns of a table after SELECT? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Does PostgreSQL cache all columns of a table after SELECT? Tim Schwenke <tim@trallnag.com>
Thanks, you all helped me
---- On Mon, 05 Jun 2023 16:26:08 +0200 David G. Johnston <david.g.johnston@gmail.com> wrote ---
On Mon, Jun 5, 2023, 06:17 Tim Schwenke <tim@trallnag.com> wrote:Hello David,
from what I understand, in PostgreSQL, tables are stored in one or more files called segments. There is no separation by columns.
https://www.postgresql.org/docs/8.1/storage.html
This means if I select a single column from a table the first time, the full file / segment is read and put into page cache if there is enough space.Pages are subsegment.You may also wish to take care to notice the version of documentation pages you look at and reference. 8.1 is long past its expiration date.David J.
В списке pgsql-novice по дате отправления
От: David G. Johnston
Дата:
От: Tim Schwenke
Дата:
