Re: PGSQL and DNCL - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: PGSQL and DNCL
Date
Msg-id 200312041215.hB4CFjH16266@candle.pha.pa.us
Whole thread Raw
In response to PGSQL and DNCL  (Renney Thomas <renneyt@yahoo.com>)
List pgsql-admin
Renney Thomas wrote:
> Has anyone any experience with PGSQL 7.x and implenting the FTC
> do-not-call list - which is about 50 million 10 digit N. American phone
> numbers? If so what structures have you used and what have you done
> interms of performance tweaks? Is there an equivalent to Oracle's IOT
> (index organized tables)  in PGSQL?

We have a CLUSTER command.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: incremental backup
Next
From: "Glenn Wiorek"
Date:
Subject: Re: see previous queries