Re: [HACKERS] Using pg_upgrade on log-shipping standby servers

2012-07-27 Thread Robert Haas
On Thu, Jul 26, 2012 at 2:17 PM, Bruce Momjian br...@momjian.us wrote: On Thu, Jul 26, 2012 at 01:24:19PM -0400, Robert Haas wrote: On Thu, Jul 26, 2012 at 12:06 PM, Bruce Momjian br...@momjian.us wrote: I don't see the don't modify the user files behavior changing anytime soon, and it is

Re: [HACKERS] Using pg_upgrade on log-shipping standby servers

2012-07-27 Thread Robert Haas
On Thu, Jul 26, 2012 at 7:24 PM, Bruce Momjian br...@momjian.us wrote: On Thu, Jul 26, 2012 at 02:17:22PM -0400, Bruce Momjian wrote: Is that sufficient? Well, at the very least, you need to guarantee that the standby is caught up - i.e. that it replayed all the WAL records that were

Re: [HACKERS] tuplesort memory usage: grow_memtuples

2012-07-27 Thread Jeff Janes
On Wed, Jul 25, 2012 at 2:51 PM, Peter Geoghegan pe...@2ndquadrant.com wrote: On 3 March 2012 20:22, Jeff Janes jeff.ja...@gmail.com wrote: Add it all up, and instead of pre-reading 32 consecutive 8K blocks, it pre-reads only about 1 or 2 consecutive ones on the final merge. Now some of those

[HACKERS] PostgreSQLs Extension

2012-07-27 Thread Anderson C. Carniel
Hi! I am developing a work that will need to make some changes in the PostgreSQL source code. More precisely, I'll also make changes in the PostGIS extension. So I work with geographic data. I wonder if someone can show me a better way for me to make such changes in PostgreSQL: - I need to set

Re: [HACKERS] Covering Indexes

2012-07-27 Thread Jeff Davis
On Thu, 2012-07-26 at 12:13 -0400, Bruce Momjian wrote: So, do we want a TODO item about adding columns to a unique index that will not be used for uniqueness checks? -1 from me, at least in its current form. At it's heart, this is about separating the constraint from the index that enforces

Re: [HACKERS] [GENERAL] fgets failure in Solaris after patching

2012-07-27 Thread Tom Lane
Stephan, Richard rstep...@nyiso.com writes: More information (9.0.8): $ pg_ctl start Killed fgets failure: Error 0 The program postgres is needed by pg_ctl but was not found in the same directory as /opt/postgres/9.0/bin/pg_ctl. Check your installation. $ postgres -V ld.so.1: postgres:

Re: [HACKERS] Covering Indexes

2012-07-27 Thread Merlin Moncure
On Fri, Jul 27, 2012 at 12:24 PM, Jeff Davis pg...@j-davis.com wrote: On Thu, 2012-07-26 at 12:13 -0400, Bruce Momjian wrote: So, do we want a TODO item about adding columns to a unique index that will not be used for uniqueness checks? -1 from me, at least in its current form. At it's

Re: [HACKERS] Build failures with Mountain Lion

2012-07-27 Thread Tom Lane
Robert Creager rob...@logicalchaos.org writes: Working on bringing online a new build farm machine running Mountain Lion. Warnings are being generated in the contrib installcheck phase, causing the failure of the build transaction. [5012f1c9.4014:27] LOG: statement: select

Re: [HACKERS] PostgreSQLs Extension

2012-07-27 Thread Jaime Casanova
On Thu, Jul 26, 2012 at 2:56 PM, Anderson C. Carniel accarn...@gmail.com wrote: - I need to set a new data type specific, as the PostGIS. I saw that in PostgreSQL's Documentation there is a User-Defined Types. This is the best way to define a new data type? Using this approach, can I define