hi,<br /><br />I tried to post it in group of pgsql-novice, but ppl there suggest me to have a post here, so here is my
originalpost (btw, my OS is windows server 2008, 64 bit):<br />---<br />I used postgresql (pg 8.3) + django to create a
verysimple table to store html contents, since the content is of variable size, I used a text field to store it. Here
isthe generated DB table:<br />---<br />CREATE TABLE reader_htmlcache<br /> (<br /> id serial NOT NULL,<br /> url
charactervarying(8000) NOT NULL,<br /> "content" text NOT NULL,<br /> last_updated timestamp with time zone NOT
NULL,<br/> updated_by character varying(50) NOT NULL,<br /> CONSTRAINT reader_htmlcache_pkey PRIMARY KEY (id)<br />
)<br/>WITH (<br /> OIDS=FALSE<br />);<br />ALTER TABLE reader_htmlcache OWNER TO postgres;<br />---<br /><br
/>However,when I try to inspect the data inside PgAdmin3 (either though data browsing / query window), the display is
extremelyslow, i.e. it took 5 seconds to display 10 rows, and the text field of "content" is shown empty.<br /><br />I
triedthe PgAdmin on both windows & mac, and it's the same. However, for other tables that does have more columns
butno text field, it took less than one second to display the data (more than 100 rows). <br /><br />Also, the app
worksfine, i.e., when web server try to access the data in backend via python code, the response is OK. <br /><br />It
seemsthat it is slow ONLY when I try to use PgAdmin to view the data. And I checked the preference, and it only showes
first256 characters of column (In fact it does not display any). <br /><br />I searched Google a while, and did not
findanything trivial.<br /><br />Any advice please?<br /><br clear="all" />Thanks a lot.<br /><br clear="all" />---<br
/><br/><br />-- <br />have a nice day<br />walty<br />