Fascinating that within a section or prose about indexing within MiddleMarch (set in 1829 to 1832 and published in 1871-1872), George Eliot compares a character's distinguished appearance to that of John Locke!

Mr. Brooke asks for advice about arranging notes as he has tried pigeon holes but has the common issue of multiple storage and can't remember under which letter he's filed his particular note. Mr. Casaubon indicates that he uses pigeon-holes.

Dorothea Brooke mentions that she knows how to properly index papers so that they might be searched for and found later. She is likely aware of John Locke's indexing method from 1685 (or in English in 1706) and in the same scene compares Mr. Casaubon's appearance to Locke.

Viable backups

I suddenly have a new respect for write-once-read-many (WORM) block storage like AWS’ Object Lock: https://aws.amazon.com/blogs/storage/protecting-data-with-amazon-s3-object-lock/

reply to oxytonic on 2023-01-08 at https://hypothes.is/a/8QdgetQOEe2XG6u5i9iAHQ

In my experience, alternating alphanumeric codes give you the "gist" of the original context. Purely with reference to my rough outline, my notecard "3516/b" implies psychology (3XXX), cognition (35XX), and memory (351X). Even the single slash implies a level of abstraction and/or specificity.

But it's not enough because it runs the risk of locking you in. Forward links on the card (or forward links to the card!) offer comparable if not competitive recontextualization, which is most likely what Luhmann means by "multiple storage".

Caution: My note here has some significant missing context which results from significant additional research.

The primary issue with analog slip boxes, particularly in academic research of Luhmann's day, was one of multiple storage. No one else I'm aware of prior to his time used Luhmann's filing scheme (and very few after until about 2013). Instead most filed multiple copies of their notes under category headings like "psychology", "cognition", and "memory" (to use your example) so that those ideas would be readily available when they came to work on their ideas relating to cognition, for example. This involved a tremendous amount of copying work. (For reference, see Heyde, Johannes Erich. Technik des wissenschaftlichen Arbeitens: zeitgemässe Mittel und Verfahrungsweisen. Junker und Dünnhaupt, 1931. which is the handbook which Luhmann used to scaffold his method.) It was this copying and filing under multiple categories which was commonly referred to as multiple storage. Many academics got around it by hiring assistants or secretaries who would do this duplicative work and filing on their behalf; Luhmann didn't have this additional help and it may have been a portion of the pressure for the evolution of his method.

Instead Luhmann used branching and cross-indexing his ideas along with regular use and familiarity of the space within his boxes. While his zettelkasten may seem on the surface to be done by category, the way you suggest, it definitely is not. Some of this appearance is suggested by editorial decisions made by the curators of his digital archive and, in larger part, by Scott Scheper who (sadly in my opinion) recommends using the Academic Outline of Disciplines as top level categories a practice which heavily belies some of what Luhmann was doing. While Luhmann was inspired by the Dewey Decimal System, he wasn't using the parts of it that equated numbers with topics, in part because he didn't need to and it would have been counterproductive to his ultimate method—specifically causing him to deal with multiple storage. Modern (digital) database theory and practice allows some note takers an easier way around this problem.

For more on this see: - https://boffosocko.com/2022/10/27/thoughts-on-zettelkasten-numbering-systems/ - https://boffosocko.com/2023/01/19/on-the-interdisciplinarity-of-zettelkasten-card-numbering-topical-headings-and-indices/

• for: thermal battery storage

• for: energy storage, battery storage, pumped hydro, PSH
• description
  • Recent studies indicate that pumped hydro can play a significant role in energy storage for a 100% renewable energy system

• for: pumped hydro storage capacity, pumped hydro, PSH
• paraphrase
  • According to the International Hydropower Association, or IHA,
    • a facility with:
      • two reservoirs roughly the size of two Olympic swimming pools,
      • a 500-metre height difference between them,
    • would have
      • an energy capacity of about three and a half megawatt hours and
      • they last for decades,

• for: pumped storage hydro, pumped hydro, pumped storage, PSH, ANU study, ANU PSH
• stats
  • 23 million gigawatt-hours of global PSH
  • sites in the study were
    • geographically and topographically feasible
    • non-urban areas
    • environmentally protected areas
  • this is 100x more than is needed for a global 100% renewable energy storage system
  • so even if only 1% of sites were useful, that is enough to provide all we need for global 100% renewable energy storage

