[SQL] A more efficient way?

2010-10-31 Thread James Cloos
I've a third-party app which is slower than it ought to be. It does one operation in particular by doing a query to get a list of rows, and then iterates though them to confirm whether it actually wants that row. As you can imagine that is very slow. This query gets the correct data set in one

Re: [SQL] A more efficient way?

2010-10-31 Thread Tom Lane
James Cloos cl...@jhcloos.com writes: I've a third-party app which is slower than it ought to be. It does one operation in particular by doing a query to get a list of rows, and then iterates though them to confirm whether it actually wants that row. As you can imagine that is very slow.

Re: [SQL] large xml database

2010-10-31 Thread Viktor Bojović
On Sun, Oct 31, 2010 at 7:08 AM, Lutz Steinborn l.steinb...@4c-ag.dewrote: On Sat, 30 Oct 2010 23:49:29 +0200 Viktor Bojović viktor.bojo...@gmail.com 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

Re: [SQL] large xml database

2010-10-31 Thread Viktor Bojović
On Sun, Oct 31, 2010 at 2:26 AM, James Cloos cl...@jhcloos.com wrote: VB == Viktor Bojović viktor.bojo...@gmail.com writes: VB i have very big XML documment which is larger than 50GB and want to VB import it into databse, and transform it to relational schema. Were I doing such a

Re: [SQL] large xml database

2010-10-31 Thread Rob Sargent
Viktor Bojovic' wrote: On Sun, Oct 31, 2010 at 2:26 AM, James Cloos cl...@jhcloos.com mailto:cl...@jhcloos.com wrote: VB == Viktor Bojovic' viktor.bojo...@gmail.com mailto:viktor.bojo...@gmail.com writes: VB i have very big XML documment which is larger than 50GB and

Re: [SQL] large xml database

2010-10-31 Thread Viktor Bojović
On Sun, Oct 31, 2010 at 9:42 PM, Rob Sargent robjsarg...@gmail.com wrote: Viktor Bojovic' wrote: On Sun, Oct 31, 2010 at 2:26 AM, James Cloos cl...@jhcloos.com mailto: cl...@jhcloos.com wrote: VB == Viktor Bojovic' viktor.bojo...@gmail.com mailto:viktor.bojo...@gmail.com

Re: [SQL] large xml database

2010-10-31 Thread Rob Sargent
Viktor Bojović wrote: On Sun, Oct 31, 2010 at 9:42 PM, Rob Sargent robjsarg...@gmail.com mailto:robjsarg...@gmail.com wrote: Viktor Bojovic' wrote: On Sun, Oct 31, 2010 at 2:26 AM, James Cloos cl...@jhcloos.com mailto:cl...@jhcloos.com

Re: [SQL] large xml database

2010-10-31 Thread Viktor Bojović
On Sun, Oct 31, 2010 at 10:26 PM, Rob Sargent robjsarg...@gmail.com wrote: Viktor Bojović wrote: On Sun, Oct 31, 2010 at 9:42 PM, Rob Sargent robjsarg...@gmail.commailto: robjsarg...@gmail.com wrote: Viktor Bojovic' wrote: On Sun, Oct 31, 2010 at 2:26 AM, James Cloos

Re: [SQL] large xml database

2010-10-31 Thread Rob Sargent
Skipping much of the included thread, urgently. btw. you have mentioned This I believe would parse nicely into a tidy but non-trivial schema directly, does it mean that postgre has a support for restoring the database schema from xml files? -- --- Viktor