Re: [PERFORM] Windows XP selects are very slow
PG generally comes with very basic default settings, one *start* maybe this page for you http://www.webservices.uiuc.edu/postgresql/ Then obviously you will need to work though your query plans and iterate. Shadkam Islam wrote: Hi All, We are having a table whose data we need to bucketize and show. This is a continuously growing table (archival is a way to trim it to size). We are facing 2 issues here: 1. When the records in the table are in the range of 10K, it works fine for some time after starting postgres server. But as time passes, the entire machine becomes slower and slower - to the extent that we need to go for a restart. Though taskmgr does not show any process consuming extra-ordinary amount of CPU / Memory. After a restart of postgres server, things come back to normal. What may be going wrong here? 2. When the records cross 200K, the queries (even "select count(*) from _TABLE_") start taking minutes, and sometimes does not return back at all. We were previously using MySql and at least this query used to work OK there. [Our queries are of the form "select sum(col1), sum(col2), count(col3) ... where group by ... " ]. Any suggestions ... Below is the tuning parameter changes thet we did with the help from internet: We are starting postgres with the options [-o "-B 4096"], later we added a "-S 1024" as well - without any visible improvement. Machine has 1GB RAM. shadkam ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [PERFORM] Training Recommendations
EnterpriseDB (www.enterprisedb.com), ofcourse Campbell, Lance wrote: PostgreSQL: 8.2.4 Does anyone have any companies they would recommend using for performance tuning training of PostgreSQL for Linux? Or general DBA training? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PERFORM] Training Recommendations
Robert Treat wrote: On Wednesday 28 November 2007 11:20, Usama Munir Dar wrote: EnterpriseDB (www.enterprisedb.com), ofcourse lame :-P Have you or anyone you know tried the training offerings? or you think its lame because i top posted , which of course would be a very poor criteria , not to mention completely unrelated, so i definitely think its not the reason. i would love to hear whats wrong with it so we can work on its improvement Campbell, Lance wrote: PostgreSQL: 8.2.4 Does anyone have any companies they would recommend using for performance tuning training of PostgreSQL for Linux? Or general DBA training? Never take advice from a guy who top posts... A friend of mine just went through an OTG course and had good things to say, and I've heard other speak well of it too, so I'd probably recommend them, but there are several options, check out the training section on the website: http://www.postgresql.org/about/eventarchive Note also some of the more popular pg support companies also offer personal training, even if it isn't advertised. HTH. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
