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)
*
Hi,
I understand that when a table contains only a few rows it is better to
do a sequence scan than an index scan. But is this also for a table with
99 records?
A table contains
id integer (primary key)
namevarchar(70)
You should lower random_page_cost to make the planner choose an index
scan vs sequential scan.
Yes , it was a bit to high (18) so a lowered it. It speeded up some
pages for about 5%.
Reg. Jer
---(end of broadcast)---
TIP 1: subscribe and
Matteo Beccati wrote:
Hi,
Yes , it was a bit to high (18) so a lowered it. It speeded up some
pages for about 5%.
18? The default is 4 if I can remember correctly. I wonder if your db
has ever seen an index scan ;)
I was expermenting how much some setting influence has on the perfomance
of