From: | pgsql-gen Newsgroup ((at)Basebeans(dot)com) <pgsql-gen(at)basebeans(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Poor performance with "large" table. |
Date: | 2002-04-18 00:40:01 |
Message-ID: | 200204180040.g3I0e1H14763@basebeans.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Subject: Re: [GENERAL] Poor performance with "large" table.
From: "Jack Gao" <weigao(at)hotmail(dot)com>
===
Thanks for the reply, it's really helped.
Actually, after I installed less, I got another error message. "WARN:
terminal is not fully function.....". And I found that because of Rational
Rose, Rational Rose set envirement variable "TERM" to nutc, but cygwin need
it to be "cygwin".
Thanks again.
Jack
"Holger Marzen" <holger(at)marzen(dot)de> wrote in message
news:mailman(dot)1019032861(dot)29298(dot)pgsql-gen(at)basebeans(dot)com(dot)(dot)(dot)
> On Wed, 17 Apr 2002, pgsql-gen Newsgroup wrote:
>
> > 1. I'm keeping get error message when I use psql to get "large" data.
For
> > example, if one of my table has more than 74 records in it, when I run
> > "select * from tbl...." on psql, it give me "less: not found" message.
Also,
> > if I run "\df" on psql, I got same message. But if I run "\df to_char",
I
> > got the inform I want. Looks like psql can not showing too much data.
But
> > what this error message mean, and how to fix it?
>
> The frontend seems to use "less" (an improved "more") as a pager if more
> rows are returned than fit on one screen. Be sure to have "less"
> installed and in your PATH.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Castle | 2002-04-18 01:09:21 | Re: size of NULL field? |
Previous Message | Jeff Post | 2002-04-17 22:35:34 | PERL DBI and Novell Netware |