Re: [GENERAL] Git host for postgresql related projects
Assembla does free git repositories as well http://www.assembla.com/ On 14 April 2013 05:22, Francisco Figueiredo Jr. wrote: > > Hi, Magnus! > > How you doing? > > > Today I have a "mirror" at github which I'm using to test and learn git > and it seems to be very good. Git is very powerful and it is easy to > understand why many are working on it. > > Thanks for your help and advice on this subject. > > > > On Sat, Apr 13, 2013 at 4:12 PM, Magnus Hagander wrote: > >> On Sat, Apr 13, 2013 at 9:10 PM, Francisco Figueiredo Jr. >> wrote: >> > >> > Hi all! >> > >> > >> > I was thinking about moving Npgsql from cvs to another SCM. Possibly >> git. >> > >> > I'd like to know if there is any postgresql project host which supports >> git >> > which you could recommend. >> > >> > I know there is git.postgresql.org and github. >> > >> > From the new repository page of git.postgresql.org it says: "[...] If >> you >> > want to to use git, while also getting some of the features that are on >> > pgfoundry, we strongly advise you to look at github. [...]" >> > >> > It would be better for me, then, to use github? As this clearly is my >> case. >> > >> > Thanks in advance for your help and advice. >> >> I would suggest going with github. They provide you with a bunch of >> services like a wiki and an issue tracker that you will not get from >> git.postgesql.org. They also provide you with the "social coding" >> stuff or whatever they call it (their forking/pull request/whatnot >> stuff) if you like it - but you can also just use it as a pure git >> repo if you prefer. >> >> -- >> Magnus Hagander >> Me: http://www.hagander.net/ >> Work: http://www.redpill-linpro.com/ >> > > > > -- > Regards, > > Francisco Figueiredo Jr. > Npgsql Lead Developer > http://www.npgsql.org > http://gplus.to/franciscojunior > http://fxjr.blogspot.com > http://twitter.com/franciscojunior > -- Raja Consulting Ltd. Incorporated in England and Wales No. 06454814, Registered Office: 4 Calder Court, Shorebury Point, Amy Johnson Way, Blackpool FY4 2RH
Re: [GENERAL] Git host for postgresql related projects
Thanks for the tip, Samit. I didn't know about Assembla. On Sun, Apr 14, 2013 at 5:52 AM, Sumit Raja < sumit.r...@raja-consulting.co.uk> wrote: > Assembla does free git repositories as well http://www.assembla.com/ > > > On 14 April 2013 05:22, Francisco Figueiredo Jr. wrote: > >> >> Hi, Magnus! >> >> How you doing? >> >> >> Today I have a "mirror" at github which I'm using to test and learn git >> and it seems to be very good. Git is very powerful and it is easy to >> understand why many are working on it. >> >> Thanks for your help and advice on this subject. >> >> >> >> On Sat, Apr 13, 2013 at 4:12 PM, Magnus Hagander wrote: >> >>> On Sat, Apr 13, 2013 at 9:10 PM, Francisco Figueiredo Jr. >>> wrote: >>> > >>> > Hi all! >>> > >>> > >>> > I was thinking about moving Npgsql from cvs to another SCM. Possibly >>> git. >>> > >>> > I'd like to know if there is any postgresql project host which >>> supports git >>> > which you could recommend. >>> > >>> > I know there is git.postgresql.org and github. >>> > >>> > From the new repository page of git.postgresql.org it says: "[...] If >>> you >>> > want to to use git, while also getting some of the features that are on >>> > pgfoundry, we strongly advise you to look at github. [...]" >>> > >>> > It would be better for me, then, to use github? As this clearly is my >>> case. >>> > >>> > Thanks in advance for your help and advice. >>> >>> I would suggest going with github. They provide you with a bunch of >>> services like a wiki and an issue tracker that you will not get from >>> git.postgesql.org. They also provide you with the "social coding" >>> stuff or whatever they call it (their forking/pull request/whatnot >>> stuff) if you like it - but you can also just use it as a pure git >>> repo if you prefer. >>> >>> -- >>> Magnus Hagander >>> Me: http://www.hagander.net/ >>> Work: http://www.redpill-linpro.com/ >>> >> >> >> >> -- >> Regards, >> >> Francisco Figueiredo Jr. >> Npgsql Lead Developer >> http://www.npgsql.org >> http://gplus.to/franciscojunior >> http://fxjr.blogspot.com >> http://twitter.com/franciscojunior >> > > > > -- > Raja Consulting Ltd. > Incorporated in England and Wales No. 06454814, Registered Office: 4 > Calder Court, Shorebury Point, Amy Johnson Way, Blackpool FY4 2RH > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior
[GENERAL] Autovacuum doesn't work if the table has large number of records
On Saturday, April 13, 2013, Ascot Moss wrote: > Hi Jeff, > > Thanks for your reply. > > > Yes, it took a while to complete the autovacuum. > > I checked it again this morning: > > last_autovacuum: 2013-04-14 06:17:02.9464+08 > > last_autoanalyze: 2013-04-13 20:27:12.396048+08 > > ... > > > I also checked the pg_log files, the autovacuum somehow was delayed by > "pgstat wait timeout" , during 1:10am to 05:41am this morning (over 4.5 > hours). > > I think this would impact the DB performance. > Those warnings are not directly related to your vacuum performance, although they do indicate your system is under some IO stress. Whether that stress is slowing down the vacuum, or caused by the vacuum, or irrelevant to it, is hard to say. Was the system idle other than the vacuum? What indexes do you have on the table? What is your IO subsystem like? ... > I am new to PostgreSQL, can anyone advise me how to handle "pgstat wait > timeout"? > If they occur during maintenance/refactoring/bulk loading, just ignore them. If they occur a lot during normal operations, you probably need better hardware. Maybe separating the pg_xlog from the rest of the IO if you haven't already. (You could also move the stats file to a ramdisk, but that is probably treating the symptom more than the problem) Cheers, Jeff
