PgSql
in [SQL]
|
Invalidating dependent views and functions Scott Bailey <artacus(a)comcast.net> wrote: Problem: We need to change the last_name column of the people table from varchar(30) to varchar(50). Proposal: Add an invalid flag to pg_class. Your example is one of the simplest cases, but there are other complex usages. For example, shrinking varchar length... 3 May 2010 01:13
[HACKERS] Invalidating dependent views and functions I've been working on a brute force method of saving view and function source when changes to an underlying object force that object to be dropped. But I think there is a way for Postgres to handle this that wouldn't be too hard to implement and would be extremely useful for us users. Problem: We need to chan... 30 Apr 2010 04:00
[HACKERS] COPY is not working Hi, COPY is not working on latest HEAD? """ regression=# select * from a; aa ---- 32 56 (2 rows) regression=# COPY a TO '/tmp/copy_test'; COPY 0 """ -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 ... 30 Apr 2010 01:52
[HACKERS] failed assertion and panic in standby mode Hi, i was trying recent HS and get this when trying to start the standby, actually i was expecting a crash because i use full_page_writes=off and i guess it won't work. Maybe we could say full_page_writes=off and wal_level=hot_standby are conflicting and avoid such setup? """ LOG: database system was interrup... 30 Apr 2010 01:52
pg_migrator to /contrib in a later 9.0 beta Bruce Momjian wrote: and most of the limitations of pg_migrator are gone when migrating to 9.0, even from Postgres 8.3. This could help beta testers move their data to 9.0 as well. Wouldn't this help even for beta1? Cheers Mark -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)post... 11 May 2010 23:24
[HACKERS] pg_migrator to /contrib in a later 9.0 beta Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: On Mon, Apr 26, 2010 at 9:26 PM, Bruce Momjian <bruce(a)momjian.us> wrote: There was talk of including pg_migrator in Postgres 9.0 in /contrib. �Do we still want to do that? I think you articulated some pretty good reasons previously... 29 Apr 2010 18:04
Hot Standby tuning for btree_xlog_vacuum() Simon Riggs <simon(a)2ndQuadrant.com> writes: Objections to commit? This is not the time to be hacking stuff like this. You haven't even demonstrated that there's a significant performance issue here. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make chang... 17 May 2010 16:54
pgsql: Make CheckRequiredParameterValues()depend upon correct Aidan Van Dyk wrote: It's all about the path of least *suprise*. My "least suprise" would have been that a similar config I have now with my PITR slaves would pretty much still work, and not suddenly start accepting connections, and even worse, at some later date when I've already verified that it was d... 29 Apr 2010 14:40
s/recovery_connections/allow_standby_queries/, or somethinglike that? Tom Lane wrote: I think a different name would help. The best idea I can come up with on the spur of the moment is "allow_standby_queries", but I'm not sure that can't be improved on. Comments? One objection to that name is that it also works during archive recovery, like during PITR, which is not a stan... 29 Apr 2010 14:40
s/recovery_connections/allow_standby_queries/, or something like that? On Thu, Apr 29, 2010 at 1:18 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: I've just realized that one of the confusing things about this debate is that the recovery_connections parameter is very confusingly named. It might have been okay when HS existed in isolation, but with SR in the mix, it's not at all clear... 29 Apr 2010 14:40 |