Re: [PERFORM] Database Statistics???

2007-07-13 Thread Tom Arthurs
smiley2211 wrote: Hello all, I am a bit confused...I have a database which was performing very POORLY selecting from a view (posted earlier) on one server but extremely fast on another server... I just backed up the database from the FAST server and loaded to the SLOW server and it ran just as

Re: [PERFORM] hardare config question

2006-05-01 Thread Tom Arthurs
UPS does not protect against the tech behind the rack unplugging the power cable, or an accidental power cycle from exercising the wrong switch. :) Both are probably more common causes of failure than a total power outage. Erik Myllymaki wrote: I have been in discussion with 3ware support and

Re: [PERFORM] What's the best hardver for PostgreSQL 8.1?

2005-12-21 Thread Tom Arthurs
AFAIK there are no licensing costs for solaris, unless you are talking about a software support agreement, which is not required. Juan Casero wrote: I just sent my boss an email asking him for a Sun v20z with dual 2.2 Ghz opterons, 2 Gigs of RAM and RAID 1. I would have liked a better ser

Re: [SPAM?] Re: [PERFORM] PG8 Tuning

2005-08-11 Thread Tom Arthurs
I think the T-3 RAID at least breaks some of these rules -- I've got 2 T-3's, 1 configured as RAID-10 and the other as RAID5, and they both seem to perform about the same. I use RAID5 with a hot spare, so it's using 8 spindles. I got a lot of performance improvement out of mount the fs noatim

Re: [PERFORM] General DB Tuning

2005-07-12 Thread Tom Arthurs
Here's the answer for you from the jdbc list: Alvin Hung wrote: Currently, 8.0.2 / JDBC 8.0-310, log_min_duration_statement does not work with JDBC. Nothing will get logged. This makes it very difficult to tune a java application. Can you tell me when will this be fixed? Thanks. This i

Re: [PERFORM] General DB Tuning

2005-07-12 Thread Tom Arthurs
hmm, yea maybe -- we are using the 7.4 driver with 8.0.x db. Dennis wrote: Tom Arthurs wrote: we are using jdbc -- the "log_min_duration_statement = 3000 " statement works fine for me. Looks like there's no other work around for the bug(?). Not sure since I have no intere

Re: [PERFORM] General DB Tuning

2005-07-12 Thread Tom Arthurs
055.php But I can't find anywhere where someone has fixed it. Am I the only one accessing postgres through JDBC? -Brent --- Tom Arthurs <[EMAIL PROTECTED]> wrote: I have this in my postgresql.conf file and it works fine (set the min to whatever you want to log) log_min_duration_s

Re: [PERFORM] General DB Tuning

2005-07-12 Thread Tom Arthurs
I have this in my postgresql.conf file and it works fine (set the min to whatever you want to log) log_min_duration_statement = 3000 # -1 is disabled, in milliseconds. Another setting that might get what you want: #log_duration = false uncomment and change to true. From the docs: (http://www

Re: [PERFORM] Postgresql on an AMD64 machine

2005-06-08 Thread Tom Arthurs
I just puhsd 8.0.3 to production on Sunday, and haven't had a time to really monitor it under load, so I can't tell if it's helped the context switch problem yet or not. Neil Conway wrote: Tom Arthurs wrote: Yes, shared buffers in postgres are not used for caching Sh

Re: [PERFORM] Postgresql on an AMD64 machine

2005-06-07 Thread Tom Arthurs
ching. Donald Courtney wrote: Tom Arthurs wrote: According to my research, you only need a 64 bit image if you are going to be doing intensive floating point operations (which most db servers don't do). Some benchmarking results I've found on the internet indicate that 64 bit executable

Re: [PERFORM] Postgresql on an AMD64 machine

2005-06-07 Thread Tom Arthurs
According to my research, you only need a 64 bit image if you are going to be doing intensive floating point operations (which most db servers don't do). Some benchmarking results I've found on the internet indicate that 64 bit executables can be slower than 32 bit versions. I've been running

Re: [PERFORM] PostgreSQL on Solaris 8 and ufs

2005-03-23 Thread Tom Arthurs
On the context switching issue, we've found that this setting in /etc/system helps: set rechoose_interval=30 this sets the minimum time that a process is eligible to be switched to another cpu. (the default is 3). You can monitor context switching with the cs column in vmstat. We've found that

[PERFORM] PG block sizes

2005-02-28 Thread Tom Arthurs
Hi, All I'm trying to tune a software RAID 0 (striped) on a solaris 9, sparc box. Currently I'm using a raid 1 (mirrored) array on two discs for the data area, and I put in 4 new drives last night (all are f-cal). On the new array I have a width of 4, and used the default interleave factor of 3

Re: [PERFORM] Solaris 9 tuning

2005-02-09 Thread Tom Arthurs
Hi, Paul Josh helped my company with this issue -- PG doesn't use shared memory like Oracle, it depends more on the OS buffers. Making shared mem too large a fraction is disasterous and seriously impact performance. (though I find myself having to justify this to Oracle trained DBA's) :) What I

Re: [PERFORM] Solaris 9 tuning

2005-02-09 Thread Tom Arthurs
Yes, I agree it's unnecessary -- but you'll never have to worry about the postmaster not starting due to lack of allocatable memory -- when I was testing setups, I got sick of rebooting everytime I had to make a change to /etc/system, that I threw up my hands and said, "let it take all it wants".

Re: [PERFORM] Solaris 9 tuning

2005-02-09 Thread Tom Arthurs
... Trying again again with right email address -- list server rejected previous :) Hi, Paul Josh helped my company with this issue -- PG doesn't use shared memory like Oracle, it depends more on the OS buffers. Making shared mem too large a fraction is disasterous and seriously impact performan