Re: Poor performance with "large" table. - Mailing list pgsql-general

From Holger Marzen
Subject Re: Poor performance with "large" table.
Date
Msg-id Pine.LNX.4.44.0204171038110.3347-100000@bluebell.marzen.de
Whole thread Raw
In response to Poor performance with "large" table.  (pgsql-gen Newsgroup (@Basebeans.com) <pgsql-gen@basebeans.com>)
List 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.


pgsql-general by date:

Previous
From: bombadil@wanadoo.es
Date:
Subject: Making a column not null
Next
From: Hiroshi Inoue
Date:
Subject: Re: Date precision problem