Re: [GENERAL] optimizer's cost formulas

2013-04-07 Thread Daniel Bausch
Hi, AFAIK there is no such thing in the code or documentation. Nevertheless, for a paper I've published last year, I tried to create mathematical transcriptions at least for the I/O costs. http://dl.acm.org/citation.cfm?id=2236584.2236588&coll=DL&dl=ACM&CFID=309621631&CFTOKEN=77712718 Have a loo

Re: [GENERAL] pg_stat_get_last_vacuum_time(): why non-FULL?

2013-04-07 Thread Amit Kapila
On Monday, April 08, 2013 4:40 AM CR Lender wrote: > On 2013-03-31 18:31, CR Lender wrote: > > On 2013-03-28 20:44, Kevin Grittner wrote: > >> CR Lender wrote: > >>> I've read the manual more carefully now, and I can't see any > mention of > >>> what VACUUM does that VACUUM FULL does not. The poin

[GENERAL]

2013-04-07 Thread Rod

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread Tomas Vondra
On 7.4.2013 19:43, David Boreham wrote: > > I thanks very much for your detailed response. A few answers below inline: > > On 4/7/2013 9:38 AM, Tomas Vondra wrote: >> As for the performance, AFAIK the EBS volumes always had, and probably >> will have, a 32 MB/s limit. Thanks to caching, built int

Re: [GENERAL] pg_stat_get_last_vacuum_time(): why non-FULL?

2013-04-07 Thread CR Lender
On 2013-03-31 18:31, CR Lender wrote: > On 2013-03-28 20:44, Kevin Grittner wrote: >> CR Lender wrote: >>> I've read the manual more carefully now, and I can't see any mention of >>> what VACUUM does that VACUUM FULL does not. The point about extreme >>> maintainance is taken, but from what I read

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Chris Angelico
On Mon, Apr 8, 2013 at 8:27 AM, Gavin Flower wrote: > On 08/04/13 09:45, Chris Angelico wrote: >> My development >> platform consists of Linux, Xfce, five workspaces... > > On my workstation, I use xfce with 25 virtual workspaces, 8 currently empty, > I've been logged in for about 20 days. > > On

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Gavin Flower
On 08/04/13 09:45, Chris Angelico wrote: On Mon, Apr 8, 2013 at 4:14 AM, Gavin Flower wrote: Not to mention that it appears that Postgres runs better on Linux than on Microsoft. Linux skills are increasingly in demand, while MIcrosoft's market share is dropping (partly as a result of the Metro

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Chris Angelico
On Mon, Apr 8, 2013 at 4:14 AM, Gavin Flower wrote: > Not to mention that it appears that Postgres runs better on Linux than on > Microsoft. Linux skills are increasingly in demand, while MIcrosoft's > market share is dropping (partly as a result of the Metro fiasco!). > Are you allowed to call

Re: [GENERAL] [Maintainers] REL/Centos4 release of 8.4.17?

2013-04-07 Thread Devrim GÜNDÜZ
Hi, On Sat, 2013-04-06 at 17:16 -0400, Jared Beck wrote: > I know Centos 4 is EOL, but will there be a REL/Centos 4 release of > postgres 8.4.17? The latest here is 8.4.16: > > http://yum.postgresql.org/8.4/redhat/rhel-4-i386/repoview/ > One of our aims is making people happy ;) I just built

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Atri Sharma
Sent from my iPad On 07-Apr-2013, at 23:44, Gavin Flower > > > Not to mention that it appears that Postgres runs better on Linux than on > Microsoft. Linux skills are increasingly in demand, while MIcrosoft's market > share is dropping (partly as a result of the Metro fiasco). True that

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread Ben Chobot
On Apr 6, 2013, at 6:51 PM, David Boreham wrote: > First I need to say that I'm asking this question on behalf of "a friend", > who asked me what I thought on the subject -- I host all the databases > important to me and my livelihood, on physical machines I own outright. That > said, I'm curi

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Gavin Flower
Hi Govind, While Postgres obviously does run on Microsoft O/S's, and can be complied there - if you are seriously interested in software development, you should consider Linux. Linux dominates the mobile (Android & eBooks are both based on Linux) and server segments. I also consider Linux a

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread David Boreham
I thanks very much for your detailed response. A few answers below inline: On 4/7/2013 9:38 AM, Tomas Vondra wrote: As for the performance, AFAIK the EBS volumes always had, and probably will have, a 32 MB/s limit. Thanks to caching, built into the EBS, the performance may seem much better ini

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Adrian Klaver
On 04/07/2013 07:41 AM, Govind kumar sah wrote: thank you sir. actually i have already read this. Now how can i download the source code, how can i compile it and Information on getting source: http://www.postgresql.org/docs/current/static/git.html Starting page for developer info: http://www

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread Tomas Vondra
Hi David, On 7.4.2013 03:51, David Boreham wrote: > > First I need to say that I'm asking this question on behalf of "a > friend", who asked me what I thought on the subject -- I host all the > databases important to me and my livelihood, on physical machines I own > outright. That said, I'm curi

Re: [GENERAL] BEFORE UPDATE trigger doesn't change column value

2013-04-07 Thread Clemens Eisserer
Hi Kevin, Sorry, that's the wrong way around. I should have said: > > Your BEFORE UPDATE trigger could leave the "synced" value in NEW > alone if force_sync was **true**, and set "synced" to false > otherwise. It could then set NEW.force_sync to false, to leave you > ready for the next update. >

Re: [GENERAL] procedure to contribute this community

2013-04-07 Thread Adrian Klaver
On 04/07/2013 06:56 AM, Govind kumar sah wrote: hello sir/mam This is Govind Kumar Sah, a 3rd year student of UIET,PU Chandigarh and am pursuing B>E in CSE trade. I am new in this community and am already read about this community and i liked it because i like SQL and want to participate in GSOC

[GENERAL] procedure to contribute this community

2013-04-07 Thread Govind kumar sah
hello sir/mam This is Govind Kumar Sah, a 3rd year student of UIET,PU Chandigarh and am pursuing B>E in CSE trade. I am new in this community and am already read about this community and i liked it because i like SQL and want to participate in GSOC 2013, but how i dont know so, please guide me? -