lucky29
Last Activity: Dec 17 '13, 07:34 AM
Joined: Aug 23 '13
Location:
-
What is the best way to get the Transactions per second in PostgreSQL?
I'm using pgbench to get transactions per second but not bale to understand the output given by it properly, so do anyone have better idea about transactions per second (tps) in PostgreSQL? -
Recovery using continuous archiving
I have enabled streaming replication between two server say master and slave. Now after this I enabled archiving changing following parameters-
On the master node, configure "postgresql.con f"
archive_mode = on
archive_command = 'cp %p /u01/arch/%f'
archive_timeout = 120
max_wal_senders = 5
wal_keep_segmen ts = 10
After this I edited the recovery.conf file on... -
How to get the performance statistics in postgresql?
Can anyone tell me how to get deatiled performance statistics in postgresql and is there some query advisor like we have in oracle?
Thanks
Lucky -
What is the best way to get Frequent Refresh of database ?
Please tell me what is the best way to get refresh of production database on the test database.
I have used two ways-
1.importing dumpall and dropping the databases.
2.importing dumpall and dropping all the relations.
Thanks
Lucky
No activity results to display