Search Postgresql Archives

Re: Column Tetris Automatisation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

2017-01-15 10:58 GMT+01:00 Nicolas Paris <niparisco@xxxxxxxxx>:
Hello,

In postgresl order of columns does have an non negligeable impact on table size[1].
Table are in many cases dynamic, and new fields can appear in the database life.
I suspect re-ordering columns based on types would be an automatisable task would be feaseable such:

```
reorderTableWithTetrisAlgo(table)
return reordered_table
```

Moreover, most client code should not be dependent on column order. Then a TETRIS option
in VACUUM FULL would be usefull for many users.

lot of applications depends on column order - so this option is pretty dangerous.

Regards

Pavel
 

```
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [TETRIS] [ table ]
```

Does that makes sens ?

Thanks,

[1] https://developing.enectiva.cz/2016/05/15/postgres-column-tetris/


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux