hash indexes and HS was:(Re: [HACKERS] testing hot standby)

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема hash indexes and HS was:(Re: [HACKERS] testing hot standby)
Дата
Msg-id l2p3073cc9b1004130841u8f9bde9aj328e9ef8bb649d53@mail.gmail.com
обсуждение исходный текст
Ответы Re: hash indexes and HS was:(Re: [HACKERS] testing hot standby)
Список pgsql-hackers
On Mon, Apr 12, 2010 at 1:23 AM, Jaime Casanova
<jcasanov@systemguards.com.ec> wrote:
>
> another point, what happened with this:
> http://archives.postgresql.org/message-id/1229549172.4793.105.camel@ebony.2ndQuadrant?
> Obviously we still have the problem with hash indexes, and in that
> thread Tom advice was just to document the issue and while that could
> be fine at least we should be emitting better messages, consider this
> one that i got on the standby server (where 4658650 is the oid of a
> hash index):
> """
> mic=# explain analyze select * from tt1 where col1 = 5000;
> ERROR:  could not read block 0 in file "base/21958/4658650": read only
> 0 of 8192 bytes
> """
>

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Hot Standby: Startup at shutdown checkpoint
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Remaining Streaming Replication Open Items