Re: [BUGS] BUG #5543: Poor performance - Index scan backwards not used for order by desc with partitioned tables

2010-07-27 Thread Robert Haas
On Tue, Jul 27, 2010 at 7:27 PM, Tom Lane wrote: > Robert Haas writes: >> Does it help if you put a CHECK (false) constraint on the parent table? > > It won't --- it'll still result in an append plan even if there's only > one surviving child. > > This is one of many things that seem to me to not

Re: [BUGS] BUG #5543: Poor performance - Index scan backwards not used for order by desc with partitioned tables

2010-07-27 Thread Tom Lane
Robert Haas writes: > Does it help if you put a CHECK (false) constraint on the parent table? It won't --- it'll still result in an append plan even if there's only one surviving child. This is one of many things that seem to me to not make sense to tackle until we have an explicit notion of par

Re: [BUGS] BUG #5543: Poor performance - Index scan backwards not used for order by desc with partitioned tables

2010-07-27 Thread Robert Haas
On Tue, Jul 6, 2010 at 2:20 PM, Ranga Gopalan wrote: > > The following bug has been logged online: > > Bug reference:      5543 > Logged by:          Ranga Gopalan > Email address:      ranga_gopa...@hotmail.com > PostgreSQL version: 8.4.4 > Operating system:   Linux x86-64 > Description:        P

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Andres Freund's message of mar jul 27 17:20:37 -0400 2010: >> I guess youve compiled with --enable-cassert and Kenchiro-san has not? > Eh, of course. I'm just pointing out that this is a serious bug :-) > I spent some time looking at the code, but the EvalP

Re: [BUGS] BUG #5574: PANIC on hot-standby: heap_update_redo

2010-07-27 Thread valgog
On Jul 27, 5:02 pm, val...@gmail.com ("Valentine Gogichashvili") wrote: > The following bug has been logged online: > > Bug reference:      5574 > Logged by:          Valentine Gogichashvili > Email address:      val...@gmail.com > PostgreSQL version: 9.0beta3 > Operating system:   RedHat Linux (2.

Re: [BUGS] BUG #5574: PANIC on hot-standby: heap_update_redo

2010-07-27 Thread Tom Lane
"Valentine Gogichashvili" writes: > A hot-standby machine was recieving WAL files for 2 days now (omnipitr > scripts), and then it crashed with the following error: > 2010-07-27 15:26:09.759 CEST,,,22151,,4c49acba.5687,5697,,2010-07-23 > 16:52:42 CEST,1/0,0,PANIC,XX000,"heap_update_redo: invalid

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Alvaro Herrera
Excerpts from Andres Freund's message of mar jul 27 17:20:37 -0400 2010: > On Tue, Jul 27, 2010 at 04:13:56PM -0400, Alvaro Herrera wrote: > > Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010: > > > > > This is a bug report. > > > When I tested in PostgreSQL9 beta3,I got a

Re: [BUGS] pg_upgrade issues

2010-07-27 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from depstein's message of lun jul 26 08:05:24 -0400 2010: >> I just want to note that one reason regclass may be used in user tables (as >> opposed to, say, regtype) is that in PL/pgSQL trigger procedures there is a >> special variable TG_RELID, which provides

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Andres Freund
On Tue, Jul 27, 2010 at 04:13:56PM -0400, Alvaro Herrera wrote: > Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010: > > > This is a bug report. > > When I tested in PostgreSQL9 beta3,I got an error. > > > > == > > select * fr

Re: [BUGS] failed to fetch tuple for EvalPlanQual recheck

2010-07-27 Thread Alvaro Herrera
Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010: > This is a bug report. > When I tested in PostgreSQL9 beta3,I got an error. > > == > select * from part_bug where HIRENUM=4 for update; > failed to fetch tuple for EvalPlan

[BUGS] BUG #5574: PANIC on hot-standby: heap_update_redo

2010-07-27 Thread Valentine Gogichashvili
The following bug has been logged online: Bug reference: 5574 Logged by: Valentine Gogichashvili Email address: val...@gmail.com PostgreSQL version: 9.0beta3 Operating system: RedHat Linux (2.4.21-53.ELsmp) Description:PANIC on hot-standby: heap_update_redo Details:

Re: [BUGS] BUG #5573: How can i add field inbetween in the table while creating

2010-07-27 Thread Kevin Grittner
"Vimi" wrote: > How can i add field inbetween in the table while creating This is not a bug; in the future please post such questions to pgsql-general. While the feature you're requesting is likely to appear in a future release, current releases require that you create a new table with the d

Re: [BUGS] BUG #5573: How can i add field inbetween in the table while creating

2010-07-27 Thread Joshua Tolley
On Tue, Jul 27, 2010 at 07:34:56AM +, Vimi wrote: > If i have already crreated one table and i wan to add one more field into > table but its ibetween imean if i have 4 fields are already created and if i > want to add one more field aat 2nd index then how can i do in postgre. i > tried in Navi

[BUGS] BUG #5573: How can i add field inbetween in the table while creating

2010-07-27 Thread Vimi
The following bug has been logged online: Bug reference: 5573 Logged by: Vimi Email address: vimmip...@gmail.com PostgreSQL version: Ver 8.4.1 Operating system: Windows 7 Description:How can i add field inbetween in the table while creating Details: If i have alread