Re: INSERTs slow - Mailing list pgsql-general

From Dominique ROUSSEAU
Subject Re: INSERTs slow
Date
Msg-id 20020327094507.W31997@neuronnexion.fr
Whole thread Raw
In response to INSERTs slow  (Dominique ROUSSEAU <d.rousseau@nnx.com>)
List pgsql-general
Le Wed, Mar 27, 2002 at 07:22:01AM +0200, Dirk Broodryk [dirkb%ferreiragroup.co.za@ferreiragroup.co.za] a écrit:
> Just a notion.. try varchar . .read someware that it's faster accessing it
> than normal char.. I have a table with 8 mill records, and find it not to
> bad..

you mean that indices on VARCHAR() would be faster than indices on
CHAR() ??

Dom

--
Dominique Rousseau <d.rousseau@nnx.com>
Neuronnexion - http://www.neuronnexion.com

pgsql-general by date:

Previous
From: Denis Gasparin
Date:
Subject: Re: Altering a CHAR(4) column CHAR(5) changing
Next
From:
Date:
Subject: Re: Test data sets