Re: Why could different data in a table be processed with different performance? - Mailing list pgsql-performance

From Vladimir Ryabtsev
Subject Re: Why could different data in a table be processed with different performance?
Date
Msg-id CAMqTPqnr+H+Bus0hia7ZsgNJUnOrr4Hmp1AqRFvnSKJyWPvvmw@mail.gmail.com
Whole thread Raw
In response to Re: Why could different data in a table be processed with differentperformance?  (Fabio Pardi <f.pardi@portavita.eu>)
Responses Re: Why could different data in a table be processed with differentperformance?  (Fabio Pardi <f.pardi@portavita.eu>)
List 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

pgsql-performance by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: Why could different data in a table be processed with differentperformance?
Next
From: Daulat Ram
Date:
Subject: psql: fe_sendauth: no password supplied