[PERFORM] Slow performance with Group By

here's got to be a better way than a sequence scan on 10,000,000 records, but I'll be darned if I can find any way to improve things here. Thanks for any help you all can offer!! Erik Norvelle ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[PERFORM] Update performance ... is 200,000 updates per hour what I should expect?

b, refere3a, refere3b), indethom_sectio_ndx btree (nomeoper, refere1a, refere1b, refere2a, refere2b, refere3a, refere3b, refere4a, refere4b), verbum_ndx btree (verbum) Thanks for your assistance! -Erik Norvelle

Re: [PERFORM] My indexes aren't being used (according to EXPLAIN)

The ANALYSE did the trick... Thanks! Will also read through the archives... -Erik On lunes, dici 1, 2003, at 15:04 Europe/Madrid, Andrew Sullivan wrote: On Mon, Dec 01, 2003 at 02:40:30PM +0100, Erik Norvelle wrote: it=> explain select * from indethom where clavis < 25; What's the

[PERFORM] My indexes aren't being used (according to EXPLAIN)

to point me to any FAQ or previous message that already answers this question. Thanks in advance! -Erik Norvelle