Tom Lane wrote:
>
> Dale Walker <[EMAIL PROTECTED]> writes:
> > I use the 'hash' type as queries regarding usage will always be of the
> > form "select .. where username='xxx';"
>
> Use a btree anyway. Postgres' btree implementation is much better than
> its hash index implementation.
>
O
Dale Walker <[EMAIL PROTECTED]> writes:
> I use the 'hash' type as queries regarding usage will always be of the
> form "select .. where username='xxx';"
Use a btree anyway. Postgres' btree implementation is much better than
its hash index implementation.
> insert into sumlog
> selec
I record our radius logs in a firly basic table, schema is as follows:
--
CREATE TABLE "history_new" (
"username" character varying(50) NOT NULL,
"time_stamp" int4 NOT NULL,
"acctstatustype" character varying(8) NOT
