Re: INSERTs slow

From: Dominique ROUSSEAU <d(dot)rousseau(at)nnx(dot)com>
To: Dirk Broodryk <dirkb%ferreiragroup(dot)co(dot)za(at)ferreiragroup(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERTs slow
Date: 2002-03-27 08:45:07
Message-ID: 20020327094507.W31997@neuronnexion.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le Wed, Mar 27, 2002 at 07:22:01AM +0200, Dirk Broodryk [dirkb%ferreiragroup(dot)co(dot)za(at)ferreiragroup(dot)co(dot)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(dot)rousseau(at)nnx(dot)com>
Neuronnexion - http://www.neuronnexion.com

In response to

  • INSERTs slow at 2002-03-26 09:07:30 from Dominique ROUSSEAU

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-03-27 10:40:19 getting rid of characters in database
Previous Message tsmets 2002-03-27 08:38:58 Re: Test data sets