On 17 March 2013 08:30, Tom Lane t...@sss.pgh.pa.us wrote:
Oleg Alexeev oalex...@gmail.com writes:
* it is varchar columns, 256 and 32 symbols length
* encoding, collation and ctype: UTF8, en_US.utf8, en_US.utf8
* autovacuum, fsync off, full_page_writes = on, wal_writer_delay = 500ms
On 16 March 2013 01:21, Steve Crawford scrawf...@pinpointresearch.comwrote:
On 03/15/2013 11:29 AM, Oleg Alexeev wrote:
We've faced with strange index problem.
At some moment index became bad and queries does not return any data.
For example, there are two tables - A (id, name) and B (id
On 16 March 2013 14:32, Alban Hertroys haram...@gmail.com wrote:
On Mar 16, 2013, at 9:33, Oleg Alexeev oalex...@gmail.com wrote:
On 16 March 2013 01:21, Steve Crawford scrawf...@pinpointresearch.comwrote:
On 03/15/2013 11:29 AM, Oleg Alexeev wrote:
We've faced with strange index problem
On 16 March 2013 19:10, Tom Lane t...@sss.pgh.pa.us wrote:
Alban Hertroys haram...@gmail.com writes:
If there's actually something wrong with the database; it looks a bit
like your tables and your indexes get out of sync somehow, which normally
wouldn't be possible. I'm mostly guessing, but
We've faced with strange index problem.
At some moment index became bad and queries does not return any data.
For example, there are two tables - A (id, name) and B (id, name, a_id).
B.a_id is foreign key to A. Both name columns in tables contains identical
values for A.id = B.a_id. A.name