Re: [PERFORM] Performance problem with pg8.0

2005-11-07 Thread Richard Huxton
Jeroen van Iddekinge wrote: Hello, I have some strange performance problems with quering a table.It has 5282864, rows and contains the following columns : id ,no,id_words,position,senpos and sentence all are integer non null. Index on : * no * no,id_words * id_words * senpos,

[PERFORM] Performance problem with pg8.0

2005-11-06 Thread Jeroen van Iddekinge
Hello, I have some strange performance problems with quering a table.It has 5282864, rows and contains the following columns : id ,no,id_words,position,senpos and sentence all are integer non null. Index on : * no * no,id_words * id_words * senpos, sentence, no) *