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

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: Why could different data in a table be processed with different performance?
Дата
Msg-id CAMqTPqnr+H+Bus0hia7ZsgNJUnOrr4Hmp1AqRFvnSKJyWPvvmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why could different data in a table be processed with differentperformance?  (Fabio Pardi <f.pardi@portavita.eu>)
Ответы Re: Why could different data in a table be processed with differentperformance?  (Fabio Pardi <f.pardi@portavita.eu>)
Список 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 по дате отправления:

Предыдущее
От: Fabio Pardi
Дата:
Сообщение: Re: Why could different data in a table be processed with differentperformance?
Следующее
От: Daulat Ram
Дата:
Сообщение: psql: fe_sendauth: no password supplied