Hello..
Thanks for the advices..
Actually , i'm waiting for the clovertown to show up on the market...
Regards
Alex
- Original Message -
From: "Sven Geisler" <[EMAIL PROTECTED]>
To: "Alexandru Coseru" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, D
Hello..
Yes , sorry for the mistype..
Regards
Alex
- Original Message -
From: "Josh Berkus"
To:
Cc: "Alexandru Coseru" <[EMAIL PROTECTED]>
Sent: Sunday, December 03, 2006 10:11 PM
Subject: Re: [PERFORM] Hardware advice
Alexandru,
The server will have
Hello..
I'm waiting for my new system , and meanwhile , i have some questions.
First , here are the specs:
The server will have kernel 2.1.19 and it will be use only as a postgresql
server (nothing else... no named,dhcp,web,mail , etc).
Postgresql version will be 8.2.
It will be heavily us
t; <[EMAIL PROTECTED]>
To: "Alexandru Coseru" <[EMAIL PROTECTED]>
Cc: "Heikki Linnakangas" <[EMAIL PROTECTED]>;
Sent: Sunday, December 03, 2006 6:05 AM
Subject: Re: [PERFORM] Regex performance issue
"Alexandru Coseru" <[EMAIL PROTECTED]> w
;Oleg Bartunov"
To: "Alexandru Coseru" <[EMAIL PROTECTED]>
Cc: "Dave Dutcher" <[EMAIL PROTECTED]>;
Sent: Saturday, December 02, 2006 10:54 PM
Subject: Re: [PERFORM] Regex performance issue
I may miss something but I'd use tsearch2. Check
intdict dictionary
PROTECTED]>
To: "Alexandru Coseru" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, December 03, 2006 12:35 AM
Subject: Re: [PERFORM] Regex performance issue
Alexandru Coseru wrote:
Hello..
I cannot use the first advice , because i'm not aware of the prefix
length in the datab
Linnakangas" <[EMAIL PROTECTED]>
To: "Alexandru Coseru" <[EMAIL PROTECTED]>
Cc: "Dave Dutcher" <[EMAIL PROTECTED]>;
Sent: Sunday, December 03, 2006 12:04 AM
Subject: Re: [PERFORM] Regex performance issue
Alexandru Coseru wrote:
I cannot use LIKE , b
nd
it's destination...(It's algeria mobile).
I tried to make with a query of using LIKE , but i was not able to get
something..
Regards
Alex
- Original Message -
From: "Dave Dutcher" <[EMAIL PROTECTED]>
To: "'Alexandru Coseru'" <[EMAIL P
Hello..
I have a low performance problem with regexp.
Here are the details:
asterisk=> explain analyze SELECT * FROM destlist WHERE '0039051248787' ~
prefix AND id_ent='-2' AND dir=0 ORDER by length(prefix) DESC;
QUERY PLAN
-
