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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
