Re: [SQL] large xml database

2010-10-30 Thread Lutz Steinborn
On Sat, 30 Oct 2010 23:49:29 +0200 Viktor Bojović wrote: > > many tries have failed because 8GB of ram and 10gb of swap were not enough. > also sometimes i get that more than 2^32 operations were performed, and > functions stopped to work. > we have a similar problem and we use the Amara xml To

Re: [SQL] wired behaviour

2008-11-28 Thread Lutz Steinborn
t; > > Amyyon > Bijsterhuizen 11.58 > 6546 AS Nijmegen > 050 - 311 5686 > www.amyyon.nl > -Oorspronkelijk bericht- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens Lutz Steinborn > Verzonden: vrijdag 28 november 2008 14:52 > Aan: pgsql-sql@postgr

[SQL] wired behaviour

2008-11-28 Thread Lutz Steinborn
Hello, I have an problem understanding a simple query: For example I have the following: select count(*) from foo; gives me 1000 select count(*) from foo where bar = 'Mr Spock'; gives me 5 select count(*) from foo where NOT bar = 'Mr Spock'; gives me 857 Why I'm not getting 955 for the last qu