Skip site navigation (1) Skip section navigation (2)

HELP speed up my Postgres

From: JM <jerome(at)gmanmi(dot)tv>
To: pgsql-performance(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: HELP speed up my Postgres
Date: 2004-11-25 06:00:32
Message-ID: 200411251400.32752.jerome@gmanmi.tv (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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 = 40000
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,
		


		


Responses

pgsql-performance by date

Next:From: Vishal Kashyap @ [SaiHertz]Date: 2004-11-25 06:12:18
Subject: Re: [PERFORM] HELP speed up my Postgres
Previous:From: Steinar H. GundersonDate: 2004-11-25 01:18:23
Subject: Re: Postgres vs. MySQL

pgsql-general by date

Next:From: Vishal Kashyap @ [SaiHertz]Date: 2004-11-25 06:12:18
Subject: Re: [PERFORM] HELP speed up my Postgres
Previous:From: Greg StarkDate: 2004-11-25 05:51:19
Subject: Re: SELECT...VIEW...UNION...LIMIT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group