Search Postgresql Archives

Re: PSQL command line print speed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: PSQL command line print speed
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Wed, 17 May 2017 11:40:00 -0700
Arc-authentication-results: i=1; mx.google.com; dkim=neutral (body hash did not verify) header.i=@aklaver.com; dkim=neutral (body hash did not verify) header.i=@messagingengine.com; spf=pass (google.com: best guess record for domain of pgsql-general-owner+m230960=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-general-owner+M230960=spinic=gmail.com@xxxxxxxxxxxxxx
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:content-transfer-encoding :content-language:in-reply-to:mime-version:user-agent:date :message-id:from:references:cc:to:subject:dkim-signature :dkim-signature:arc-authentication-results; bh=yj6tsnkjXkxY7T/FhE/cm/I/Ov1Rf9ekiquWmrr/7QE=; b=qRLQQ4QeeXpKcuEsQK7ngh2VYg1Pxg7ljWrmAERwhCYfw/1h2gHlUVJF062HBNKhO3 LiS6vlUTbWstqLO+BgwqVZoSxA+IijOn4ga4MfGmXrOp30eTT+tHBQKje/28HOjeIIVx XjkmrAm32HEKl0vhjogJFqHaQ4PpTayjCWhzh7HD5fS3qGbk5bJWsa69IBNeIRcTJlqo PyUkUa6713CAt6BCAhlcuaibQnZjBO4ReAwXEAJ86bI0JbizjqXro3vD0Cs/7CXiaJnb xE37tkyo0yopoGR1fQvSfz8jcLBJuXwVFRaJT6GyyyR0Zzp+zu5+EEEy9eoRv12jkNnI 4sAg==
Arc-seal: i=1; a=rsa-sha256; t=1495046456; cv=none; d=google.com; s=arc-20160816; b=xNWwLX5x6ewTiBGKAXFdzzNFk10X/L3eupIdvBWQjw46u2JKMj3MncjiVj89Z0EuPL aIFZ7Dv9rO76aqcW6IpeVkQl+7lEuFLJKQ/NNcXUzmgLetS4l1qs8tSr0ZGnVJNxfSFE +wsRGHqX2j6Fwr1iUOnJilTk6ksv/8FdNnAdBik9n2QuvAexxCoQbH1LYXNcTJ0oIBiA YPZRreOlmmc66KQrGmroUnnIG3TwlPARl1NagfiRbicfaHRlFedMOEPFefh9TuOiqJuu +ZZYm933ZL+E+7fL3g5i48WGU9817LGy/VxQJr+IJ2rTrzcEqx1erMsDPKiDwCusVksL Z0Aw==
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CALAd6+1A6n5+QNOHqe2e4P418nveU87k2sLEeNY=83pjafmXbA@mail.gmail.com>
References: <CALAd6+0wXfBV6BWDiChz+BummvjTt0VSbjr_DMwCR=Vh4zsFEw@mail.gmail.com> <83928022-85b7-4469-160e-fff70a4d2ae8@aklaver.com> <CALAd6+2eQKh-++YGq43xcCHkpGEdGikSj6KjDjex9bmQEWuscw@mail.gmail.com> <a4873264-de74-3fd0-6c94-c3b221bf5a9a@aklaver.com> <CALAd6+1A6n5+QNOHqe2e4P418nveU87k2sLEeNY=83pjafmXbA@mail.gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.0

On 05/17/2017 09:46 AM, Adrian Myers wrote:

Ah I should have mentioned, the pager is off.


Is that by choice and if so why?

With the pager off you have to wait for the entire output to write tothe screen. For anything but a small dataset that is going to take time.




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: PSQL command line print speed
  - From: Francisco Olarte

References:
- PSQL command line print speed
  - From: Adrian Myers
- Re: PSQL command line print speed
  - From: Adrian Klaver
- Re: PSQL command line print speed
  - From: Adrian Klaver
- Re: PSQL command line print speed
  - From: Adrian Myers

Prev by Date: Re: database is not accepting commands
Next by Date: Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2
Previous by thread: Re: PSQL command line print speed
Next by thread: Re: PSQL command line print speed
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]