• for: storage requirements per million, grid storage
• stats
  • storage requirements for one hundred percent renewables is about
    • one gigawatt for every million people
    • twenty hours of energy storage per person
    • 20 gigawatts including buffer for every million people
    • 500 gigawatts for Australia, with storage potential 300x that figure

• for: NREL, PSH, grid storage, grid storage - alternative, grid storage - pumped hydro, pumped hydro, renewable energy - storage, pumped storage hydro,
• the new NREL study shows the potential for pumped storage to provide for all the grid storage needs

https://push.boox.com/#/login

Physical vs Digital Note Systems

There's a lot of useful detail hiding in this 15 minutes as an overview, but nothing new/interesting for me.

I will say that he completely misses a lot of the subtleties of indexing and multiple storage within the analog space, but it's likely because he's not done it personally or doesn't have enough experience there.

Mark Dykeman indicates that at regular work, he fills up a 180 page notebook and at the relatively steep cost of notebooks, he's paying $1-2 a day for paper.

This naturally brings up the idea of what it might cost per day in index cards for some zettlers' practices. I've already got some notes on price of storage...

As a rough calculation, despite most of my note taking being done digitally, I'm going through a pack of 500 Oxford cards at $12.87 every 5 months at my current pace. This is $0.02574 per card and 5 months is roughly 150 days. My current card cost per day is: $0.02574/card * 500 cards / (150 days) = $12.78/150 days = $0.0858 per day which is far better than $2/day.

Though if I had an all-physical card habit, I would be using quite a bit more.

On July 3, 2022 I was at 10,099 annotations and today May 11, 2023 I'm at 15,259 annotations. At one annotation per card that's 5,160 cards in the span of 312 days giving me a cost of $0.02574/card * 5,160 cards / 312 days = $0.421 per day or an average of $153.75 per year averaging 6,036 cards per year.

(Note that this doesn't also include the average of three physical cards a day I'm using in addition, so the total would be slightly higher.)

Index cards are thus, quite a bit cheaper a habit than fine stationery notebooks.

reply to rogerscrafford at tk

Fine furniture comes at a fine price. 🗃️🤩 I suspect that it won't sell for quite a while and one could potentially make an offer at a fraction of that to take it off their hands. It might bear considering that if one had a practice large enough to fill half or more, then that price probably wouldn't seem too steep for the long term security and value of the contents.

On a price per card of storage for some of the cheaper cardboard or metal boxes you're going to pay about $0.02-0.03 per card, but you'd need about 14 of those to equal this and those aren't always easy to stack and access regularly. With this, even at the full $1,900, you're looking at storage costs of $0.10/card, but you've got a lot more ease of use which will save you a lot of time and headache as more than adequate compensation, particularly if you're regularly using the approximately 20,400 index cards it would hold. Not everyone has the same esthetic, but I suspect that most would find that this will look a lot nicer in your office than 14 cheap cardboard boxes. That many index cards even at discount rates are going to cost you about $825 just in cards much less beautiful, convenient, and highly usable storage.

Even for some of the more prolific zettelkasten users, this sort of storage is about 20 years of use and if you compare it with $96/year for Notion or $130/year for Evernote, you're probably on par for cost either way, but at least with the wooden option, you don't have to worry about your note storage provider going out of business a few years down the line. Even if you go the "free" Obsidian route, with computers/storage/backups over time, you're probably not going to come out ahead in the long run. It's not all apples to apples comparison and there are differences in some of the affordances, but on balance and put into some perspective, it's probably not the steep investment it may seem.

And as an added bonus, while you're slowly filling up drawers, as a writer you might appreciate the slowly decreasing wine/whiskey bottle storage over time? A 5 x 8 drawer ought to fit three bottles of wine or as many fifths of Scotch. It'll definitely accommodate a couple of magnums of Jack Daniels. 🥃🍸🍷My experience also tells me that an old fashioned glass can make a convenient following block in card index boxes.

Correcting a text within a digital archive or database allows the change to propagate to all portions of the collection compared with a physical card index which has the hurdle of multiple storage and requires manual changes on all of the associated copies.

This sort of affordance can be seen in more modern note taking tools like Obsidian which does this sort of work with global search and replace of double bracketed words which change everywhere in the collection.

