Re: [HACKERS] storing TZ along timestamps

2011-05-28 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, May 27, 2011 at 04:43:28PM -0400, Alvaro Herrera wrote: Hi, One of our customers is interested in being able to store original timezone along with a certain timestamp. I've felt that pain here and there too... So the first thing is

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

2011-05-28 Thread Cédric Villemain
2011/5/28 Alvaro Herrera alvhe...@commandprompt.com: Excerpts from Cédric Villemain's message of vie may 27 18:37:05 -0400 2011: 2011/4/21 Robert Haas rh...@postgresql.org: Modified Files -- doc/src/sgml/ref/alter_table.sgml         |   26 +++

[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

[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

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 pete...@gmx.net 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

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 Lanet...@sss.pgh.pa.us wrote: Joshua D. Drakej...@commandprompt.com 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

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 ste...@kaltenbrunner.cc 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

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 ste...@kaltenbrunner.cc 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

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 br...@momjian.us 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

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

2011-05-28 Thread Tom Lane
Robert Haas robertmh...@gmail.com 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

Re: [HACKERS] eviscerating the parser

2011-05-28 Thread Jeff Janes
On Sun, May 22, 2011 at 3:10 PM, Robert Haas robertmh...@gmail.com 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

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 your

Re: [HACKERS] eviscerating the parser

2011-05-28 Thread Robert Haas
On Sat, May 28, 2011 at 5:51 PM, Jeff Janes jeff.ja...@gmail.com 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

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 and...@anarazel.de 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

Re: [HACKERS] switch UNLOGGED to LOGGED

2011-05-28 Thread Robert Haas
On Fri, May 27, 2011 at 6:19 AM, Noah Misch n...@leadboat.com 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

[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

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 t...@sss.pgh.pa.us 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

[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

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 g...@turnstep.com 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

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

2011-05-28 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sat, May 28, 2011 at 11:23 PM, Greg Sabino Mullane g...@turnstep.com 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

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 t...@sss.pgh.pa.us 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

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

2011-05-28 Thread Brendan Jurd
On 29 May 2011 14:04, Tom Lane t...@sss.pgh.pa.us 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

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

2011-05-28 Thread Tom Lane
Greg Stark gsst...@mit.edu writes: On Sat, May 28, 2011 at 12:01 PM, Tom Lane t...@sss.pgh.pa.us 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

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

2011-05-28 Thread Tom Lane
Brendan Jurd dire...@gmail.com writes: On 29 May 2011 14:04, Tom Lane t...@sss.pgh.pa.us 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