Re: Having problems with a 25 million row table on 8.1.3

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Having problems with a 25 million row table on 8.1.3
Дата
Msg-id 444E89E3.7090603@commandprompt.com
обсуждение исходный текст
Ответ на Having problems with a 25 million row table on 8.1.3  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список pgsql-general
> # - Memory -
>
> shared_buffers = 15000                  # min 16 or max_connections*2,
> 8KB each
> #temp_buffers = 1000                    # min 100, 8KB each
> #max_prepared_transactions = 5          # can be 0 or more
> # note: increasing max_prepared_transactions costs ~600 bytes of shared
> memory
> # per transaction slot, plus lock space (see max_locks_per_transaction).
> work_mem = 10240                        # min 64, size in KB
> maintenance_work_mem = 32768    # min 1024, size in KB
> #max_stack_depth = 2048                 # min 100, size in KB
>
> Anyone have any ideas on how to get all the unique tax codes from this
> table?

Push it to a cursor and select only pieces at a time?

Josuha D. Drkae

>
>
> Thanks in advance :-)
>
>
>
> Tony
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>


--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/



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

Предыдущее
От: "Don Walker"
Дата:
Сообщение: Please comment on the following OpenFTS/tsearch2 issues!
Следующее
От: Andrew - Supernews
Дата:
Сообщение: Re: Having problems with a 25 million row table on 8.1.3