473,837 Members | 1,678 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PGADMIN default storage EXTENDED for Character fields



I am using PGADMIN III v1.1.0 Windows to set up PostgreSQL tables on a
Linux Server, RedHat 9. Every time I create a character field, even just
one character wide, the PGADMIN uses EXTENDED as the default storage type.
Is this normal? I can't find anything about why this would be done in the
PostgreSQL documentation or the Internet. It seems to me it will be very
messy if every character field is in a secondary table. I would have
thought the EXTENDED would only be for very large character fields.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #1
1 3426
Ma************@ chromalloy.com writes:
I am using PGADMIN III v1.1.0 Windows to set up PostgreSQL tables on a
Linux Server, RedHat 9. Every time I create a character field, even just
one character wide, the PGADMIN uses EXTENDED as the default storage type.
Is this normal?
Yes, this is the standard behavior.
It seems to me it will be very messy if every character field is in a
secondary table. I would have thought the EXTENDED would only be for
very large character fields.


No, you are misunderstandin g. EXTENDED storage *allows* Postgres to
move large field values out to a secondary table. If a particular entry
is not large, then it won't be moved out.

Choosing one of the other storage options restricts Postgres from moving
data out, which can make things faster but also exposes you to a risk of
"row too large" errors. So I'd not recommend doing it unless you are
quite sure you know what you're doing and what your data will look like.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
5520
by: Keith MacDonald | last post by:
Hello, Is there a portable (at least for VC.Net and g++) method to convert text between wchar_t and char, using the standard library? I may have missed something obvious, but the section on codecvt, in Josuttis' "The Standard C++ Library", did not help, and I'm still awaiting delivery of Langer's "Standard C++ IOStreams and Locales". Thanks,
1
2263
by: Együd Csaba | last post by:
Hi All, I've a problem using PGAdmin III. When I click on one of my functions the definition pane shows an empty function (with the correct header and footer but with no body). Pg_dump shows everything correctly. What can be the problem. My other problem is that PGAdmin won't handle '?' (euro) sign. It shows the previously correctly enterd data (by means of other tools) but it won't insert or update it in the correct way. It shows a '?'...
1
6646
by: mikew | last post by:
I am working at a company that has been using MS SQL Server, and we are going to be switching over to postgresql next week. (Getting off of Windows will be a relief!) I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things that I really like about pgAdmin, but there are a few things that SQL Server Enterprise manager can...
12
5549
by: Jeremy | last post by:
Hi all, I'm getting very confused about how DB2 uses shared memory and I wonder if someone could clarify matters for me, please ? We are running 32bit DB2 V7.2 FP9 under AIX 4.3.3 on a machine with 64 Gb of memory with a single non-partitioned database using extended storage and with intra-parallelism enabled. I've been experimenting with changing various parameters in an attempt
2
2691
by: raptor | last post by:
In pgadmin3 I'm tring to add auto_inc column like this ALTER TABLE public.modems ADD COLUMN id serial; But get this error : NOTICE: ALTER TABLE will create implicit sequence "modems_id_seq" for "serial" column "modems.id" ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT.
2
1942
by: mmd | last post by:
I want to use pgadmin to set up some tables, rather than do all the psql statements from the terminal. When I try to add a server, though, pgadmin fails to connect, and asks whether the server is accepting TCP/IP connections on the default port, and whether localhost is the correct servername. I assume that both of these ARE set to the defaults, because if I simply type
1
3327
by: Tim Penhey | last post by:
I tried to use pgAdmin III to add a table to a database. Using the GUI to add the fields it ended up creating SQL like this: CREATE TABLE customer ( id serial NOT NULL, name "varchar"(80) NOT NULL, balance "numeric"(10,2) NOT NULL DEFAULT 0 ) WITH OIDS;
4
3718
by: Jess | last post by:
Hello, I tried several books to find out the details of object initialization. Unfortunately, I'm still confused by two specific concepts, namely default-initialization and value-initialization. I think default-init calls default constructor for class objects and sets garbage values to PODs. Value-init also calls default constructor for class objects and sets 0s to POD types. This is what I've learned from the books (especially...
13
48103
by: ramif | last post by:
Is there a way to print extended ASCII in C?? I tried to code something, but it only displays strange symbols. here is my code: main() { char chr = 177; //stores the extended ASCII of a symbol printf("Character with an ascii code of 177: %c \n", chr); //tries to print an ASCII symbol...
0
9682
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10864
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10615
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10263
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6989
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5664
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4469
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4036
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3122
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.