Forcing postgres NOT to use sequential scan, trough JDBC

Поиск
Список
Период
Сортировка
От Mario Splivalo
Тема Forcing postgres NOT to use sequential scan, trough JDBC
Дата
Msg-id 49B0FFE4.2030202@megafon.hr
обсуждение исходный текст
Ответы Re: Forcing postgres NOT to use sequential scan, trough JDBC  (Dave Cramer <pg@fastcrypt.com>)
Re: Forcing postgres NOT to use sequential scan, trough JDBC  (Mario Splivalo <mario.splivalo@megafon.hr>)
Список pgsql-jdbc
How do I tell postgres not to use sequential scan, trough jdbc?

I tried to include 'SET enable_seqscan TO false;' at the begining of the
plpgsql function, but that seems to work only if I call the function
trough the psql, and only for the subsequent calls in the current
session. I 'know' that postgres is using sequential scan because
function call takes cca 400ms. When I force postgres not to use
sequential scan, the function takes around 5-10ms.

I even tried, on the same connection, to issue 'SET enable_seqscan TO
false;' trough jdbc before I call my function, but execution time is
still around 400ms.

    Mike

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Guillaume Smet
Дата:
Сообщение: Re: What do people use for connection pooling with PostgreSQL JDBC
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Forcing postgres NOT to use sequential scan, trough JDBC