От: mmiranda@americatel.com.sv
Тема: Re: Final decision
Дата: ,
Msg-id: 76E0DAA32C39D711B6EC0002B364A6FA0440F82F@amsal01exc01.americatel.com.sv
(см: обсуждение, исходный текст)
Ответ на: Final decision  ("Joel Fradkin")
Ответы: Re: Final decision  ("Joel Fradkin")
Список: pgsql-performance

Скрыть дерево обсуждения

Final decision  ("Joel Fradkin", )
 Re: Final decision  (, )
  Re: Final decision  ("Joel Fradkin", )
 Re: Final decision  (Rod Taylor, )
 Re: Final decision  (Josh Berkus, )
  Re: Final decision  ("Joel Fradkin", )
 Re: Final decision  ("Dave Page", )
  Re: Final decision  (Josh Berkus, )
  Re: Final decision  ("Joshua D. Drake", )
   Re: Final decision  ("Joshua D. Drake", )
   Re: Final decision  (Steve Poe, )
 Re: Final decision  (John A Meinel, )
  Re: Final decision  ("Joel Fradkin", )
   Re: Final decision  (John A Meinel, )
 Re: Final decision  ("Dave Page", )
  Re: Final decision  (Josh Berkus, )
   ODBC driver overpopulation (was Re: Final decision)  (Alvaro Herrera, )
    Re: ODBC driver overpopulation (was Re: Final decision)  ("Joshua D. Drake", )
     Re: ODBC driver overpopulation (was Re: Final decision)  (Bruce Momjian, )
  Re: Final decision  ("Joshua D. Drake", )
   Re: Final decision  (Bruce Momjian, )
 Re: Final decision  ("Dave Page", )

 
-----Original Message-----
From: [mailto:]On Behalf Of Joel Fradkin
Sent: Wednesday, April 27, 2005 9:02 AM
To: PostgreSQL Perform
Subject: [PERFORM] Final decision

I spent a great deal of time over the past week looking seriously at Postgres and MYSQL.

Objectively I am not seeing that much of an improvement in speed with MYSQL, and we have a huge investment in postgrs.

So I am planning on sticking with postgres fro our production database (going live this weekend).

 

Many people have offered a great deal of help and I appreciate all that time and energy.

I did not find any resolutions to my issues with Commandprompt.com (we only worked together 2.5 hours).

 

Most of my application is working about the same speed as MSSQL server (unfortunately its twice the speed box, but as many have pointed out it could be an issue with the 4 proc dell). I spent considerable time with Dell and could see my drives are delivering 40 meg per sec.

 

Things I still have to make better are my settings in config, I have it set to no merge joins and no seq scans.

I am going to have to use flattened history files for reporting (I saw huge difference here the view for audit cube took 10 minutes in explain analyze and the flattened file took under one second).

 

I understand both of these practices are not desirable, but I am at a place where I have to get it live and these are items I could not resolve.

I may try some more time with Commanpromt.com, or seek other professional help.

 

In stress testing I found Postgres was holding up very well (but my IIS servers could not handle much of a load to really push the server).

I have a few desktops acting as IIS servers at the moment and if I pushed past 50 consecutive users it pretty much blew the server up.

On inserts that number was like 7 consecutive users and updates was also like 7 users.

 

I believe that was totally IIS not postgres, but I am curious as to if using postgres odbc will put more stress on the IIS side then MSSQL did.

I did have a question if any folks are using two servers one for reporting and one for data entry what system should be the beefier?

I have a 2proc machine I will be using and I can either put Sears off by themselves on this machine or split up functionality and have one for reporting and one for inserts and updates; so not sure which machine would be best for which spot (reminder the more robust is a 4proc with 8 gigs and 2 proc is 4 gigs, both dells).

 

Thank you for any ideas in this arena.

 

Joel Fradkin

 

 

 

 

 

 

You didnt tell us what OS are you using, windows?

If you want good performance you must install unix on  that machine,

 

---

 

 


В списке pgsql-performance по дате сообщения:

От: "Jim C. Nasby"
Дата:
Сообщение: Re: Joel's Performance Issues WAS : Opteron vs Xeon
От: Greg Stark
Дата:
Сообщение: Re: Why is this system swapping?