[BUGS] BUG #4819: Ordering big tables by indexed columns is very slow.

2009-05-20 Thread Alexei
The following bug has been logged online: Bug reference: 4819 Logged by: Alexei Email address: alexei_nova...@yahoo.com PostgreSQL version: 8.3.7 Operating system: Open SuSE 11.1 AMD Athlon 64 X2 Description:Ordering big tables by indexed columns is very slow. Details

Re: [BUGS] BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)

2009-05-20 Thread David Blewett
On Wed, May 20, 2009 at 8:48 AM, David Blewett wrote: > > In testing the beta to see if my planner issues might be resolved, I ran > into a situation where the 8.4 pg_dump created a dump for the hstore > contrib > module which would not restore against 8.4. It looks like this relates back to the

[BUGS] BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)

2009-05-20 Thread David Blewett
The following bug has been logged online: Bug reference: 4817 Logged by: David Blewett Email address: da...@dawninglight.net PostgreSQL version: 8.4beta2 Operating system: Gentoo Linux Description:Dump of 8.3 hstore not restorable to 8.4 (RECHECK) Details: In testin

Re: [BUGS] BUG #4816: NOT IN clause, doesn't work

2009-05-20 Thread hubert depesz lubaczewski
On Wed, May 20, 2009 at 09:37:56AM +, jose soares wrote: > I'm trying a NOT IN clause, but seems it doesn't work. Please take a look: the problem you're experiencing is described in here: http://www.depesz.com/index.php/2008/08/13/nulls-vs-not-in/ Best regards, depesz -- Linkedin: http://w

Re: [BUGS] BUG #4816: NOT IN clause, doesn't work

2009-05-20 Thread Rodriguez Fernando
jose soares escribió: The following bug has been logged online: Bug reference: 4816 Logged by: jose soares Email address: jose.sao...@sferacarta.com PostgreSQL version: 8.3.5 Operating system: x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1) 4.3.2 Descripti

[BUGS] BUG #4816: NOT IN clause, doesn't work

2009-05-20 Thread jose soares
The following bug has been logged online: Bug reference: 4816 Logged by: jose soares Email address: jose.sao...@sferacarta.com PostgreSQL version: 8.3.5 Operating system: x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1) 4.3.2 Description:NOT IN claus