| From: | Holger Marzen <holger(at)marzen(dot)de> |
|---|---|
| To: | pgsql-gen Newsgroup <pgsql-gen(at)basebeans(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Poor performance with "large" table. |
| Date: | 2002-04-17 08:39:09 |
| Message-ID: | Pine.LNX.4.44.0204171038110.3347-100000@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Hiroshi Inoue | 2002-04-17 09:05:50 | Re: Date precision problem |
| Previous Message | bombadil | 2002-04-17 08:18:51 | Making a column not null |