[PERFORM] Databases vs Schemas

2009-10-09 Thread Scott Otis
create? Should I try to re-engineer things so that all 18,000 instances only use 1 database and 1 schema? Let me know if you need any more info. Any advice and information would be greatly appreciated. Regards, Scott Otis CIO / Lead Developer Intand www.intand.com

Re: [PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-04 Thread Scott Otis
s there any way to turn stats collecting completely off? Scott Otis CIO / Lead Developer Intand www.intand.com -Original Message- From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Friday, September 04, 2009 1:19 AM To: Scott Otis Cc: Robert Haas; Ivan Voras; pgsql-performa

Re: [PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-03 Thread Scott Otis
Robert Haas : > Do you by any chance have a bazillion databases in this cluster? Can > you do these? > select sum(1) from pg_database; 1555 > select pg_relation_size('pg_database'); 221184 > select sum(pg_column_size(d.*)) from pg_database; That gave me: ERROR: missing FROM-clause e

Re: [PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-03 Thread Scott Otis
Claus Guttesen kome...@gmail.com: > > Would love to get some advice on how to change my conf settings / setup to > > get better I/O performance. > > > > Server Specs: > > > > 2x Intel Xeon Quad Core (@2 Ghz - Clovertown,L5335) > > 4GB RAM > > 4x Seagate 73GB SAS HDD 10k RPM - in RAID ( stripped an

Re: [PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-03 Thread Scott Otis
> Can you post to the list all the uncommented lines from your postgresql.conf file and attach the results of "select * from pg_stat_all_tables" as an attachment? I attached a CSV of "select * from pg_stat_all_tables" from one of our more heavily used databases. Note: I turned off stats collectio

Re: [PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-03 Thread Scott Otis
> Simply do "iostat mfid0 1" and post 10 lines of its output. tty mfid0 cpu tin tout KB/t tps MB/s us ni sy in id 0 152 108.54 335 35.51 43 0 30 1 27 0 525 85.73 759 63.55 14 0 12 0 74 0 86 67.72 520 34.39 13 0 12 0 75 0 86 86.89 746 63.26

Re: [PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-03 Thread Scott Otis
er before getting another one. If I can reduce the I/O and CPU that the stats collector and autovacuum are using without losing any functionality then I can put more load on the server. Again thanks for all the help. Scott Otis CIO / Lead Developer Intand www.intand.com -- Sent via pgsql-pe

[PERFORM] Seeking performance advice and explanation for high I/O on 8.3

2009-09-02 Thread Scott Otis
need more information / stats. Any help would be much appreciated. Thanks, Scott Otis CIO / Lead Developer Intand www.intand.com