I'm very new to Postgres so my math could be off here ...  This is my table:  CREATE TABLE audit (     id BIGSERIAL PRIMARY KEY,     content_id VARCHAR (50) NULL,      type VARCHAR (100) NOT NULL,      size bigint NOT NULL,      timestamp1 timestamp NOT NULL DEFAULT NOW(),      timestamp2 timestamp NOT NULL DEFAULT NOW() );   I want to make some estimations on how much space 1 row would occupy. After some reading I've come up with this, is it correct?  1 row = 23 (heaptupleheader) + 1 (padding) + 8 (id) + 50 (content_id) + 6 (padding) + 100 (type) + 4 (padding) + 8 (size) + 8 (timestamp) + 8 (timestamp) = 216 bytes   I also created this same table in my local Postgres DB but the numbers don't seem to match:  INSERT INTO public.audit(content_id, type, size)     VALUES ('aaa', 'bbb', 100);  SELECT pg_size_pretty( pg_total_relation_size('audit') );  -- returns 24 kb  INSERT INTO public.audit(content_id, type, size)     VALUES ('aaaaaaaaaaaaa', 'bbbbbbbbbbbbbb', 100000000000);  SELECT pg_size_pretty( pg_total_relation_size('audit') ); -- still returns 24 kb   Which brings me to think that Postgres reserves a space of 24 kb to start with and as I put in more data it will get incremented by 132 bytes once I go beyond 24 kb? But something inside me says that can't be right.  I want to see how much space 1 row would occupy in Postgres db so I can analyze how much data I can potentially store in it. Maybe I'm missing something very obvious.
I have a PostgreSQL table. select * is very slow whereas select id is nice and quick. I think it may be that the size of the row is very large and it's taking a while to transport, or it may be some other factor. I need all of the fields (or nearly all of them), so selecting just a subset isn't a quick fix. Selecting the fields that I want is still slow. Here's my table schema minus the names: integer                  | not null default nextval('core_page_id_seq'::regclass) character varying(255)   | not null character varying(64)    | not null text                     | default '{}'::text character varying(255)   |  integer                  | not null default 0 text                     | default '{}'::text text                     |  timestamp with time zone |  integer                  |  timestamp with time zone |  integer                  |   The size of the text field may be any size. But still, no more than a few kilobytes in the worst case. Questions  Is there anything about this that screams 'crazy inefficient'? Is there a way to measure page size at the Postgres command-line to help me debug this?
Why do we use "dried up" instead of just "dried"? The creek has dried up.   In this example sentence, you should say "dried up." If you say just "dried," it sounds incomplete. Is this an example of an idiom or is there a grammatical rule governing this instance? If so, what is it? states that the relationship between current ( I ) voltage ( V ) and resistance ( R ) is  $$I = \frac{V}{R}$$  However  cause the resistance of a material to go to zero, and as I understand it, as $R \to 0$, $I \to \infty$. Does this present a problem for Ohm's law? Is it possible to navigate to a Visualforce page from an LWC with parameters and community compatible The LWC framework includes the NavigationMixin.Navigate functionality that can be used to obtain URLs or perform navigation to generated URLs. This supports a number of different page types, as covered in the . What I can't find is how to create a URL to a specific Visualforce page, with parameters and compatible with communities. Using the &quot;web page&quot; navigation type seems wrong to me, since the URL for a Visualforce page varies based on whether access is direct or within a community. Do you know what the correct approach is for navigating from a flexipage via an LWC component to a Visualforce page in the same org, passing the page some parameters? Passing a formatted NSDate Of course preventing them from getting stolen is the top priority, but invariably, someone is going to get jacked. What are some good practices to minimize the damage incurred when your PC is stolen?  Given most of our PCs contain our entire lives, its frightening to know that all this information can be in someone else's hands.   Some ideas i had (a bit paranoid, i admit).   keep encrypted backups.  Use truecrypt to have double encrypted (with strong password) volumes where you store your personal data. schedule Eraser to run every evening so that potential thieves couldn't undelete (and subsequently retrieve) sensitive data do all your banking in a virtual machine.  Keep the virtual machine volume encrypted, and on a portable usb drive that you carry with you / keep in a safe. have applications that phone home (or hit something to leave an IP trace) upon connection to the internet (can someone suggest a good solution for this?)   Does anyone have any other suggestions? I want to make an arena where mobs will fight each other and a player can bet on one side or the other. For example: There are 2 skeletons in dyed armor; red and blue. Each color representing a team. When they spawn I want them to fight each and then when one dies I want it to announce which team is the winner and give the player the "money" due. I'm just not sure how to get the skeletons to attack each other without a player instigating it. Timeline vote summary shows votes for the 24 hours following the timestamp, which is confusing The new timeline is pretty snazzy. But there's one thing I've noticed that's a bit jarring; the timestamp for vote summaries is always 0:00:00 on a particular day, and the summary covers the rest of that day. So you end up with a summary that always shows up earlier than the events that presumably triggered the votes that show up in it.  A simple solution is to have it display 23:59:59 instead, and sort accordingly. This way the summary comes in after the events it summarizes. Is there an equivalent to Google Sketchup? How to properly write multiple authors in bibtex file? Uniform distribution on the surface of unit sphere How to fix lsregister failing associations after reboot? I have always argued adamantly, as long as the issue has been around, that gift should never be used as a verb. However, someone whose English knowledge I quite respect disagrees.  I’ve done some searching and I haven’t found a consensus; should gifting be shunned? Maxing out gear with maxed out smithing, enchanting and alchemy I have level 100 smithing, enchanting and alchemy. I also have some nice enchanted gear, fortify smithing and alchemy.   How high should I be able to get my fortified equipment?  Currently I'm around 29% for alchemy and smithing.  How high can I get fortify smithing and fortify enchanting potions without using the console (cheating)? And how? Currently I get +147% and +32% respectively.  Is something like this possible without using the console(or photoshop)? An example where the output of the k-medoid algorithm is different than the output of the k-means algorithm What is the pressure at the center of the Earth? (Or a neutron star) The  has microgravity and is thought to be solid and almost 6000 degrees hot. What is the pressure like there? The confusing thing, for the common man I suppose, is that there's no gravity there, but lots of matter around it which does gravitate towards the center. How does that add up? Is the center just a gas cloud or is it highly compressed?  And I could add the aside question about what it is like in the microgravity center of a  or a black hole, but I don't expect anyone to know about that. Getting image dimensions without reading the entire file Passing a varible from jQuery to PHP Install software from packages, or build it from source? This is a  about when to use packaged software and when to build and install it yourself.   When should I install software from packages provided by my OS distribution, instead of building and installing it myself from source?  When is it better to build from source? What is the difference between “within” and “inside”? Here is the definition of the word within from Oxford Dictionary:     inside (something)   So does that mean the two words have no difference, and can be used exchangingly? Is there any connotation that one word can be used but not the other? We will generate a csv file with below values  yp1234,577,1,3 yp5678,577,3,5 yp9012,132,8,9   I need to extract data and create files based on second column. If it's 577 then the whole line has to be extracted and placed in a separate file. I mean I need a file having lines with second column as 577 alone and another file with second column as 132 alone  I tried using IF but didn't work