Re: Why could different data in a table be processed with different performance?

From: Vladimir Ryabtsev <greatvovan(at)gmail(dot)com>
To: f(dot)pardi(at)portavita(dot)eu
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Why could different data in a table be processed with different performance?
Date: 2018-09-28 19:51:03
Message-ID: CAMqTPqnr+H+Bus0hia7ZsgNJUnOrr4Hmp1AqRFvnSKJyWPvvmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> That means, if your block size was bigger, then you would have bigger
space allocated for one single record.
But if I INSERT second, third ... hundredth record in the table, the size
remains 8K.
So my point is that if one decides to increase block size, increasing
storage space is not so significant, because it does not set minimum
storage unit for a row.

vlad

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daulat Ram 2018-09-30 23:36:48 psql: fe_sendauth: no password supplied
Previous Message Fabio Pardi 2018-09-28 14:15:47 Re: Why could different data in a table be processed with different performance?