[PERFORM] Need Help

how can i get the disk usage for each table? can i do it via SQL? Thanks, Mailing-Lists ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[PERFORM] Effects of IDLE processes

Hi ALL, I was wondering if there is a DB performance reduction if there are a lot of IDLE processes. 30786 ?S 0:00 postgres: user1 gmadb 10.10.10.1 idle 32504 ?S 0:00 postgres: user1 gmadb 10.10.10.1 idle 32596 ?S 0:00 postgres: user1 gmadb 10.10.1

[PERFORM] PG proper configuation for a php forum

Hi, I was wondering if there would be a proper configuration for a PG database used for a forum.. hmm phpBB to be exact.. It seems that postgres on phpBB is kinda slow.. TIA, ---(end of broadcast)--- TIP 4: Don't 'kill -9' the

Re: [PERFORM] HELP speed up my Postgres

PG Version 7.3.4 On Thursday 25 November 2004 14:12, Vishal Kashyap @ [SaiHertz] wrote: > Dear JM , > > > Ive been using postgres for 3 years and now we are having > > problems with its > > PostgrSQL version please

[PERFORM] HELP speed up my Postgres

Hi ALL, Ive been using postgres for 3 years and now we are having problems with its performance. Here are some givens.. We have 260 subscription tables per Database. We have 2 databases. Our main client has given

[PERFORM] increase performancr with "noatime"?

would it cause problem in postgres DB if /var/lib/psql partition is mounted with "noatime"? TIA JM ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[PERFORM] Best tweak for fast results.. ?

need input on parameter values on confs... our database is getting 1000 transactions/sec on peak periods.. sitting on RH 7.3 2.4.7-10smp RAM: 1028400 SWAP: 2040244 queries are just simple select statements based on timestamps, varchars... less on joins... on a 300K rows.. TIA ---