From: | Guy Deleeuw <G(dot)De_Leeuw(at)eurofer(dot)be> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | How to |
Date: | 2011-02-06 13:15:44 |
Message-ID: | 1296998144.2024.14.camel@pc-1000 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2011-02-06 13:40:37 | Re: How to |
Previous Message | Vibhor Kumar | 2011-02-06 12:04:34 | Re: pg_standby and compressed archive |