Re: [GENERAL] Large databases, performance - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: [GENERAL] Large databases, performance
Date
Msg-id cl83quoi1kt2ebcsbajm18iekkporrj9f5@4ax.com
Whole thread Raw
In response to Re: [GENERAL] Large databases, performance  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-performance
On Mon, 07 Oct 2002 19:48:31 +0530, "Shridhar Daithankar"
<shridhar_daithankar@persistent.co.in> wrote:
>I say if it's a char field, there should be no indicator of length as it's not
>required. Just store those many characters straight ahead..

This is out of reach for a quick hack ...

>Sure. But the server machine is not available this week. Some other project is
>using it. So the results won't be out unless at least a week from now.

 :-)

>This time results are correct. Postgresql loads data faster, indexes it faster
>and queries in almost same time.. Way to go..

Great!  And now let's work on making selects faster, too.

Servus
 Manfred

pgsql-performance by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: [GENERAL] Large databases, performance
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Large databases, performance