Re: Postgres delete performance problem

Поиск
Список
Период
Сортировка
От Vitalii Tymchyshyn
Тема Re: Postgres delete performance problem
Дата
Msg-id CABWW-d1kp9AVovSE-6yVCbpNLO0Rt_U2mW6ZCnzYUSCCtP3mpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres delete performance problem  (dankogan <dan@iqtell.com>)
Список pgsql-performance
Yes, the issue was resolved by the method I proposed. You need to specify correct type either on java-side or server-side (query text).
See my explanation (it seems it got out of the list):

The driver does not parse your query, so it simply passes everything to server.
Server use widening conversion, so "bigint=number" becomes "bigint::number=number", not "bigint=number::bigint" and index can't be used when any function is applied to indexed field.
Note, that server can't do "bigint=number::bigint" because it does not know the numbers you will pass.
Consider examples:
1) 0 = 123456789012345678901234567890
2) 0 = 0.4
Correct value is false, but "bigint=number::bigint" will give you "overflow" error for the first example and true for the second, which is incorrect.


2013/1/4 dankogan <dan@iqtell.com>
Hello,

Just wondering whether you were able to resolve this issue.
We are experiencing a very similar issue with deletes using Postgrs 9.0.5 on
Ubuntu 12.04.

Dan



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-delete-performance-problem-tp5714153p5738765.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--
Best regards,
 Vitalii Tymchyshyn

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

Предыдущее
От: dankogan
Дата:
Сообщение: Re: Postgres delete performance problem
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Re[2]: [PERFORM] SMP on a heavy loaded database