On Thu, Sep 20, 2001 at 11:10:02AM +0200, Herbert Liechti wrote:
> I tried it. See my actions below. The main performance boost is
> reached by creating an index and disabling the sequential scan:
> Without any index;
> real 0m18.128s
> user 0m0.010s
> sys 0m0.010s
>
> Same statement with index
> real 0m18.259s
> user 0m0.020s
> sys 0m0.010s
> no difference
>
> now disable seqscan:
> time psql tt <<END
> set enable_seqscan = off;
> real 0m3.701s
> user 0m0.010s
> sys 0m0.000s
same here (dual PIII-866, Debian, 512 MB, raid1+0)
real 0m6.472s
user 0m0.000s
sys 0m0.010s
real 0m6.195s
user 0m0.010s
sys 0m0.000s
real 0m2.885s
user 0m0.010s
sys 0m0.000s
tinus