Re: [PERFORM] Seqscan on big table, when an Index-Usage should be possible

2014-06-05 Thread Igor Neyman
qscan on big table, when an Index-Usage should be > possible > > Hello, > > I'm currently testing some queries on data which I had imported from an > other database-system into Postgres 9.4. > > After the import I did create the indexes, run an analyze and vacuum. I al

[PERFORM] Seqscan on big table, when an Index-Usage should be possible

2014-06-05 Thread Weinzierl Stefan
Hello, I'm currently testing some queries on data which I had imported from an other database-system into Postgres 9.4. After the import I did create the indexes, run an analyze and vacuum. I also played a little bit with seq_page_cost and random_page_cost. But currently I have no clue, whic