[HACKERS] Planner deficiencies with views that use windowing functions I found some interesting discrepancies with the query planner when working with views (and presumably table subqueries) that contain windowing functions.� This is all tested on 9.0beta2, though I suspect 8.4 has the same limitations. The short version is: - If querying a windowing view and asking only for column... 1 Jul 2010 02:22
Additional startup logging "Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> wrote: It seems potentially useful to LOG the version() string in the log file during startup. It might also help to LOG any settings which might result in the loss of committed transactions or in database corruption during startup. (After a crash, the po... 1 Jul 2010 01:17
Streaming Replication: Checkpoint_segment andwal_keep_segments on standby Did these changes ever get into the docs? I don't think so. --------------------------------------------------------------------------- Fujii Masao wrote: On Thu, Jun 10, 2010 at 7:19 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: --- 1902,1908 ---- ? ? ? ? ?for standby p... 30 Jun 2010 23:06
How MTV pulls off shock and draw <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-2"> </HEAD> <BODY> <table border="0" cellpadding="0" cellspacing="0" style="width: 896px"> <tr><td align="center" style="font: normal 11px Verdana, sans-serif; color: #333... 30 Jun 2010 20:55
Planner deficiencies with views that use windowing functions Daniel Grace <dgrace(a)wingsnw.com> writes: I found some interesting discrepancies with the query planner when working with views (and presumably table subqueries) that contain windowing functions. Yeah, there's next to no optimization for window functions ATM. This will probably get better over time, but do... 30 Jun 2010 19:49
Proposal for 9.1: WAL streaming from WALbuffers Simon Riggs wrote: On Mon, 2010-06-21 at 18:08 +0900, Fujii Masao wrote: The problem is not that the master streams non-fsync'd WAL, but that the standby can replay that. So I'm thinking that we can send non-fsync'd WAL safely if the standby makes the recovery wait until the master has fsync'd ... 30 Jun 2010 19:49
Keeping separate WAL segments for each database Excerpts from Devrim GÜNDÜZ's message of mié jun 30 14:54:06 -0400 2010: One of the things that interested me was parallel recovery feature. They said that they are keeping separate xlogs for each database, which speeds ups recovery in case of a crash. It also would increase performance, since we could wr... 3 Jul 2010 15:41
[HACKERS] Check constraints on non-immutable keys We currently allow this: postgres=# create table t(a timestamptz not null primary key, check(a > now())); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t_pkey" for table "t" CREATE TABLE Which seems very wrong. For one thing, a dump of this database can not be restored if now() has advance... 30 Jun 2010 16:29
Check constraints on non-immutable keys Magnus Hagander <magnus(a)hagander.net> writes: On Wed, Jun 30, 2010 at 16:38, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: The example seems to me to be in the category of "so don't do that" rather than something that we need to save users from. �Yes, it's In that case, should we at least throw a warning? I do... 30 Jun 2010 19:49
Look-behind regular expressions Thom Brown <thombrown(a)gmail.com> writes: Are there any plans to support look-behind and negative look-behind for regular expressions in future? No. Or are you volunteering? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription:... 30 Jun 2010 19:49 |