Re: tracking scripts...

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: tracking scripts...
Дата
Msg-id CALd+dcdyTTubxFNnGKHKjjYP0P31c9qG+CEtegKxy6N00B8uoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: tracking scripts...  (Joey Quinn <bjquinniii@gmail.com>)
Ответы Re: tracking scripts...  (Joey Quinn <bjquinniii@gmail.com>)
Список pgsql-general

On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn <bjquinniii@gmail.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: having difficulty with explain analyze output
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: AccessShareLock and Resource Contention