Re: BUG #13838: Problem in a table with integer primary key

Поиск
Список
Период
Сортировка
От Feike Steenbergen
Тема Re: BUG #13838: Problem in a table with integer primary key
Дата
Msg-id CAK_s-G260cFG75S86Uc0jYHHhEFeZZ4B0L9sbokWgi21ev9mUQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #13838: Problem in a table with integer primary key  (ronan.vargas@gmail.com)
Ответы Re: BUG #13838: Problem in a table with integer primary key  (Ronan Vargas <ronan.vargas@gmail.com>)
Список pgsql-bugs
Could you do an explain analyze of both of these statements? It may help in
understanding the issue.

If it's a primary key, I assume the first query to be using the primary key
index.
The second variant will probably be a sequential scan on the table.

If these give different results, it may be a corrupt index, you could try
to reindex the specific index or the table, see
http://www.postgresql.org/docs/9.1/static/sql-reindex.html

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

Предыдущее
От: ronan.vargas@gmail.com
Дата:
Сообщение: BUG #13838: Problem in a table with integer primary key
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #13822: Slave terminated - WAL contains references to invalid page