Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-28 Thread Tom Lane
Brendan Jurd writes: > On 29 May 2011 14:04, Tom Lane wrote: >> Anything that even pretends to be a bug tracker will do that. The >> real question is, who is going to keep it up to date? GSM has the >> right point of view here: we need at least a couple of people who >> are willing to invest su

Re: [HACKERS] [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

2011-05-28 Thread Tom Lane
Greg Stark writes: > On Sat, May 28, 2011 at 12:01 PM, Tom Lane wrote: >> I also found that Greg was right in thinking that it would help if we >> tweaked lazy_scan_heap to not always scan the first >> SKIP_PAGES_THRESHOLD-1 pages even if they were >> all_visible_according_to_vm. > You fixed the

Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-28 Thread Brendan Jurd
On 29 May 2011 14:04, Tom Lane wrote: > Anything that even pretends to be a bug tracker will do that.  The > real question is, who is going to keep it up to date?  GSM has the > right point of view here: we need at least a couple of people who > are willing to invest substantial amounts of time, o

Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-28 Thread Robert Haas
On Sun, May 29, 2011 at 12:04 AM, Tom Lane wrote: >> 1. Given a bug number, find the pgsql-bugs emails that mention it in >> the subject line.  Note that the archives would actually MOSTLY do >> this ,but for the stupid month-boundary problem which we seem unable >> to fix despite having some of t

Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-28 Thread Tom Lane
Robert Haas writes: > On Sat, May 28, 2011 at 11:23 PM, Greg Sabino Mullane > wrote: >> My own bare bones wish list for such a tracker is: >> >> * Runs on Postgres >> * Has an email interface >> >> Make no mistake, whichever we choose, the care of feeding of such a >> beast will require some p

Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-28 Thread Robert Haas
On Sat, May 28, 2011 at 11:23 PM, Greg Sabino Mullane wrote: > My own bare bones wish list for such a tracker is: > > * Runs on Postgres > * Has an email interface > > Make no mistake, whichever we choose, the care of feeding of such a > beast will require some precious resources in time from at l

[HACKERS] Getting a bug tracker for the Postgres project

2011-05-28 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > well that is rather basic functionality of a tracker software and i > would expect those to be a given, but I don't think that is where the > problems are with implementing a tracker for postgresql.org... Right, the problem has been the luk

Re: [HACKERS] [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

2011-05-28 Thread Greg Stark
On Sat, May 28, 2011 at 12:01 PM, Tom Lane wrote: > I also found that Greg was right in thinking that it would help if we > tweaked lazy_scan_heap to not always scan the first > SKIP_PAGES_THRESHOLD-1 pages even if they were > all_visible_according_to_vm.  That seemed to skew the results if those

[HACKERS] psql: missing tab completions for COMMENT ON

2011-05-28 Thread Josh Kupershmidt
Hi all, psql's auto-complete support for COMMENT ON was missing support for a few object types: 1.) EXTENSION and PROCEDURAL LANGUAGE are now auto-complete candidates for COMMENT ON [TAB]. Lists of extensions and procedural languages should also be filled in when a user types COMMENT ON EXTENSI

Re: [HACKERS] switch UNLOGGED to LOGGED

2011-05-28 Thread Robert Haas
On Fri, May 27, 2011 at 6:19 AM, Noah Misch wrote: >> So, it's ok to have a log item that is replayed only if >> >> WalRcvInProgress() >> >> is true? > > No, that checks for WAL streaming in particular.  A log-shipping standby needs > the same treatment. > >> Is it a correct approach? I couldn't f

Re: [HACKERS] How can I check the treatment of bug fixes?

2011-05-28 Thread Robert Haas
On Fri, May 27, 2011 at 5:54 PM, Andres Freund wrote: > If I see a bug in a region I know something about and its on a platform I care > about (i.e. likely only linux) I try to do this. But its hard, in most > situations one of you already did it. Tom and you are just to goddamn fast in > many, ma

Re: [HACKERS] eviscerating the parser

2011-05-28 Thread Robert Haas
On Sat, May 28, 2011 at 5:51 PM, Jeff Janes wrote: > But by both methods, the majority of the extra time that can be > accounted for is going to the planner. Sounds like an argument for a plan cache. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --

Re: [HACKERS] storing TZ along timestamps

2011-05-28 Thread Peter Eisentraut
On fre, 2011-05-27 at 16:57 -0700, Steve Crawford wrote: > And the second case is already well handled. In fact calendaring is a > great example. I enter the time for the teleconference and PG nicely > uses my default timezone to store the point-in-time. When you > retrieve > it, it is shown in

Re: [HACKERS] eviscerating the parser

2011-05-28 Thread Jeff Janes
On Sun, May 22, 2011 at 3:10 PM, Robert Haas wrote: ... > > However, in this case, there was only one client, so that's not the > problem.  I don't really see how to get a big win here.  If we want to > be 4x faster, we'd need to cut time per query by 75%.  That might > require 75 different optimi

Re: [HACKERS] [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

2011-05-28 Thread Tom Lane
Robert Haas writes: > Still, maybe we don't have a better option. If it were me, I'd add an > additional safety valve: use your formula if the percentage of the > relation scanned is above some threshold where there's unlikely to be > too much skew. But if the percentage scanned is too small, th

Re: [HACKERS] pg_terminate_backend and pg_cancel_backend by not administrator user

2011-05-28 Thread Josh Kupershmidt
On Fri, Mar 11, 2011 at 8:54 AM, Bruce Momjian wrote: > I have added it to the next commit fest. Hi Torello, I have volunteered (more accurately, Greg Smith "volunteered" me :-) to be a reviewer for this patch. I know you're a bit new here, so I thought I'd outline where this patch stands and wh

Re: [HACKERS] How can I check the treatment of bug fixes?

2011-05-28 Thread Stefan Kaltenbrunner
On 05/28/2011 12:19 PM, Dave Page wrote: On Sat, May 28, 2011 at 10:02 AM, Stefan Kaltenbrunner wrote: well as for just keeping track of -bugs I guess a very simple schema would go pretty far: * have some tool monitor the list and if it sees a new bug# make it a ticket/bugreport The bug num

Re: [HACKERS] How can I check the treatment of bug fixes?

2011-05-28 Thread Dave Page
On Sat, May 28, 2011 at 10:02 AM, Stefan Kaltenbrunner wrote: > well as for just keeping track of -bugs I guess a very simple schema would > go pretty far: > > * have some tool monitor the list and if it sees a new bug# make it a > ticket/bugreport The bug numbers come from a database backed web

Re: [HACKERS] How can I check the treatment of bug fixes?

2011-05-28 Thread Stefan Kaltenbrunner
On 05/27/2011 07:55 PM, Robert Haas wrote: On Fri, May 27, 2011 at 12:21 PM, Tom Lane wrote: "Joshua D. Drake" writes: You have done what you need to do to check the status. Someone who knows something about the bug should speak up at some point. That patch is waiting for a committer who kn

Re: [HACKERS] How can I check the treatment of bug fixes?

2011-05-28 Thread Stefan Kaltenbrunner
On 05/28/2011 05:47 AM, MauMau wrote: From: "Peter Eisentraut" On fre, 2011-05-27 at 13:55 -0400, Robert Haas wrote: Also, I think it's about time we got ourselves some kind of bug tracker. I have no idea how to make that work without breaking workflow that works now, but a quick survey of my

[HACKERS] install softwares

2011-05-28 Thread nil nil
sir, i am developnig a patch and as per instructionsdescribed on this site http://wiki.postgresql.org/wiki/Developer_FAQ  it is specifed on the link that along with unix platform we have to use   GCC, GNU Make, GDB, Autoconf but i dont know how to install these softwares in linux ,because the co

[HACKERS] patch integration

2011-05-28 Thread nil nil
Sir,           i am developing a patch for postgresql in c language. i want to know that how can i integrate my patch with postgresql. regards emman

Re: [HACKERS] [COMMITTERS] pgsql: Allow ALTER TABLE name {OF type | NOT OF}.

2011-05-28 Thread Cédric Villemain
2011/5/28 Alvaro Herrera : > Excerpts from Cédric Villemain's message of vie may 27 18:37:05 -0400 2011: >> 2011/4/21 Robert Haas : > >> > Modified Files >> > -- >> > doc/src/sgml/ref/alter_table.sgml         |   26 +++ >> > src/backend/commands/tablecmds.c          |  277 >> > +++