IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Did you do any tuning on Postgres?
Post #295,191
by admin
Picture of admin
10/27/07 12:55:43 AM
Reply
New Did you do any tuning on Postgres?
The default settings have gotten better, but there's a lot you can do with buffer sizes and so on that speed it up considerably.

IIRC, there's also an in-memory version of MySQL; depends on how big your working set is, I guess.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #295,193
by crazy
10/27/07 1:04:15 AM
Reply
New Yup
I gave it around 900MB to play with at one point.
I rarely hit disk.
It simply did things differenty from Oracle.
And it was much faster than MySQL.
     More MySQL vs. Postgres - (admin) - (7) - Oct. 26, 2007, 03:00:37 PM EDT
         Interesting - (crazy) - (6) - Oct. 26, 2007, 03:23:47 PM EDT
             did you look at db2? -NT - (boxley) - (1) - Oct. 26, 2007, 03:43:41 PM EDT
                 Nope -NT - (crazy) - Oct. 27, 2007, 12:36:28 AM EDT
             Is 10g XE not an option? (I know little about DBs). -NT - (Another Scott) - (1) - Oct. 26, 2007, 04:01:10 PM EDT
                 Nope - (crazy) - Oct. 27, 2007, 12:38:31 AM EDT
             Did you do any tuning on Postgres? - (admin) - (1) - Oct. 27, 2007, 12:55:43 AM EDT
                 Yup - (crazy) - Oct. 27, 2007, 01:04:15 AM EDT

Hey, they have color-coded detours here.
43 ms