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

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