Re: [PERFORM] big databases & hospitals

2006-01-14 Thread Tomka Gergely
single node, single cpu, no HA or expensive RAID, because AFAIK FreeBSD in 2000 was not to good in this areas). Thanks, of course! -- Tomka Gergely Tudom, anyu. Sapka, sál, doksi. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[PERFORM] big databases & hospitals

2006-01-14 Thread Tomka Gergely
. Thanks. -- Tomka Gergely Tudom, anyu. Sapka, sál, doksi. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PERFORM] The results of my PostgreSQL/filesystem performance

2003-08-28 Thread Tomka Gergely
2003-08-28 ragyogó napján Ludek Finstrle ezt üzente: > > Intelligent feedback is welcome. > > > > http://www.potentialtech.com/wmoran/postgresql.php > > Good work. But I can't find information about xfs. Do you plan to add > this one FS in test? http://mail.s

Re: [PERFORM] The results of my PostgreSQL/filesystem performance

2003-08-28 Thread Tomka Gergely
unexpected for the opposite to > seem true. AFAIK *BSD better in the handling of big loads - maybe when multiple concurrent tests run against a linux and a bsd box, we see better result. Or not. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás vol

Re: [PERFORM] 8 way Intel Xeon system

2003-08-28 Thread Tomka Gergely
2003-08-27 ragyogó napján Christopher Browne ezt üzente: > After a long battle with technology,[EMAIL PROTECTED] (Tomka Gergely), an earthling, > wrote: > > 2003-08-27 ragyogó napján Castle, Lindsay ezt üzente: > >> Perhaps some may say Linux isn't the best option fo

Re: [PERFORM] Hardware recommendations to scale to silly load

2003-08-28 Thread Tomka Gergely
this, because on all ibm hw runs linux, and linux have more ways to do this :) -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..." ---(end of broadcast)--- TIP 7: don't forget to

Re: [PERFORM] Hardware recommendations to scale to silly load

2003-08-28 Thread Tomka Gergely
der linux :) Try xfs. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..." ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PERFORM] 8 way Intel Xeon system

2003-08-28 Thread Tomka Gergely
thrill, try 2.6-test series. Linux Is Good For You (tm) :) -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..." ---(end of broadcast)--- TIP 6: Have you searched our list arch

Re: [PERFORM] Tests

2003-08-28 Thread Tomka Gergely
tests, Horváth Szabolcs -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..." ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Tests

2003-08-25 Thread Tomka Gergely
er is the cpu. So i dont like hardware raid solutions, and even on ibm pc-servers i try not using them. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..." ---(end of broadcast)---

Re: [PERFORM] Tests

2003-08-22 Thread Tomka Gergely
2003-08-22 ragyogó napján Josh Berkus ezt üzente: > Tomka, > > Did you get my test suggestion? It never hit the lists, so I wonder if you > got it Yes, we got it, and we use your ideas. Thanks. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsa

Re: [PERFORM] Tests

2003-08-22 Thread Tomka Gergely
dont have bsd experience at all. The guy now planning tests on BSD, but he need some time to build up a good relationship with the *BSD. Ps.: i am a harcore linux-fgihter, so sorry :) -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valaho

Re: [PERFORM] Tests

2003-08-21 Thread Tomka Gergely
2003-08-21 ragyogó napján Bill Moran ezt üzente: > Tomka Gergely wrote: > > http://195.199.65.92/~horvaths/pgperformance.html > > > > One of my friend do these tests. We think about the best filesystem for > > the Linux/Postgres systems. > > > > The four te

[PERFORM] Tests

2003-08-21 Thread Tomka Gergely
- "Select count(*)" on the big table. What test are interesting? Plese give us tips and ideas. The guy has time for other test. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..."

Re: [PERFORM] Benchmark

2003-08-15 Thread Tomka Gergely
e > utiltly needs > to simulate these actions. Maybe a simple script, with lines like this: #!/bin/bash wget http://somehost.domain/path/to/search.html?with=arguments wget http://somehost.domain/another/script.html ... ? -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz vel

Re: [PERFORM] How to force PostgreeSQL to work faster?

2003-08-14 Thread Tomka Gergely
Hi! Please send me the test db and the queries, with precise information maybe the developers can help. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak valahogy..." ---(end of broadcast)---