text field slow to display in pgadmin
От | walty |
---|---|
Тема | text field slow to display in pgadmin |
Дата | |
Msg-id | 321658e20909270118o6dcc7ef8m372684eafe39fac@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: text field slow to display in pgadmin
|
Список | pgadmin-support |
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 />
В списке pgadmin-support по дате отправления: