[PERFORM] CPU 0.1% IOWAIT 99% for decisonnal queries

I could create and populate my databases into ?...since the databases does not support updates for this application. Sorry for my naive questions and my poor english but any help or advise will be greatly appreciated ! Patrick Vedrines PS (maybe of interest for some users like me) : I created a partiti

Re: [PERFORM] CPU 0.1% IOWAIT 99% for decisonnal queries

Hello Gustavo, Your question seems to say that you suspect a disk issue, and a few hours later, Simon told me "Sounds like your disks/layout/something is pretty sick". To be clear in my own mind about it, I've just copyed (time cp) the "aggregate" table files (4 Gb) from one disk to an

Re: [PERFORM] CPU 0.1% IOWAIT 99% for decisonnal queries

Hello Simon, Sounds like your disks/layout/something is pretty sick. You don't mention I/O bandwidth, controller or RAID, so you should look more into those topics.Well seen ! (as we say in France). As I said to Gustavo, your last suspicion took me into a simple disk test: I've just

Re: [PERFORM] CPU 0.1% IOWAIT 99% for decisonnal queries

Hello Richard, Perhaps look into clustering the tables. Good idea : I will try to go further into this way. There is no index on the aggregate table since the criterias, their number and their scope are freely choosen by the customers. Hmm... not convinced this is a good idea. Long days

Re: [PERFORM] CPU 0.1% IOWAIT 99% for decisonnal queries

To: Patrick Vedrines Cc: performance pgsql Sent: Thursday, March 24, 2005 12:52 PM Subject: Re: [PERFORM] CPU 0.1% IOWAIT 99% for decisonnal queries Good day Patrick! I can help you to design you disk layout for better perform and security. Please, tell me how many disks

Re: [PERFORM] Left Outer Join much faster than non-outer Join?

[EMAIL PROTECTED] writes: streetname_lookup (for every street name used in the country) streetid | name | type --++-- 1 | Main | St 2 | 1st | St Afa I'm concerned, I would add the column city_id since 2