> I'm trying to get a query to run fast enough for interactive use. I've gotten
> some speed-up, but still not there. It is for a tool called IRRExplorer
> (http://irrexplorer.nlnog.net/) that correlates IP routes between Internet
> Route Registries and real-world routing information. We landed on
Johann Spies writes:
> Some of hour queries to extract the data and insert it in other tables runs
> for days and in one case we have created a table with 758million unique
> records.
> Now my question. Is there a way to monitor the progress of a long running
> query like this?
You could watch h
Hi
I'm trying to get a query to run fast enough for interactive use. I've gotten
some speed-up, but still not there. It is for a tool called IRRExplorer
(http://irrexplorer.nlnog.net/) that correlates IP routes between Internet
Route Registries and real-world routing information. We landed on Pos
Working with 9.4.
We are in the process of unpacking complicated XML-data into tables.
XML-data are already in a table with two fields (id, xml) - 47+ million
records.
Some of hour queries to extract the data and insert it in other tables runs
for days and in one case we have created a table with
