On 2015-05-15 18:31, Scott Marlowe wrote:
> On Fri, May 15, 2015 at 9:18 AM, Job wrote:
>> i have a table of about 10 millions of records, with the index on a string
>> field.
>> Actually is alphabetical; since queries are about 100/200 per seconds, i was
>> looking for a better way to improve p
Good luck.
Best Regards
Farjad Farid
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Job
Sent: 15 May 2015 16:19
To: pgsql-general@postgresql.org
Subject: [GENERAL] Index on integer or on string field
Hello,
i have a
On Fri, May 15, 2015 at 9:18 AM, Job wrote:
> Hello,
>
> i have a table of about 10 millions of records, with the index on a string
> field.
> Actually is alphabetical; since queries are about 100/200 per seconds, i was
> looking for a better way to improve performance and reduce workload.
>
> T
gmail.com]
>> *Inviato:* venerdì 15 maggio 2015 17.26
>> *A:* Job
>> *Cc:* pgsql-general@postgresql.org
>> *Oggetto:* Re: [GENERAL] Index on integer or on string field
>>
>> You should probably experiment with a btree-gin index on those.
>> Em 15/05/2015 12:22
m]
> *Inviato:* venerdì 15 maggio 2015 17.26
> *A:* Job
> *Cc:* pgsql-general@postgresql.org
> *Oggetto:* Re: [GENERAL] Index on integer or on string field
>
> You should probably experiment with a btree-gin index on those.
> Em 15/05/2015 12:22, "Job" escreveu:
>
u!
> Francesco
>
> Da: Arthur Silva [arthur...@gmail.com]
> Inviato: venerdì 15 maggio 2015 17.26
> A: Job
> Cc: pgsql-general@postgresql.org
> Oggetto: Re: [GENERAL] Index on integer or on string field
>
> You should probably experiment with a btree-gin index on those.
> Em
___
Da: Arthur Silva [arthur...@gmail.com]
Inviato: venerdì 15 maggio 2015 17.26
A: Job
Cc: pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] Index on integer or on string field
You should probably experiment with a btree-gin index on those.
Em 15/05/2015 12:22, "Job"
mailto:j...@
You should probably experiment with a btree-gin index on those.
Em 15/05/2015 12:22, "Job" escreveu:
> Hello,
>
> i have a table of about 10 millions of records, with the index on a string
> field.
> Actually is alphabetical; since queries are about 100/200 per seconds, i
> was looking for a bett
Hello,
i have a table of about 10 millions of records, with the index on a string
field.
Actually is alphabetical; since queries are about 100/200 per seconds, i was
looking for a better way to improve performance and reduce workload.
The unique values, of that fields, are about the 50 (categor