Once made, the initial note excerpts were copied 40 times using a lithography process. Then each word in the original slip was underlined in red on respective copies to be filed away alphabetically. At the top right corner of each slip was written down the phonetic sound of the rubricated word's Egyptian transcription. Within the collection certain special words were also separated for the names of people, kings, gods, and places to allow for additional study.

Talk about a problem of multiple storage!!

Seems like from a historical perspective hierarchical databases were more prevalent in the 1960s and relational databases didn't exist until the 1970s. (check references for this historically)

Of course one must consider that within a card index or zettelkasten the ideas of both could have co-existed in essence even if they weren't named as such. Some of the business use cases as early as 1903 (earlier?) would have shown the idea of multiple storage and relational database usage. Beatrice Webb's usage of her notes in a database-like way may have indicated this as well.

9/8b2 "Multiple storage" as a necessity of<br /> storage of complex (complex<br /> evaluating) information.

Fascinating to see the English phrase "multiple storage" pop up in Luhmann's ZKII section on Zettelkasten.

This note is undated, though being in ZKII likely occurred more than a decade after he'd started his practice. One must wonder where he pulled the source for the English phrase rather than using a German one? Does the idea appear in Heyde? It certainly would have been an emerging question within systems theory and potentially computer science ideas which Luhmann would have had access to.

• Link to https://hypothes.is/a/WtB2AqmlEe2wvCsB5ZyL5A on multiple storage affordances

Keeping one's fleeting notes separate from their permanent notes can be useful for managing the idea of clutter.

Luhmann generally did this by keeping things in different boxes. Modern academics may use different digital applications (Zotero/Obsidian, Hypothes.is/Zettlr, etc.as examples) for each as long as there is some reasonable dovetail between the two for data transfer when necessary.

Most veteran note takers will advise against importing old notes into a new digital space for the extra amount of administrative overhead and refactoring it can create.

Often old notes may be: - well assimilated into your memory already - poorly sourced or require lots of work and refactoring to use or reuse them - become a time suck trying to make them "perfect"

Better advice is potentially pull them into your system in a different spot so they're searchable and potentially linkable/usable as you need them. If this seems like excessive work, and it very well may be, then just pull in individual notes as you need or remember them.

With any luck the old notes are easily searchable/findable in whichever old system they happen to be in, so they're still accessible.

I'll note here the conflicting definitions of multiple storage in my tags to mean: - storing a single note under multiple subject headings or index terms - storing notes in various different (uncentralized locations), so having multiple different zettelkasten at home/office, storing some notes in social media locations, in various notebooks, etc. This means you have to search across multiple different interfaces to find the thing you're looking at.

I should create a new term to distinguish these two, but for now they're reasonably different within their own contexts that it's not a big problem unless one or the other scales.

Related here is the horcrux problem of note taking or even social media. The mental friction of where did I put that thing? As a result, it's best to put it all in one place.

How can you build on a single foundation if you're in multiple locations? The primary (only?) benefit of multiple locations is redundancy in case of loss.

Ryan Holiday and Robert Greene are counter examples, though Greene's books are distinct projects generally while Holiday's work has a lot of overlap.

Should You Have One Zettelkasten or Many?<br /> by Christian Tietze

Within the history of personal knowledge management, one was often faced with where to store their notes so that it would be easy to find and use them again. Often this was done using slip methods by means of "multiple storage" by making multiple copies and filing them under various headings. This copying process was onerous and breaks the modern database principle "don't repeat yourself" (DRY).

Alternate means of doing this include storing it in one place and then linking that location to multiple subject headings in an index, though this may cause issues of remembering which subject heading when there are many appropriate potential synonyms.

Modern digital methods allow one to store a note in one location and refer to it in multiple ways electronically as well as with aliases.

https://www.reddit.com/r/antinet/comments/10xls6m/does_anyone_ever_get_frustrated/

Categorizing ideas (and or indexing them for search) can be useful for quick bulk storage, but the additional work of linking ideas to each other with in a Luhmann-esque zettelkasten can be more useful in the long term in developing ideas.

Storage by category means that ideas aren't immediately developed explicitly, but it means that that work is pushed until some later time at which the connections must be made to turn them into longer works (articles, papers, essays, books, etc.)

Aquathermie Rekentool

Energy Storage Cost and Performance Database. U.S. Department of Energy

