Search Postgresql Archives

Re: tracking scripts...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



nope, that appears to be being blocked by the updates...

tried "select * from ipv4_table where country='gb' limit 1;"

it just sat there...


On Tue, Nov 26, 2013 at 3:00 PM, Vick Khera <vivek@xxxxxxxxx> wrote:

On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn <bjquinniii@xxxxxxxxx> wrote:
The ranges are indeed overlapping, though the update statements were generated alphabetically rather than in IP order... If the command line will let me query the table directly without being blocked by the ongoing updates, then I could get a rough order of magnitude of progress by doing a null count on the county field... hate to throw queries at it while it's busy updating though...

Try a SELECT ... LIMIT 1; it will find the first row that matches and exit. So you can see if any particular country code has been set. Again, binary search on the codes.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux