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
