Re: Reordering the fields in a table

Also, since you are reordering your table, you might want to consider
ordering based on saving some alignment bytes per row since everything
is aligned on an 8 byte boundary.

For instance a table with a smallint, bigint, smallint, int  would use
24 bytes
Reordering like this would save you 8 bytes per row!
smallint, smallint, int, bigint would use 16 bytes

Regards,
Michael Vitale

Google FezaCakir wrote on 4/16/2021 2:34 PM:
> There is no way. You should drop and re-create table with your order.
> Regards.
>
> Cum, 2021-04-16 tarihinde 16:15 +0000 saatinde, Campbell, Lance yazdı:
>>
>> If there is a way to do this please let me know.
>>
>> *PostgreSQL Request*
>>
>> I would love to see an enhancement to PostgreSQL where administrators
>> had some way to reorder the fields in their tables.  As a software
>> developer I can easily write a tool to reorder the fields in a table
>> if there were no foreign keys. But foreign keys throw an enormous
>> hurdle in my way.
>>
>> *Why is this a big deal?*
>>
>> Sixteen years ago when I started working at the University of
>> Illinois I told my boss, “if you give me thirty days I can build a
>> platform that will allow me to cut at least 50% off of the
>> development time of your standard internal web business app.”  I
>> built it.  Today I personally created/manage/develop 17 services that
>> provide over 120 million pages of web content a year.  I can jump
>> into this infrastructure and make a change in an hour or two that
>> would take most people weeks to change.  The one issue that causes me
>> the most grief is the readability of tables.  When you manage 17
>> services where you are continually tweaking the system you find the
>> tables are very unreadable.  New fields are continually added to the
>> bottom of tables. They are just not readable.
>>
>> The most underappreciated elements in software design is the ongoing
>> need to be able to easily read what you are working with.  Table can
>> really become a mess.  It would be the most amazing enhancement to be
>> able to order the fields of any table with a command.  I know today
>> this is probably not a top priority to most developers and DBAs. 
>> They work in an environment where one person might work on just one
>> or two services.  But as development strategies change over time more
>> people will be developing software faster and faster. Table field
>> readability will become more important.
>>
>> Thanks,
>>
>> *LANCE CAMPBELL <https://directory.illinois.edu/person/lance>*
>>
>> /Software Architect/
>>
>> Web Services <https://webtools.illinois.edu/>
>>
>> Public Affairs <https://publicaffairs.illinois.edu/>
>>
>> Contact the Webtools Team <https://go.illinois.edu/contactUs>
>>
>> 217.333.0382
>>
>> lance(at)illinois(dot)edu <mailto:lance(at)illinois(dot)edu>
>>
>> /var/folders/wp/1f6l7hw95y718z976kgnl5f9kr5rtc/T/com.microsoft.Outlook/WebArchiveCopyPasteTempFiles/signature_logo.png
>> <http://illinois.edu/>
>>
>> /Under the Illinois Freedom of Information Act any written
>> communication to or from university employees regarding university
>> business is a public record and may be subject to public disclosure./
>>
>