[ADMIN] AutoVaccuum process start as its off in potgresql.conf]

Hi , I am using PostgreSQL 8.3 version . The autovacuum process is stucking my system as it automtically start even though its off is postgresql.conf. 2. Is there any benchmark tool for Autovacuum process or can we know how much time this proces will take to complete? Thanks in Advance.

[ADMIN] autovacuum benchmarking ...

Hi Team 1. Can we know the how much time will take ongoing vacuum process in DB? 2. Any benchmarking tool for vacuum process. 3. Can we know what exact operations has been done by Vacuum process. 4. I studied that only VACUUM process doesnot lock the table but due to it insertion in table gets

[ADMIN] pg_service.con

Hi, How can we associate the pg_service.conf with PostgreSQL. Regards Amit jain. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] How can we see details of function in psql prompt

Hi, 1. Could any one please suggest me that how can I see the details of function through psql prompt. 2. We can use cactii as a monitoring tool for mysql what is the similar monitoring tool except nagios for postgreSQL Thankx in Advance Amit -- Sent via pgsql-admin mailing list (pgsql-adm

Re: [ADMIN] pg_service.con

I got the answer as we just need to declare a enviornment variable PGSYSCONFDIR for its directory location. AmitKumar Jain wrote: Hi, How can we associate the pg_service.conf with PostgreSQL. Regards Amit jain. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

Re: [ADMIN] How can we see details of function in psql prompt

endrows'; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AmitKumar Jain Sent: Monday, December 08, 2008 3:41 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] How can we see details of function in psql prompt Hi, 1. Could any one please suggest me

Re: [ADMIN] How can we see details of function in psql prompt

Hi, \df will only give information aboutt its owner,argument,return type not its complete definition. I need to know the definition of function "record_part('test)" through psql prompt so is there any way to see it from psql prompt. Milen A. Radev wrote: AmitKumar Jain

Re: [ADMIN] Heavy postgres process

VACUUM activiy can make any process size so much heavy... Suresh Borse wrote: Hi, Try to monitor the o/p of following command. psql > select * from pg_Stat_activity; It gives all the connection detail. On Fri, 2008-09-12 at 18:12 +1000, Vivek_Sharan wrote: Hi Admin, I’m new to this I

Re: [ADMIN] Tool to converter plsql in pgplsql

Can you send its link , Is it opensource or licensed version. paulo matadr wrote: Hi guys, you knowns a tool for automatic converter plsql in pgplsql? this tool exist? Thanks Paulo Moraes Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10

Re: [ADMIN] Getting the value of a config parameter in runtime

You can configuration parameter value from psql prompt by typing show all ; or show [paramter name] e.g show shared_buffers; Jaume Sabater wrote: Hi all! Sorry to ask this, I had it noted down but now I cannot find it and I've been googling for 30 minutes now without success. There is a way t

Re: [ADMIN] Question to transaction ID wraparound

Its a log analyzer tool through which you can trap the running queries and have reports about update/delete/insterts which are executing at database system. http://pgfouine.projects.postgresql.org/ Lentes, Bernd wrote: Lee Azzarello wrote: Sometimes the number grows by 5 in one second. I

Re: [ADMIN] Create table command fails with permission denied

Venkateswara Rao Bondada wrote: Hi, I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 database. I'm getting the following error when tried to create a table. Please let me know the steps (with queries) that I should take care to resolve this issue. cms=# create