Gregory, thanks for good questions! :))
I got more lights on my throughput here :))
The running OS is Solaris9 (customer is still not ready to upgrade to
Sol10), and I think the main "sync" issue is coming from the old UFS
implementation... UFS mounted with 'forcedirectio' option uses
different "
Hi
I have the following scenario for a database that I need to design, and
would like some hints on what to improve or do differently to achieve the
desired performance goal, disregarding hardware and postgres tuning.
The premise is an attribute database that stores about 100 different
attribute
I would strongly suggest that you use a proper relational schema,
instead of storing everything in two tables. I don't know your
application, but a schema like that is called an Entity-Attribute-Value
(though your entity seems to be just posx and posy) and it should raise
a big red flag in the
> I would strongly suggest that you use a proper relational schema,
> instead of storing everything in two tables. I don't know your
> application, but a schema like that is called an Entity-Attribute-Value
> (though your entity seems to be just posx and posy) and it should raise
> a big red flag i
On 7/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I would strongly suggest that you use a proper relational schema,
> instead of storing everything in two tables. I don't know your
> application, but a schema like that is called an Entity-Attribute-Value
> (though your entity seems to be
> On 7/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> I don't know much about this EAV stuff. Except to say that my company is
> in
> a situation with a lot of adds and bulk deletes and I wish the tables were
> designed with partitioning in mind. That is if you know how much, order of
> mag
On 7/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> On 7/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> I don't know much about this EAV stuff. Except to say that my company is
> in
> a situation with a lot of adds and bulk deletes and I wish the tables
were
> designed with partiti
Hello all,
I've made the changes to view to use UNION ALL and the where NOT IN
suggestions...the query now takes a little under 3 hours instead of 5 --
here is the EXPLAIN ANALYZE:
*
smiley2211 wrote:
>
> Hello all,
>
> I've made the changes to view to use UNION ALL and the where NOT IN
> suggestions...the query now takes a little under 3 hours instead of 5 --
> here is the EXPLAIN ANALYZE:
It seems you have disabled nested loops --- why? Try turning them back
on and let us
[EMAIL PROTECTED] wrote:
I would strongly suggest that you use a proper relational schema,
instead of storing everything in two tables. I don't know your
application, but a schema like that is called an Entity-Attribute-Value
(though your entity seems to be just posx and posy) and it should raise
Heikki Linnakangas wrote:
ISTM that a properly normalized schema would look something like this:
create table position (
posX int not null,
posY int not null,
primary key (posX, posY)
);
create table colour (
posX int not null,
posY int not null,
colour varchar(50) not null,
prim
Tom Lane wrote:
> PFC <[EMAIL PROTECTED]> writes:
>>> What version of PostgreSQL are you using?
>
>> I think newbies should be pushed a bit to use the latest versions,
>
> How about pushed *hard* ? I'm constantly amazed at the number of people
> who show up in the lists saying they installe
Hello,
How can I know my PostgreSQL 8 is using direct I/O or buffered I/O? If using
buffered I/O, how can I enable direct I/O? What is the performance difference
of them?
This is urgent, Thanks.
_
Windows Live Spaces is here! It’s e
Hello,
I have seen some performance testing indicates that apparently the PostgreSQL 8
is faster in writing data while seems like Oracle 10g is better in reading data
from database, can any one tell me why? Or is there anyone done performance
benchmark on them before?
This is urgent.
Thanks.
__
lai yoke hman <[EMAIL PROTECTED]> writes:
> I have seen some performance testing indicates that apparently the PostgreSQL
> 8 is faster in writing data while seems like Oracle 10g is better in reading
> data from database, can any one tell me why? Or is there anyone done
> performance benchmark
Magnus,
"don't bother reporting a bug
unless you're on the latest in a branch, and at least make sure you're
on one of the maojr releases listed on www.postgresql.org"?
Seems reasonable?
absolutely. Should be standard practice.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald A
16 matches
Mail list logo
