>Well the test runs were for 10GB of data. Schema is attached. Read in fixed 
>fonts..Last nullable fields are dummies but may be used in fututre and
varchars 
>are not acceptable(Not my requirement). Tuple size is around 100 bytes..
>The index creation query was
>
>CREATE INDEX index1 ON tablename (esn,min,datetime);
>
>What if I put datetime ahead? It's likely the the datetime field will have
high 
>degree of locality being log data..

Just an idea, I noticed you use char(10) for esn and min, and use this as
index. Are these really fixed len fields all having 10 bytes? Otherwise
varchar(10) would be better, because your tables, and especially the indices
will be probably much smaller.

what average length do you have for min and esn?

Thu, 26 Sep 2002 11:50:08 +0200
"Mario Weilguni" <mario.weilguni@icomedias.com>
Re: Performance while loading data and indexing
On 26 Sep 2002 at 11:50, Mario Weilguni wrote:

> >Well the test runs were for 10GB of data. Schema is attached. Read in fixed 
> >fonts..Last nullable fields are dummies but may be used in fututre and
> varchars 
> >are not acceptable(Not my requirement). Tuple size is around 100 bytes..
> >The index creation query was
> >
> >CREATE INDEX index1 ON tablename (esn,min,datetime);
> >
> >What if I put datetime ahead? It's likely the the datetime field will have
> high 
> >degree of locality being log data..
> 
> Just an idea, I noticed you use char(10) for esn and min, and use this as
> index. Are these really fixed len fields all having 10 bytes? Otherwise
> varchar(10) would be better, because your tables, and especially the indices
> will be probably much smaller.
> 
> what average length do you have for min and esn?

10 bytes. Those are id numbers.. like phone numbers always have all the digits 
filled in..



Bye
 Shridhar

--
Bradley's Bromide:	If computers get too powerful, we can organize	them into a 
committee -- that will do them in.


Thu, 26 Sep 2002 15:28:01 +0530
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Performance while loading data and indexing
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> On 26 Sep 2002 at 11:50, Mario Weilguni wrote:
>> Just an idea, I noticed you use char(10) for esn and min, and use this as
>> index. Are these really fixed len fields all having 10 bytes?

> 10 bytes. Those are id numbers.. like phone numbers always have all the digits 
> filled in..

If they are numbers, can you store them as bigints instead of char(N)?

			regards, tom lane

Thu, 26 Sep 2002 10:37:35 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Performance while loading data and indexing 