[PERFORM] Multicolumn B-Tree index - order by on 1st column and IN lookup for 2nd

I created such table (similar to example from http://use-the-index-luke.com/sql/example-schema/postgresql/performance-testing-scalability ) CREATE TABLE scale_data ( section NUMERIC NOT NULL, id1 NUMERIC NOT NULL, -- unique values simulating ID or Timestamp id2 NUMERIC NOT NULL --

[PERFORM] What's the state of postgresql on ext4 now?

I know there were a lot of performance issues with ext4, but i don't know the state of it now. I have a private openstreetmap server installed on a ubuntu 11.10 64bit pc with both partitions (/ and /home) formated with ext4. My problem is that the server works very slow.

Re: [PERFORM] Hardware advice

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

Re: [PERFORM] Hardware advice

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

[PERFORM] Hardware advice

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

Re: [PERFORM] Regex performance issue

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

Re: [PERFORM] Regex performance issue

;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

Re: [PERFORM] Regex performance issue

nd how can it be optimized ? Is there a way to trace the system calls ? strace doesn't give me anything else but some lseeks and reads... PS: Tried it with a 8.2 snaphsot and the result is the same.. Regards Alex - Original Message - From: "Heikki Linnakangas" <[EMAIL

Re: [PERFORM] Regex performance issue

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

Re: [PERFORM] Regex performance issue

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

[PERFORM] Regex performance issue

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 -