Re: [PERFORM] Postgresql is using seqscan when is should use indexes.

2004-11-08 Thread Russell Smith
On Mon, 8 Nov 2004 09:40 pm, Andreas Ãkre Solberg wrote: > We have two tables, dst_port_hour and dst_port_day, which should be > very similar, they both have about 50.000.000 rows. In both tables we > have an index for period_id. > > We run postgresql 7.4.5 on a dedicated Debian server, with dual

[PERFORM] Postgresql is using seqscan when is should use indexes.

2004-11-08 Thread Andreas Åkre Solberg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have two tables, dst_port_hour and dst_port_day, which should be very similar, they both have about 50.000.000 rows. In both tables we have an index for period_id. We run postgresql 7.4.5 on a dedicated Debian server, with dual Intel Xeon 3G