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

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

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

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

Re: [HACKERS] autovacuum_work_mem

2013-10-20 Thread Magnus Hagander
On Sun, Oct 20, 2013 at 2:22 AM, Peter Geoghegan p...@heroku.com 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],

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 and...@2ndquadrant.com wrote: Josh said we should treat replication connections in a separate pool from normal database connections, right? So you withdraw your

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 the

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

2013-10-20 Thread Dimitri Fontaine
Noah Misch n...@leadboat.com 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

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 Lanet...@sss.pgh.pa.us: Pavel Stehulepavel.steh...@gmail.com writes: I found so there are no simple API for working with LO from PL without access to file system.

[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

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, called ;-));

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] 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) = sizeof(size_t)?

[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

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 track of

Re: [HACKERS] proposal: lob conversion functionality

2013-10-20 Thread Pavel Stehule
2013/10/21 Noah Misch n...@leadboat.com 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 Lanet...@sss.pgh.pa.us: Pavel Stehulepavel.steh...@gmail.com writes: I found so there are no simple API for working with LO

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 haribabu.ko...@huawei.com wrote: On 12 October 2013 11:30 Tom Lane wrote: Haribabu kommi haribabu.ko...@huawei.com writes: To handle the above case instead of directly resetting the dead tuples as

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