PgSql

[HACKERS] Why are these modules built without respecting my LDFLAGS?
I have a short list of modules that have been built without respecting my LDFLAGS and/or LDFLAGS_SL. They are as follows: autoinc.so citext.so earthdistance.so insert_username.so isn.so lo.so moddatetime.so refint.so tablefunc.so timetravel.so tsearch2.so I have looked around in ... 27 Jun 2010 08:28

parallelizing subplan execution (was: [HACKERS] explain and PARAM_EXEC)
Hi all, Sorry for jumping in over 4 months later... On Sat, Feb 20, 2010 at 8:25 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: On Sat, Feb 20, 2010 at 8:31 AM, Dimitri Fontaine <dfontaine(a)hi-media.com> wrote: This is really a topic for another thread, but at 100,000 feet it seems to me that the h... 1 Jul 2010 02:22

[HACKERS] simplifying emode_for_corrupt_record
On Mon, Jun 14, 2010 at 10:08 AM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Bruce Momjian <bruce(a)momjian.us> writes: Magnus Hagander wrote: It means that we can't prevent people from configuring their tools to ignore important warning. We can't prevent them rom ignoring ERROR or FATAL either... M... 25 Jun 2010 17:35

Admission Control
On Fri, Jun 25, 2010 at 1:33 PM, Kevin Grittner <Kevin.Grittner(a)wicourts.gov> wrote: Recent discussions involving the possible benefits of a connection pool for certain users has reminded me of a brief discussion at The Royal Oak last month, where I said I would post a reference a concept which might allev... 11 Jul 2010 04:00

GSoC - code of implementation of materialized views
> On http://github.com/pbaros/postgres can be seen changes and my attempt to implement materialized views. The first commit to the repository implements following: Materialized view can be created, dropped and used in SELECT statement. CREATE MATERIALIZED VIEW mvname AS SELECT ...; DROP MATERIA... 8 Jul 2010 13:37

pgsql: Fix log_temp_files docs andcomments to say bytes not kilobytes.
Shouldn't this be backpatched, or was this a new bug in 9.0? We've always output bytes. I'd have noticed the discrepancy myself if I'd read the actual docs ;-) KB would be more useful. And I don't think people have enough scripts built on this yet to make this break anything. We should backport to 8.4... 7 Jul 2010 19:00

[HACKERS] Admission Control
Recent discussions involving the possible benefits of a connection pool for certain users has reminded me of a brief discussion at The Royal Oak last month, where I said I would post a reference a concept which might alleviate the need for external connection pools. For those interested, check out section 2.4 of t... 25 Jun 2010 14:17

Streaming Replication: sql error on standby
On Wed, Jun 23, 2010 at 4:48 AM, Sander, Ingo (NSN - DE/Munich) <ingo.sander(a)nsn.com> wrote: Sql query "select pg_last_xlog_receive_location(); " does not work during startup of standby database. TestScenario; We have a active-standby system with PostgreSQL Streaming Replication beta2. If the active dat... 27 Jun 2010 08:28

[HACKERS] Streaming Replication: sql error on standby
Hi, Sql query "select pg_last_xlog_receive_location(); " does not work during startup of standby database. TestScenario; We have a active-standby system with PostgreSQL Streaming Replication beta2. If the active database is up the database is in use (read/write queries will be performed). Then the standby Postgr... 25 Jun 2010 12:05

pgsql: Fix log_temp_files docs and comments tosay bytes not kilobytes.
On Fri, 2010-06-25 at 17:25 +0300, Heikki Linnakangas wrote: On 25/06/10 16:11, Simon Riggs wrote: Log Message: ----------- Fix log_temp_files docs and comments to say bytes not kilobytes. stat(2) field st_size returns bytes not kilobytes. Bug found during recent performance tuning for Postg... 25 Jun 2010 12:05