Re: [PERFORM] How can i find out top high load sql queries in PostgreSQL.

There is a tool called pg Fouine . I am sure this will help you.. http://pgfouine.projects.pgfoundry.org/tutorial.html Rgrds Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-can-i-find-out-top-high-load-sql-queries-in-PostgreSQL-tp5736854p5736865.html Sent f

[PERFORM] CREATING INDEX on column having null values

Hi, I have a partitioned table(partitioned on date) .There are about 1 million insertions per day. There is a column called mess_id. This column is updated .But update query is taking huge time.When i checked , this column is not unique, and most of the time its having null . Say everyday out of

[PERFORM] NEED REPLICATION SOLUTION -POSTGRES 9.1

Hi, We are planning to migrate our production databases to different servers.We have around 8 servers with 8 different clusters.We are planning t shuffle databases and make them as 7 cluster and migrate to new remote servers . We cannot use streaming replication as we are migrating different

Re: [PERFORM] pgsql_tmp( Temporary tablespace)

Hi, Can i delete the content of this folder. I have observed couple of times , this folder got cleaned automatically. Which backend process deletes the data from this folder .Any Idea? Rgrds Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgsql-tmp-Temporar

[PERFORM] pgsql_tmp( Temporary tablespace)

Hi, This folde( Temporary tablespace) is getting filled and size increases in the day where there lots of sorting operations.But after some times the data in the is deleted automatically . Can any one explain what is going on ? Rgrds Suhas -- View this message in context: http://postgresql.1