On Sun, Dec 9, 2012 at 10:59 PM, Condor wrote:
> On 2012-12-10 00:31, Jeff Janes wrote:
>>
>> On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote:
>>
>>> create index clients_tbl_firstname_idx on clients_tbl using btree
>>> (firstname
>>> COLLATE "bg_BG" text_pattern_ops);
>>
>>
>> I don't understand w
On 2012-12-10 00:31, Jeff Janes wrote:
On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote:
I am interested to know where is my mistake or something wrong
with server which I doubt. Here is my current query with explain:
(I change names to XXX YYY ZZZ because original names is written on
CP1251
and
On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote:
> I am interested to know where is my mistake or something wrong
> with server which I doubt. Here is my current query with explain:
> (I change names to XXX YYY ZZZ because original names is written on CP1251
> and most ppl in list can't read them)
>
Hello,
Yesterday when I read the email I came across an issue and I thought
very interesting result. The topic is: "Table with million rows - and
PostgreSQL 9.1 is not using the index". I decided to try it because from
250 ms with millions rows to 15 ms is very good, but I did not get the
expe
