Re: [ADMIN] pg_stat_activity - proc id

2013-10-07 Thread Jov
we set the application_name to some unique id such as client process ID or processid#threadid when client Start the new session. jov 在 2013-10-7 上午10:39，Rajagopalan, Jayashree jayashree.rajagopa...@emc.com 写道： Hi: ** ** How to correlate the procpid in pg_stat activity table to any

[ADMIN] Reg. Restore

2013-10-07 Thread Venakata Ramana
Hi, I am using postgresql 9.1.5. on windows Xp. I am facing two problems: 1. Restore of DB is very slow. How to improve the speed of Restore? 2. Without indexes, retrieving from table is fast? After creating an index on that table, then the retrieval become slow. plz prove any

Re: [ADMIN] Reg. Restore

2013-10-07 Thread Matheus de Oliveira
On Mon, Oct 7, 2013 at 9:03 AM, Venakata Ramana ramana@gmail.comwrote: Hi, I am using postgresql 9.1.5. on windows Xp. You should update to 9.1.9. I am facing two problems: 1. Restore of DB is very slow. How to improve the speed of Restore? How are you doing this restore? Is

Re: [ADMIN] Reg. Restore

2013-10-07 Thread Kevin Grittner
Venakata Ramana ramana@gmail.com wrote: I am using postgresql 9.1.5. on windows Xp. You should update to a more current minor release. http://www.postgresql.org/support/versioning/ 1. Restore of DB is very slow. How to improve the speed of Restore? You need to provide more