472,328 Members | 2,118 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

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 3318
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 misunderstanding. 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
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...
1
by: Egyd 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...
1
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...
12
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...
2
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...
2
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,...
1
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...
4
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,...
13
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() {...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
1
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

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.