Re: [HACKERS] Commitfest II CLosed

2013-10-20 Thread Andres Freund
On 2013-10-20 08:12:37 -0700, David Fetter wrote: > > what will happen to patches left in pending state in the 2013-09 CF? > > I have moved them to the next CF. This does not mean that they are > abandoned until then. I strongly suspect that people will be > reviewing and committing many of them

Re: [HACKERS] Heavily modified big table bloat even in auto vacuum is running

2013-10-20 Thread Haribabu kommi
On 20 October 2013 12:06 Amit Kapila wrote: >On Tue, Oct 15, 2013 at 3:37 PM, Haribabu kommi >wrote: >> On 12 October 2013 11:30 Tom Lane wrote: >>>Haribabu kommi writes: To handle the above case instead of directly resetting the dead tuples as zero, how if the exact dead tuples are r

Re: [HACKERS] proposal: lob conversion functionality

2013-10-20 Thread Pavel Stehule
2013/10/21 Noah Misch > On Mon, Sep 30, 2013 at 01:06:15PM +0300, Heikki Linnakangas wrote: > > On 12.08.2013 21:08, Pavel Stehule wrote: > >> 2013/8/10 Tom Lane: > >>> Pavel Stehule writes: > I found so there are no simple API for working with LO from PL without > access to file syste

Re: [HACKERS] FDW API / flow charts for the docs?

2013-10-20 Thread David Fetter
On Sat, Oct 19, 2013 at 01:56:23PM -0400, Peter Eisentraut wrote: > On Fri, 2013-10-18 at 18:46 -0400, Stephen Frost wrote: > > As to your point about not wanting to do it for a single image- it seems > > we could potentially say that for every individual image proposed, but > > if we don't keep tr

[HACKERS] stats for network traffic WIP

2013-10-20 Thread Nigel Heron
Hi, I've been using postgres for many years but never took the time to play with the code until now. As a learning experience i came up with this WIP patch to keep track of the # of bytes sent and received by the server over it's communication sockets. Counters are kept per database, per connection

Re: [HACKERS] signed vs. unsigned in TYPEALIGN (was Re: space reserved for WAL record does not match what was written: panic on windows)

2013-10-20 Thread Noah Misch
On Fri, Oct 18, 2013 at 12:10:17AM +0200, Andres Freund wrote: > On 2013-10-17 18:04:34 -0400, Noah Misch wrote: > > On Thu, Oct 17, 2013 at 08:27:01PM +0200, Andres Freund wrote: > > > On 2013-10-17 12:33:45 -0400, Noah Misch wrote: > > > > > 1. Is there any guarantee that sizeof(intptr_t) >= size

Re: [HACKERS] strange behavior with C function and DEFAULT function parameters

2013-10-20 Thread Andrew Dunstan
On 10/20/2013 08:38 PM, Tomas Vondra wrote: Hi, I ran into some pretty strange behavior of C-language function and default parameter values, both on 9.2 and 9.4devel. Consider for example this trivial C function: Datum show_bug(PG_FUNCTION_ARGS) { elog(WARNING, "called ;-)");

Re: [HACKERS] strange behavior with C function and DEFAULT function parameters

2013-10-20 Thread Tomas Vondra
On 21.10.2013 02:38, Tomas Vondra wrote: > Hi, > > I ran into some pretty strange behavior of C-language function and > default parameter values, both on 9.2 and 9.4devel. Consider for example > this trivial C function: > > Datum > show_bug(PG_FUNCTION_ARGS) { > elog(WARNING, "calle

[HACKERS] strange behavior with C function and DEFAULT function parameters

2013-10-20 Thread Tomas Vondra
Hi, I ran into some pretty strange behavior of C-language function and default parameter values, both on 9.2 and 9.4devel. Consider for example this trivial C function: Datum show_bug(PG_FUNCTION_ARGS) { elog(WARNING, "called ;-)"); PG_RETURN_VOID(); } which is access

Re: [HACKERS] proposal: lob conversion functionality

2013-10-20 Thread Noah Misch
On Mon, Sep 30, 2013 at 01:06:15PM +0300, Heikki Linnakangas wrote: > On 12.08.2013 21:08, Pavel Stehule wrote: >> 2013/8/10 Tom Lane: >>> Pavel Stehule writes: I found so there are no simple API for working with LO from PL without access to file system. >>> >>> What? See lo_open(), lor

Re: [HACKERS] [PATCH] Statistics collection for CLUSTER command

2013-10-20 Thread Dimitri Fontaine
Noah Misch writes: > wrapper function. A backend change that would help here is to extend event > triggers to cover the CLUSTER command, permitting you to inject monitoring > after plain CLUSTER and dispense with the wrapper. I didn't look in any level of details, but it might be as simple as mo

Re: [HACKERS] Commitfest II CLosed

2013-10-20 Thread David Fetter
On Sun, Oct 20, 2013 at 10:42:10AM +0200, Boszormenyi Zoltan wrote: > Hi, > > 2013-10-19 17:20 keltezéssel, David Fetter írta: > >Thanks very much to Mike Blackwell and Craig Kerstiens for their > >persistence through what most people would consider a tedious and > >thankless task. Thanks also to

Re: [HACKERS] Patch for reserved connections for replication users

2013-10-20 Thread Euler Taveira
On 15-10-2013 14:34, Josh Berkus wrote: > On 10/15/2013 07:36 AM, Robert Haas wrote: >> On Tue, Oct 15, 2013 at 10:34 AM, Andres Freund >> wrote: >>> Josh said we should treat replication connections in a separate "pool" >>> from normal database connections, right? So you withdraw your earlier >>

Re: [HACKERS] autovacuum_work_mem

2013-10-20 Thread Magnus Hagander
On Sun, Oct 20, 2013 at 2:22 AM, Peter Geoghegan wrote: > There has recently been considerable discussion around auto-tuning. > Throughout the course of this discussion, I raised the idea of > creating a new GUC to separately control autovacuum's usage of > maintenance_work_mem [1], explaining the

Re: [HACKERS] Commitfest II CLosed

2013-10-20 Thread Boszormenyi Zoltan
Hi, 2013-10-19 17:20 keltezéssel, David Fetter írta: Thanks very much to Mike Blackwell and Craig Kerstiens for their persistence through what most people would consider a tedious and thankless task. Thanks also to the patch submitters, reviewers and other participants. That the formal commitf

Re: [HACKERS] GIN improvements part 1: additional information

2013-10-20 Thread Bruce Momjian
On Sat, Oct 19, 2013 at 05:11:55PM -0400, Bruce Momjian wrote: > I am in Moscow with Alexander and we were discussing GIN pg_upgrade > issues. One option we have already discussed was to take the old GIN > index code and put it in a separate directory, and call the new GIN > index something differ