| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Joey Quinn <bjquinniii(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: tracking scripts... |
| Date: | 2013-11-26 20:00:27 |
| Message-ID: | CALd+dcdyTTubxFNnGKHKjjYP0P31c9qG+CEtegKxy6N00B8uoQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn <bjquinniii(at)gmail(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-11-26 20:05:42 | Re: AccessShareLock and Resource Contention |
| Previous Message | Martijn van Oosterhout | 2013-11-26 19:51:22 | Re: having difficulty with explain analyze output |