How can we better thing of card indexes as positive feedback mechanisms? Will describes it as the "Great Wheel of Positive Feedback" which reminds me a bit of flywheels for storing energy for later use.

https://www.target.com/p/6qt-clear-storage-box-white-room-essentials-8482/-/A-80162146

6qt Clear Storage Box White - Room Essentials™<br /> Outside Dimensions: 13 1/2" x 8 1/8" x 4 5/8"<br /> Interior Dimensions at bottom: 11 1/2" x 6 3/8" x 4 3/8"<br /> Ideal for a variety of basic and lightweight storage needs, for use throughout the home<br /> Opaque lid snaps firmly onto the base and provides a grip for easy lifting<br /> Clear base allows contents to easily be viewed and located<br /> Indexed lids allow same size storage boxes to neatly stack upon each other<br /> BPA-free and phthalate-free<br /> Proudly made in the USA

Specifications<br /> Closure Type: Snap<br /> Used For: Organizing<br /> Capacity (Volume): 6 Quart<br /> Features: Portable, Lidded, Nesting, Stackable<br /> Assembly Details: No Assembly Required<br /> Primary item stored: Universal Storage<br /> Material: Plastic<br /> Care & Cleaning: Spot or Wipe Clean<br /> TCIN: 80162146<br /> UPC: 073149215284<br /> Item Number (DPCI): 002-02-9534<br /> Origin: Made in the USA<br /> Description<br /> Organize, sort and contain! The Room Essentials 6 Quart Storage Box is ideal for a variety of basic and lightweight household storage needs, helping to keep your living spaces neat. The clear base allows contents to be easily identified at a glance, while the opaque lid snaps firmly onto the base to keep contents contained and secure. Stack same size containers on top of each other for efficient use of vertical storage space. When storing items away, use good judgment and don’t overload them or stack them too high; be mindful of the weight in each box and place the heaviest box on the bottom. This storage box is ideal for sorting and storing shoes, accessories, crafts and other small items around the home and fits conveniently on 16" wire closet shelving, bringing order to closets. The overall assembled dimensions of this item are 13 1/2" L x 8 1/8" W x 4 5/8" H.

Examples of this and similar products in use as a box for zettelkasten: - https://photos.google.com/share/AF1QipN5GmVoIhCwma1czj27bXlVDKIUfbOU3a91dYuPBNZaGsEhcZYllmotxup6OxUHhA?pli=1&key=RlhXMTM0WUpuQ2hlQkdDNzA0S1BmNzVQblo4Ti1n - https://imgur.com/a/rW8TZKt

How is learning defined by Sweller in 2002? (Metiri Group, Cisco Sytems, 2008) The storage of automated schema in long-term memory

What term does Sweller define as the "storage of automated schema in long-term memory"?

Deutsch used flimsy copy paper, much like Niklas Luhmann, and as a result some are on the verge of disintegration through use over time.

The wear of the paper here, however, is indicative of active use over time as well as potential care in use, a useful historical fact.

!- for : global capacity renewable energy storage - this is not realistic

https://www.ebay.com/itm/115477031627?hash=item1ae2f7aacb:g:yUIAAOSwQp1ix3zT

Another example of someone using a library card catalog as wine storage

Someone was apparently using an old library card catalog to store wine bottles!

https://en.wikipedia.org/wiki/Paper_data_storage

https://en.wikipedia.org/wiki/Punched_card

Link to Beatrice Webb's use of note taking methods as a means of data storage, search, and sort in the early 1900s.

```js function formatBytes(bytes, decimals = 2) { if (bytes === 0) return '0 Bytes';

const k = 1024; const dm = decimals < 0 ? 0 : decimals; const sizes = ['Bytes', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB']; const i = Math.floor(Math.log(bytes) / Math.log(k)); return parseFloat((bytes / Math.pow(k, i)).toFixed(dm)) + ' ' + sizes[i]; } ```

A card index can be a massive boon to a writer as a well-indexed one, in particular, will save massive amounts of time which might otherwise be spent searching for quotes or ideas that they know they know, but can't easily recreate.

Regardless of what sort of physical instantiation one's notes may take, a workable storage option for them is necessary whether it is a simple box, a shelving system, a curiosity cabinet, a flat file, or even an entire room itself.

The public Indyweb is eminently designed as a public space for holding deep, continuous, asynchronous conversations with provenance. That is, if the partcipant consents to public conversation, ideas can be publicly tracked. Whoever reads your public ideas can be traced.and this paper trail is immutably stored, allowing anyone to see the evolution of ideas in real time.

In theory, this does away with the need for patents and copyrights, as all ideas are traceable to the contributors and each contribution is also known. This allows for the system to embed crowdsourced microfunding, supporting the best (upvoted) ideas to surface.

Participants in the public Indyweb ecosystem are called Indyviduals and each has their own private data hub called an Indyhub. Since Indyweb is interpersonal computing, each person is the center of their indyweb universe. Through the discoverability built into the Indyweb, anything of immediate salience is surfaced to your private hub. No applications can use your data unless you give exact permission on which data to use and how it shall be used. Each user sets the condition for their data usage. Instead of a user's data stored in silos of servers all over the web as is current practice, any data you generate, in conversation, media or data files is immediately accessible on your own Indyhub.

Indyweb supports symmathesy, the exchange of ideas based on an appropriate epistemological model that reflects how human INTERbeings learn as a dynamic interplay between individual and collective learning. Furthermore, all data that participants choose to share is immutably stored on content addressable web3 storage forever. It is not concentrated on any server but the data is stored on the entire IPFS network:

"IPFS works through content adddressibility. It is a peer-to-peer (p2p) storage network. Content is accessible through peers located anywhere in the world, that might relay information, store it, or do both. IPFS knows how to find what you ask for using its content address rather than its location.

There are three fundamental principles to understanding IPFS:

Unique identification via content addressing Content linking via directed acyclic graphs (DAGs) Content discovery via distributed hash tables (DHTs)" (Source: https://docs.ipfs.io/concepts/how-ipfs-works/)

The privacy, scalability, discoverability, public immutability and provenance of the public Indyweb makes it ideal for supporting hyperconversations that emerge tomorrows collectively emergent solutions. It is based on the principles of thought augmentation developed by computer industry pioneers such as Doug Englebart and Ted Nelson who many decades earlier in their prescience foresaw the need for computing tools to augment thought and provide the ability to form Network Improvement Communities (NIC) to solve a new generation of complex human challenges.

While he's couching it in the computer science milieu of his day, this is not dissimilar to the Llullan combinatorial arts.

It's true that each note taking application may be purpose fit for a particular use, but having a single store for all of your notes is incredibly important for future search and re-discovery. Keeping one's notes across a range of applications is disaster waiting to happen, at least until there is a bigger aggregate search function that can search across multiple platforms.

Like pumped hydro with rocks

Guarascio, F. (2022, January 14). Poorer nations reject over 100 mln COVID-19 vaccine doses as many near expiry. Reuters. https://www.reuters.com/business/healthcare-pharmaceuticals/more-than-100-million-covid-19-vaccines-rejected-by-poorer-nations-dec-unicef-2022-01-13/

Edge Computing: What It Is and Why It Matters0 https://en.itpedia.nl/2021/12/29/edge-computing-what-it-is-and-why-it-matters/ Edge computing is an emerging new trend in cloud data storage that improves how we access and process data online. Businesses dealing with high-frequency transactions like banks, social media companies, and online gaming operators may benefit from edge computing.

Curiously, and possibly coincidently, the idea of the index card and the invention of the house number co-occur in the same decade and the same town. This creates the potential of abstracting the representation of information and people into numbers for easier access and linking.

The sorting function is also done by mental links from one space to another similar to the method of loci in Western culture. cross reference the idea of songlines

pyrus scroll and the sheet of parchment.

Which others is she missing from a mnemonics perspective? I'm impressed that she indicates the khipu, but there are certainly other indigenous methods from oral cultures.

So, it seems to add a layer of indirection, so instead of everyone needing to read off the same bits of a disk, the data is stored in places indexed by the KV store, which allows reads and writes to be spread across a linearly scaling storage layer.

Worth reading the paper to check if this guess is close to reality

Incredible. I may have destroyed my current batch. I'll have to start over. Good thing I only made a moderate amount.

Welcome to Connect Warehouse Storage Solutions. We are experts in providing professional storage services, including eCommerce warehouse storage solutions, pallet storage, container de-stuffing, and more.

