From: Guy Deleeuw <G.De_Leeuw@eurofer.be>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: How to
Date: Sun, 06 Feb 2011 14:15:44 +0100
Message-ID: <1296998144.2024.14.camel@pc-1000> (raw)
Hello
I have a strange behaviour :
time psql -d db_cathline -c "SELECT * FROM v_stock_status;"
real 0m5.780s
user 0m0.090s
sys 0m0.020s
time psql -d db_cathline -c "SELECT * FROM v_stock_status WHERE
remain_qty != 0;"
real 0m56.075s
user 0m0.070s
sys 0m0.030s
Why with the clause WHERE the time are 10x greater than ? How can I work
around this ?
# select version();
version
-------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4.7 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
(Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit
(1 ligne)
Regards
Guy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: G.De_Leeuw@eurofer.be
Subject: Re: How to
In-Reply-To: <1296998144.2024.14.camel@pc-1000>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox