> > [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
ranklin Nóbrega - Planae
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.
Plea
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
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
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 ano
supports
only 'copy aggregate from' and 'select'.
- is it possible to define a sort of RAM filesystem (as it exists
in DOS/Windows) which I could create and populate my databases into
? ...since the databases does not support updates for this
application.
Sorry for my
