[PERFORM] Need Help

[JM]

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] PG proper configuation for a php forum

[JM]

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 postmaster

[PERFORM] HELP speed up my Postgres

[JM]

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 us 250,000 mobile numbers to 
deactivate.

--
We we are experiencing
 91,000 mobile numbers to deactive it took a week to finish for 
1 DB only 
the second DB is still in the process of deactivating

Algorithm to deactivate:
we loaded all subscription tables names into a table
we loaded all mobile numbers to deactivate into a table

SQL:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in 
(select 
mobile_num from LOADED_MOBILE_NUMBERS)

the script was made is C

COFIG FILE:
# This is ARA nmimain

tcpip_socket = true
max_connections = 150
superuser_reserved_connections = 2

port = 5433
shared_buffers = 45600
sort_mem = 4
max_locks_per_transaction=128

#fsync = true
#wal_sync_method = fsync

#
#   Locale settings
#
# (initialized by initdb -- may be changed)
LC_MESSAGES = 'en_US.UTF-8'
LC_MONETARY = 'en_US.UTF-8'
LC_NUMERIC = 'en_US.UTF-8'
LC_TIME = 'en_US.UTF-8'


.. DB is being vaccumed every week
my box is running on a DUAL Xeon, 15K RPM with 2 G Mem.

that box is running 2 instances of PG DB.



TIA,






---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PERFORM] HELP speed up my Postgres

[JM]

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


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[PERFORM] increase performancr with noatime?

[JM]

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 PROTECTED] so that your
  message can get through to the mailing list cleanly

[PERFORM] Best tweak for fast results.. ?

[JM]

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

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly