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
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
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
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
> 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
> 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
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
need more information / stats.
Any help would be much appreciated.
Thanks,
Scott Otis
CIO / Lead Developer
Intand
www.intand.com