We pride ourselves on delivering safe, secure, and cost-effective eCommerce warehouse storage and industrial storage solutions, and have been doing so for customers around the world for many years. Our expert team of staff is well trained and experienced, and our facility is state of the art.

All in all, we are confident that we understand the complexities of warehouse storage better than anyone, making us your ideal industrial storage solutions partner.

Our Warehouse Commercial Storage Solutions Facility

When you choose Connect, you’re choosing versatility, modernity, and efficiency for your storage requirements. Our brilliant facility features heavy-duty racking, highly trained staff, advanced technology, and onsite security to make sure that all of your goods are safe and sound in a professional environment.

All of this is set up to help ensure maximum safety for your inventory and more control for you, so you have peace of mind every step of the way that your goods are in safe hands.

Within our facility, we provide an eclectic mix of different industrial storage provisions, with something to suit every requirement. Let’s take a look at some of the different kinds of provisions we handle at Connect and see how we can help you with all of your storage needs today.

industrial storage solutions uk

Pallet Storage with Connect Welcome to Connect Pallet Storage. Here at Connect, we provide the best of the best when it comes to pallet storage and have been doing so for national and international customers for a number of years.

​We’ve built up a strong reputation over the years for our attention to detail and beautifully kept, high-quality pallet storage warehouse facility. And it is here where we can help your business thrive, no matter what it is you do or what it is you require when it comes to pallet storage.

Racked Pallet Storage Our pallet storage warehouse features high-quality, durable racked storage for your pallet storage requirements.

We have over 4,500 pallet spaces available in our fully racked warehouse and provide a safe and secure space for your cargo.

pallet storage warehouse

How is it not so surprising that Carl Linnaeus, the creator of a huge taxonomic system, also came up with the idea for index cards in 1760.

How does this fit into the history of the commonplace book and information management? Relationship to the idea of a zettelkasten?

Currently, I am using SharedPreference which is still alright to use. However, there is a better option called DataStore. This allows data to be stored asynchronously.

RESEARCH MORE. What is this? What it's role in memory storage?

I have heard this from several of my sources. This one is a bit more dated than some of the others I've used, so I need to look at something more recent and see if this has changed.

Size: 1.3m x 2m

Bush emphasises the importance of retrieval in the storage of information. He talks about technical limitations, but in this paragraph he stresses that retrieval is made more difficult by the "artificiality of systems of indexing", in other words, our default file-cabinet metaphor for storing information.

Information in such a hierarchical architecture is found by descending down into the hierarchy, and back up again. Moreover, the information we're looking for can only be in one place at a time (unless we introduce duplicates).

Having found our item of interest, we need to ascend back up the hierarchy to make our next descent.

Retrieval is the key activity we're interested in. Storage only matters in as much as we can retrieve effectively. At the time of writing (1945) large amounts of information could be stored (extend the record), but consulting that record was still difficult.

That is, to request token if the app is not running in the Azure cloud with a managed identity:

• Acquire a token from Azure AD for authorizing requests from a client application

• Request an access token in Azure Active Directory B2C (and the other chapters in the Authorization protocols section)

If a tool benefits the entire team, vs. just the designer, it becomes an easier purchase decision.

Supporting Open Science Data Curation, Preservation, and Access by Libraries. (2020, June 25). https://www.youtube.com/watch?v=SbmGWHpzAHs&feature=youtu.be

s3 perfomance use columnar formats

when snowball

1000Mbps 12 days 60TB

Destul de puțin...

Practical highlights in my opinion:

• It's important to know about data padding in PG.
• Be conscious when modelling data tables about columns ordering, but don't be pure-school and do it in a best-effort basis.
• Gains up to 25% in wasted storage are impressive but always keep in mind the scope of the system. For me, gains are not worth it in the short-term. Whenever a system grows, it is possible to migrate data to more storage-efficient tables but mind the operative burder.

Here follows my own commands on trying the article points. I added - pg_column_size(row()) on each projection to have clear absolute sizes.

-- How does row function work?

SELECT pg_column_size(row()) AS empty,
       pg_column_size(row(0::SMALLINT)) AS byte2,
       pg_column_size(row(0::BIGINT)) AS byte8,
       pg_column_size(row(0::SMALLINT, 0::BIGINT)) AS byte16,
       pg_column_size(row(''::TEXT)) AS text0,
       pg_column_size(row('hola'::TEXT)) AS text4,
       0 AS term
;

