I have found the reason!!! I begin to see line by line postgresql.conf and saw
ssl = true.
I have disabled ssl and then I have restarted the server and that's all. It's 4
or 5 times faster than the old server.
I don't understand why PgAdmin is connecting using ssl if I have leave this
field empt
Hi Greg this is my Bonnie result.
Version 1.03 --Sequential Output-- --Sequential Input- --Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
insaubi 8G 2589
It's a Debian 4.0r1 server without sound (alsa is disabled), I'm running the
querys locally.
It's happening running the query locally with PgAdmin and by jdbc locally too.
Yes I have win98, XP machines on my network, I will unplugged from the net and
test again. On monday I'll give you my answer.
> > >> > That's not what it looks like based on the EXPLAIN ANALYZE output.
> > >> > It looks like run time dropped from two seconds to half a second.
> > >>
> > >> > It seems as though you either have a network delay delivering the
> > >> > results,
> > >> > or your application is slow to read
>> > That's not what it looks like based on the EXPLAIN ANALYZE output.
>> > It looks like run time dropped from two seconds to half a second.
>>
>> > It seems as though you either have a network delay delivering the results,
>> > or your application is slow to read them.
>>
>> > Exactly how are
> That's not what it looks like based on the EXPLAIN ANALYZE output.
> It looks like run time dropped from two seconds to half a second.
> It seems as though you either have a network delay delivering the results,
> or your application is slow to read them.
> Exactly how are you arriving at thos
I forgot to tell this plan was with Postgres 8.1.9 in the new server with
postgres 8.2.4 in the new server the plan is the same as with te old one (the
little difference in rows retrieved is that the database is yesterday snapshot).
This is the plan for the new server with postgres 8.2.4:
Hash Jo
I'm doing several tests.
Right now I did a VACUUM FULL ANALYZE in both servers.
In the old one vacuum runs for about 354 seconds and in the new one 59 seconds.
Then I have ran
EXPLAIN ANALYZE
SELECT *
FROM fact_ven_renta fvr, dim_producto_std_producto dpp
WHERE
fvr.producto_std_producto_sk = dpp
My new server postgresql.conf is equal to the old one. I'm doubting this is a
hardware issue.
Googling with my hard HP Proliant ML 110 G3 I saw that IHC7 controller has some
problems, but looking and testing with hdparm it looks ok.
hdparm -tT /dev/sdaç
Timing cached reads: 1722 MB in 2.00 second
Hola Beto.
I have no idea where to look for that configuration or settings.
Yesterday I red about some drivers problems with SATA disk working togheter
with IDE devices with DMA.
Mi server server is a Pentium VI 3.3 with hyper threading (enabled in BIOS), HP
Proliant ML 110.
Then I entered to t
This is my dmesg file, I see there are some errors but I don't know how to
manage!!!
What do you mean with don't top post?
Sorry but I'm new with this kind of mailing list and I don't want to botter
some others.
Sorry my bad English too.
Thanks for your help
- Mensaje original
De: Sc
No, changing to fsync off didn't improve performance at all.
Settings
work_mem = 64MB
max_stack_depth = 7MB #in the old server is 8MB but if I set in here give me
the ulimit error
max_fsm_pages = 204800
effective_cache_size = 512MB
Atuvacuum is off.
I have run vacuum full and vacuum analyze. The
Hi all.
Recently I have installed a brand new server with a Pentium IV 3.2 GHz, SATA
Disk, 2GB of Ram in Debian 4.0r1 with PostgreSQL 8.2.4 (previously a 8.1.9).
I have other similar server with an IDE disk, Red Hat EL 4 and PostgreSQL 8.2.3
I have almost the same postgresql.conf in both servers,
13 matches
Mail list logo
