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: pgsql-performance@postgresql.org
Sent: Tuesday, December 05
]
To: Alexandru Coseru [EMAIL PROTECTED]
Cc: Heikki Linnakangas [EMAIL PROTECTED];
pgsql-performance@postgresql.org
Sent: Sunday, December 03, 2006 6:05 AM
Subject: Re: [PERFORM] Regex performance issue
Alexandru Coseru [EMAIL PROTECTED] writes:
Anyway , anybody has a clue why this regex is that CPU
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
Hello..
Yes , sorry for the mistype..
Regards
Alex
- Original Message -
From: Josh Berkus josh@agliodbs.com
To: pgsql-performance@postgresql.org
Cc: Alexandru Coseru [EMAIL PROTECTED]
Sent: Sunday, December 03, 2006 10:11 PM
Subject: Re: [PERFORM] Hardware advice
Alexandru
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
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 PROTECTED];
pgsql-performance@postgresql.org
Sent: Saturday
]
To: Alexandru Coseru [EMAIL PROTECTED]
Cc: Dave Dutcher [EMAIL PROTECTED]; pgsql-performance@postgresql.org
Sent: Sunday, December 03, 2006 12:04 AM
Subject: Re: [PERFORM] Regex performance issue
Alexandru Coseru wrote:
I cannot use LIKE , because the order of the match is reversed
Coseru [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
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 database...
This is why i'm
oleg@sai.msu.su
To: Alexandru Coseru [EMAIL PROTECTED]
Cc: Dave Dutcher [EMAIL PROTECTED]; pgsql-performance@postgresql.org
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 for basic