-- My own take on that

SELECT pg_column_size(row()) AS empty,
       pg_column_size(row(uuid_generate_v4())) AS uuid_type,
       pg_column_size(row('hola mundo'::TEXT)) AS text_type,
       pg_column_size(row(uuid_generate_v4(), 'hola mundo'::TEXT)) AS uuid_text_type,
       pg_column_size(row('hola mundo'::TEXT, uuid_generate_v4())) AS text_uuid_type,
       0 AS term
;

CREATE TABLE user_order (
  is_shipped    BOOLEAN NOT NULL DEFAULT false,
  user_id       BIGINT NOT NULL,
  order_total   NUMERIC NOT NULL,
  order_dt      TIMESTAMPTZ NOT NULL,
  order_type    SMALLINT NOT NULL,
  ship_dt       TIMESTAMPTZ,
  item_ct       INT NOT NULL,
  ship_cost     NUMERIC,
  receive_dt    TIMESTAMPTZ,
  tracking_cd   TEXT,
  id            BIGSERIAL PRIMARY KEY NOT NULL
);

SELECT a.attname, t.typname, t.typalign, t.typlen
  FROM pg_class c
  JOIN pg_attribute a ON (a.attrelid = c.oid)
  JOIN pg_type t ON (t.oid = a.atttypid)
 WHERE c.relname = 'user_order'
   AND a.attnum >= 0
 ORDER BY a.attnum;

-- What is it about pg_class, pg_attribute and pg_type tables? For future investigation.

-- SELECT sum(t.typlen)
-- SELECT t.typlen
SELECT a.attname, t.typname, t.typalign, t.typlen
  FROM pg_class c
  JOIN pg_attribute a ON (a.attrelid = c.oid)
  JOIN pg_type t ON (t.oid = a.atttypid)
 WHERE c.relname = 'user_order'
   AND a.attnum >= 0
 ORDER BY a.attnum
;

-- Whoa! I need to master mocking data directly into db.

INSERT INTO user_order (
    is_shipped, user_id, order_total, order_dt, order_type,
    ship_dt, item_ct, ship_cost, receive_dt, tracking_cd
)
SELECT true, 1000, 500.00, now() - INTERVAL '7 days',
       3, now() - INTERVAL '5 days', 10, 4.99,
       now() - INTERVAL '3 days', 'X5901324123479RROIENSTBKCV4'
  FROM generate_series(1, 1000000);

-- New item to learn, pg_relation_size. 

SELECT pg_relation_size('user_order') AS size_bytes,
       pg_size_pretty(pg_relation_size('user_order')) AS size_pretty;

SELECT * FROM user_order LIMIT 1;

SELECT pg_column_size(row(0::NUMERIC)) - pg_column_size(row()) AS zero_num,
       pg_column_size(row(1::NUMERIC)) - pg_column_size(row()) AS one_num,
       pg_column_size(row(9.9::NUMERIC)) - pg_column_size(row()) AS nine_point_nine_num,
       pg_column_size(row(1::INT2)) - pg_column_size(row()) AS int2,
       pg_column_size(row(1::INT4)) - pg_column_size(row()) AS int4,
       pg_column_size(row(1::INT2, 1::NUMERIC)) - pg_column_size(row()) AS int2_one_num,
       pg_column_size(row(1::INT4, 1::NUMERIC)) - pg_column_size(row()) AS int4_one_num,
       pg_column_size(row(1::NUMERIC, 1::INT4)) - pg_column_size(row()) AS one_num_int4,
       0 AS term
;

SELECT pg_column_size(row(''::TEXT)) - pg_column_size(row()) AS empty_text,
       pg_column_size(row('a'::TEXT)) - pg_column_size(row()) AS len1_text,
       pg_column_size(row('abcd'::TEXT)) - pg_column_size(row()) AS len4_text,
       pg_column_size(row('abcde'::TEXT)) - pg_column_size(row()) AS len5_text,
       pg_column_size(row('abcdefgh'::TEXT)) - pg_column_size(row()) AS len8_text,
       pg_column_size(row('abcdefghi'::TEXT)) - pg_column_size(row()) AS len9_text,
       0 AS term
;

