Re: Poor performance with "large" table.

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.
>