hash indexes and HS was:(Re: [HACKERS] testing hot standby) - Mailing list pgsql-hackers

From Jaime Casanova
Subject hash indexes and HS was:(Re: [HACKERS] testing hot standby)
Date
Msg-id l2p3073cc9b1004130841u8f9bde9aj328e9ef8bb649d53@mail.gmail.com
Whole thread Raw
Responses Re: hash indexes and HS was:(Re: [HACKERS] testing hot standby)  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Hot Standby: Startup at shutdown checkpoint
Next
From: Heikki Linnakangas
Date:
Subject: Re: Remaining Streaming Replication Open Items