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

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

> # - 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/