SELECT pg_column_size(row(''::TEXT, 1::INT4)) - pg_column_size(row()) AS empty_text_int4,
       pg_column_size(row('a'::TEXT, 1::INT4)) - pg_column_size(row()) AS len1_text_int4,
       pg_column_size(row('abcd'::TEXT, 1::INT4)) - pg_column_size(row()) AS len4_text_int4,
       pg_column_size(row('abcde'::TEXT, 1::INT4)) - pg_column_size(row()) AS len5_text_int4,
       pg_column_size(row('abcdefgh'::TEXT, 1::INT4)) - pg_column_size(row()) AS len8_text_int4,
       pg_column_size(row('abcdefghi'::TEXT, 1::INT4)) - pg_column_size(row()) AS len9_text_int4,
       0 AS term
;

SELECT pg_column_size(row(1::INT4, ''::TEXT)) - pg_column_size(row()) AS int4_empty_text,
       pg_column_size(row(1::INT4, 'a'::TEXT)) - pg_column_size(row()) AS int4_len1_text,
       pg_column_size(row(1::INT4, 'abcd'::TEXT)) - pg_column_size(row()) AS int4_len4_text,
       pg_column_size(row(1::INT4, 'abcde'::TEXT)) - pg_column_size(row()) AS int4_len5_text,
       pg_column_size(row(1::INT4, 'abcdefgh'::TEXT)) - pg_column_size(row()) AS int4_len8_text,
       pg_column_size(row(1::INT4, 'abcdefghi'::TEXT)) - pg_column_size(row()) AS int4_len9_text,
       0 AS term
;

SELECT pg_column_size(row()) - pg_column_size(row()) AS empty_row,
       pg_column_size(row(''::TEXT)) - pg_column_size(row()) AS no_text,
       pg_column_size(row('a'::TEXT)) - pg_column_size(row()) AS min_text,
       pg_column_size(row(1::INT4, 'a'::TEXT)) - pg_column_size(row()) AS two_col,
       pg_column_size(row('a'::TEXT, 1::INT4)) - pg_column_size(row()) AS round4;

SELECT pg_column_size(row()) - pg_column_size(row()) AS empty_row,
       pg_column_size(row(1::SMALLINT)) - pg_column_size(row()) AS int2,
       pg_column_size(row(1::INT)) - pg_column_size(row()) AS int4,
       pg_column_size(row(1::BIGINT)) - pg_column_size(row()) AS int8,
       pg_column_size(row(1::SMALLINT, 1::BIGINT)) - pg_column_size(row()) AS padded,
       pg_column_size(row(1::INT, 1::INT, 1::BIGINT)) - pg_column_size(row()) AS not_padded;

SELECT a.attname, t.typname, t.typalign, t.typlen
  FROM pg_class c
  JOIN pg_attribute a ON (a.attrelid = c.oid)
  JOIN pg_type t ON (t.oid = a.atttypid)
 WHERE c.relname = 'user_order'
   AND a.attnum >= 0
 ORDER BY t.typlen DESC;

DROP TABLE user_order;

CREATE TABLE user_order (
  id            BIGSERIAL PRIMARY KEY NOT NULL,
  user_id       BIGINT NOT NULL,
  order_dt      TIMESTAMPTZ NOT NULL,
  ship_dt       TIMESTAMPTZ,
  receive_dt    TIMESTAMPTZ,
  item_ct       INT NOT NULL,
  order_type    SMALLINT NOT NULL,
  is_shipped    BOOLEAN NOT NULL DEFAULT false,
  order_total   NUMERIC NOT NULL,
  ship_cost     NUMERIC,
  tracking_cd   TEXT
);

-- And, what about other varying size types as JSONB?

SELECT pg_column_size(row('{}'::JSONB)) - pg_column_size(row()) AS empty_jsonb,
       pg_column_size(row('{}'::JSONB, 0::INT4)) - pg_column_size(row()) AS empty_jsonb_int4,
       pg_column_size(row(0::INT4, '{}'::JSONB)) - pg_column_size(row()) AS int4_empty_jsonb,
       pg_column_size(row('{"a": 1}'::JSONB)) - pg_column_size(row()) AS basic_jsonb,
       pg_column_size(row('{"a": 1}'::JSONB, 0::INT4)) - pg_column_size(row()) AS basic_jsonb_int4,
       pg_column_size(row(0::INT4, '{"a": 1}'::JSONB)) - pg_column_size(row()) AS int4_basic_jsonb,
       0 AS term;