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 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 wrote: >> > I don't see the "don't modify the user files" behavior changing anytime >> > soon, and it is documented, so I feel pr

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 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 >> > g

Re: [HACKERS] tuplesort memory usage: grow_memtuples

2012-07-27 Thread Jeff Janes
On Wed, Jul 25, 2012 at 2:51 PM, Peter Geoghegan wrote: > On 3 March 2012 20:22, Jeff Janes 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 could be salvaged by the kernel ke

[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" 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: fata

Re: [HACKERS] Covering Indexes

2012-07-27 Thread Merlin Moncure
On Fri, Jul 27, 2012 at 12:24 PM, Jeff Davis 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 heart, this i

Re: [HACKERS] Build failures with Mountain Lion

2012-07-27 Thread Tom Lane
Robert Creager 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 pgp_key_id(dearmor(seckey)) from >

Re: [HACKERS] PostgreSQLs Extension

2012-07-27 Thread Jaime Casanova
On Thu, Jul 26, 2012 at 2:56 PM, Anderson C. Carniel 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 the way > queries