Re: Sorting Problem

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: Gianni Mariani <gianni(at)mariani(dot)ws>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting Problem
Date: 2003-08-13 18:33:31
Message-ID: 3F3A847B.5020007@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Perhaps the only way to get around the cache problem is to use an ISO-8859-x 8bit character set, but to have per table, or per column encoding attributes. And of course, ways to access what those are, in the Postgres API. Good for speed, but not for easy storing of multiple language/encodings per column/table.

Gianni Mariani wrote:

> Dennis Gearon wrote:
>
>> I agree with all of that except for one caveat:
>>
>> all my reading, and just general off the cuff thinking, says that
>> processing variable width characters SIGNIFICANTLY slows an
>> application. It seems better to PROCESS fixed width characters (1,2,4
>> byte), and TRANSMIT variable width characters (avoiding the null
>> problem.)
>
>
>
> I can and have solved that problem. If you can assume utf-8 encoding
> then there are available to you a bunch o tricks that takes this problem
> away.
>
> The other problem with memory (and hence cache) utilization of a wide
> char only solution it far more significant.
> Cache effects are the primary killer for performance in an app like a
> database.
>
> Anyhow, before making any "decisions" one should do a bunch of analysis.
>
> Cheers
> G
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message w00t 2003-08-13 18:51:24 Searching Tables
Previous Message Dennis Gearon 2003-08-13 18:30:07 Re: Sorting Problem