Heiko Kehlenbrink wrote:
[EMAIL PROTECTED]:~> psql -d test -c 'explain analyse select avg(dist)
from massive2 where dist > (100*sqrt(3.0))::float8 and dist <
(150*sqrt(3.0))::float8;'
NOTICE: QUERY PLAN:
Aggregate (cost=14884.61..14884.61 rows=1 width=8) (actual
time=3133.24..3133.24 row
hello,
I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M RAM),
can anyone give me some advice?
On Tuesday 06 April 2004 09:01, huang yaqin wrote:
> hello,
>
> I have some question when I use postgresql 7.4.1 on redhat adv server 2.1
> . I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad
> performance. I can only do about 50 inserts per sencond. Event worse than
> my pc(P
huang yaqin wrote:
> hello,
>
> I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
> I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
> I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M
> RAM), can anyone
I seem to remember discussion of anticipatory vs deadline scheduler in 2.6.
Here is what Andrew Morton (I think) says:
"The deadline scheduler has two additional scheduling queues that were not
available to the 2.4 IO scheduler. The two new queues are a FIFO read queue
and a FIFO write queue. T
Heiko Kehlenbrink wrote:
Hmm... I would suggest if you are testing, you should try 7.4.2. 7.4 has
some
good optimisation for hash agregates though I am not sure if it apply to
averaging.
would be the last option till we are runing other applications on that 7.2
system
I can understand..
Also try f
Heiko Kehlenbrink wrote:
i want to convince people to use postgresql instead of ms-sql server, so i
set up a kind of comparission insert data / select data from postgresql /
ms-sql server
[...]
do you have any hints like compiler-flags and so on to get the answering
time from postgresql equal
This is what I got…
Two servers, one debian, one fedora
Debain dual 3ghz, 1 gig ram, ide, PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.95.4
Fedora: Dual 3ghz, 1 gig ram, scsi, PostgreSQL 7.3.4-RH on
i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC
On Tue, Apr 06, 2004 at 01:47:22AM -0400, Tom Lane wrote:
> Qing Zhao <[EMAIL PROTECTED]> writes:
> > We have got a G5 64-bit processor to replace an old G4 32-bit
> > processor. Given everything else equal, should we see a big
> > improvement on PG's performance?
>
> Nope. Database performance
huang yaqin <[EMAIL PROTECTED]> writes:
> I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
> I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
> I can only do about 50 inserts per sencond. Event worse than my pc(PIII 800,256M
> RAM), ca
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Qing Zhao" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 06, 2004 1:47 AM
Subject: Re: [PERFORM] possible improvement between G4 and G5
> Qing Zhao <[EMAIL PROTECTED]> writes:
> > We have got a G5 64-bit p
Aaron,
> I'm surprised by this thought. I tend to hit CPU bottlenecks more often than
> I/O ones. In most applications, db I/O is a combination of buffer misses and
> logging, which are both reasonably constrained.
Not my experience at all. In fact, the only times I've seen modern platforms
ma
huang yaqin wrote:
hello,
I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 .
I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance.
This is most likely a dual processor Xeon machine with HT, because the
x335 is limited to two physical cpus.
I am trying to find an efficient way to draw a random sample from a
complex query. I also want it to be easy to use within my application.
So I've defined a view that encapsulates the query. The id in the
"driving" table is exposed, and I run a query like:
select * from stats_record_view
whe
- Original Message -
From: "Josh Berkus" <[EMAIL PROTECTED]>
To: "Aaron Werman" <[EMAIL PROTECTED]>; "Qing Zhao" <[EMAIL PROTECTED]>;
"Tom Lane" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 06, 2004 2:52 PM
Subject: Re: [PERFORM] possible improvement between G4 and G5
Aaron,
> I do consulting, so they're all over the place and tend to be complex. Very
> few fit in RAM, but still are very buffered. These are almost all backed
> with very high end I/O subsystems, with dozens of spindles with battery
> backed up writethrough cache and gigs of buffers, which may be
hello！
Thanks, you are right.
I use "postmaster -o "-F" " to start my PG，and performance improved greatly.
Best regards,
huang yaqin
>huang yaqin <[EMAIL PROTECTED]> writes:
>> I have some question when I use postgresql 7.4.1 on redhat
17 matches
Mail list logo
