[GENERAL] epqa; postgres performance optimizer support tool; opensource.

Dear All, Recently i have released the next version of the epqa. which is a very useful tool for, gives input for optimizing psql queries, and fine tuning it. epqa is tool similar like, pqa. But designed and implemented to parse log files which is in GB's. Report is similar like that. More inf

[GENERAL] Migration Articles.. ???

Dear All, Am going to do migration of database from one version to another., is there any article or any other document explaining the possibilities and other things. Further Explanation: I have a database in postgres X.Y which has around 90 tables, and lot of data in it. In the next version of

Re: [GENERAL] postgresql is slow with larger table even it is in RAM

ok On Tue, Mar 25, 2008 at 5:33 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Please stop reposting your questions to multiple groups. Since all your > questions are about performance, please stick to the pgsql-performance > list. Posting to pgsql-sql is not really appropriate, and in > pgsql

[GENERAL] postgresql is slow with larger table even it is in RAM

I have a table with 32 lakh record in it. Table size is nearly 700 MB, and my machine had a 1 GB + 256 MB RAM, i had created the table space in RAM, and then created this table in this RAM. So now everything is in RAM, if i do a count(*) on this table it returns 327600 in 3 seconds, why i

[GENERAL] postgresql performance tuning tools

hi all, I want this mail to be continued about summary of performance tuning tools... or other postgres related tools.. I ll start with saying there is a tool SCHEMASPY ( i got to know about this from another group ), this will draw ER diagram and gives interesting informations about our postgres

[GENERAL] ER diagram tool

Is there any tool to draw ER diagram from SQL schema file...

[GENERAL] migration of 7.4 to 8.1

Is there any article describing the migration database from postgresql 7.4to 8.1

[GENERAL] list user created triggers

hi, how to find trigger names in my database ? using psql 7.4 the following query shows system triggers, i want only to list the triggers created by me select relname, tgname, tgtype, proname, prosrc, tgisconstraint, tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs, tgattr, tg

Re: [GENERAL] indexing - creates problem

now it is for 500 records. postgres 7.4 Debian -- call_id | integer | not null default nextval('call_log_seq'::text) agent_id | integer | call_id already has index. count(*

[GENERAL] indexing - creates problem

I am having a table with more than 1000 records, i am not having index in that, while executing that query it occupies the processor.. I created an index, and then executed that query., Now it is not getting executed at all... while seeing the top the processor is busy in WA, that it is waiting fo