FAQ

PostgreSQL > pgsql-hackers > May 2011

Search Discussions

167 discussions - 1,664 posts

  • Right, the problem has been the lukewarm response from the hackers who would be using it every day, and without whose buy-in using a bug tracker would be possible, but much more difficult. Bug ...
    Greg Sabino MullaneGreg Sabino Mullane
    May 29, 2011 at 3:48 am
    Jun 3, 2011 at 9:33 pm
  • So, what do we need in order to find our way to index-only scans? 1. The visibility map needs to be crash-safe. The basic idea of index-only scans is that, instead of checking the heap to find out ...
    Robert HaasRobert Haas
    May 10, 2011 at 2:25 am
    Sep 27, 2011 at 1:41 pm
  • Hackers, I've run into a couple of occasions lately where I really wanted pgstattuple on a production server in order to check table/index bloat. However, in the production environment at a large ...
    Josh BerkusJosh Berkus
    May 5, 2011 at 10:34 pm
    May 19, 2011 at 11:41 am
  • Hi, One of our customers is interested in being able to store original timezone along with a certain timestamp. It is currently possible to store a TZ in a separate column, but this is a bit wasteful ...
    Alvaro HerreraAlvaro Herrera
    May 27, 2011 at 8:43 pm
    Jul 26, 2011 at 11:30 pm
  • This patch allows you to initially declare a CHECK constraint as NOT VALID, similar to what we already allow for foreign keys. That is, you create the constraint without scanning the table and after ...
    Alvaro HerreraAlvaro Herrera
    May 31, 2011 at 4:04 pm
    Jun 30, 2011 at 4:00 pm
  • Hi, I am working on new feature `Buffer Cache Hibernation' which enables postgres to keep higher cache hit ratio even just started. Postgres usually starts with ZERO buffer cache. By saving the ...
    Mitsuru IWASAKIMitsuru IWASAKI
    May 4, 2011 at 2:23 pm
    Oct 16, 2011 at 6:12 pm
  • Attached is the latest revision of the latch implementation that monitors postmaster death, plus the archiver client that now relies on that new functionality and thereby works well without a tight ...
    Peter GeogheganPeter Geoghegan
    May 24, 2011 at 8:44 pm
    Jul 8, 2011 at 4:27 pm
  • Hello here is a partial review of your patch, better than keeping it sleeping in the commitfest queue I hope. Submission review ================ * The patch is not in context diff format. * The patch ...
    Cédric VillemainCédric Villemain
    May 31, 2011 at 9:25 pm
    Jul 20, 2011 at 9:21 am
  • I'd like to summarize expected issues corresponding to leaky-view and RLS towards v9.2, and PGcon2011/Developer Meeting. We already made consensus the leaky-view is a problem to be fixed previous to ...
    Kohei KaigaiKohei Kaigai
    May 10, 2011 at 11:56 am
    Jul 20, 2011 at 2:43 pm
  • I think I see what must be going on here: that toast table must contain a long run of all-visible-according-to-the-VM pages (which is hardly a surprising situation). This results in VACUUM choosing ...
    Tom LaneTom Lane
    May 25, 2011 at 3:48 pm
    May 29, 2011 at 11:33 pm
  • Hello, A customer came to us with this request: a way to store "any" data in a column. We've gone back and forth trying to determine reasonable implementation restrictions, safety and useful ...
    Alvaro HerreraAlvaro Herrera
    May 4, 2011 at 4:58 pm
    May 11, 2011 at 9:06 pm
  • In http://archives.postgresql.org/pgsql-bugs/2011-05/msg00171.php Regina Obe complains that this fails in 9.1, though it worked before: regression=# CREATE DOMAIN topoelementarray AS integer[]; ...
    Tom LaneTom Lane
    May 24, 2011 at 4:13 pm
    Jun 8, 2011 at 4:57 pm
  • The basis for this is that weak locks do not conflict with each other, whereas strong locks conflict with both strong and weak locks. (There's a couple of special cases which I ignore for now). ...
    Simon RiggsSimon Riggs
    May 31, 2011 at 1:23 pm
    May 31, 2011 at 1:45 pm
  • Hello cache estimation and cache access cost are currently not accounted explicitly: they have a cost associated with but no constants (other than effective_cache_size but it has a very limited ...
    Cédric VillemainCédric Villemain
    May 15, 2011 at 9:39 pm
    Jun 20, 2011 at 7:01 pm
  • Hi, If i create a DOMAIN an then want to create a CAST from that domain to another type it gives an error. Consider this example: """ create domain datetime as timestamp with time zone check (value ...
    Jaime CasanovaJaime Casanova
    May 14, 2011 at 6:28 pm
    Apr 24, 2012 at 1:21 pm
  • I'd like to revive the discussion that arose during the last CommitFest over the proper design for identifying no-op length coercions like varchar(4) - varchar(8). Here is the root of the original ...
    Noah MischNoah Misch
    May 23, 2011 at 4:42 pm
    Jun 22, 2011 at 2:22 am
  • Hi all, Attached is a simple patch addressing the TODO item "Allow \dd to show constraint comments". If you have comments on various constraints (column, foreign key, primary key, unique, exclusion), ...
    Josh KupershmidtJosh Kupershmidt
    May 18, 2011 at 2:28 am
    Sep 11, 2011 at 2:12 pm
  • Hi, following the conversation at http://postgresql.1045698.n5.nabble.com/switch-UNLOGGED-to-LOGGED-tp4290461p4382333.html I tried to remove some bytes from xl_xact_commit. The way I did it needs ...
    Leonardo FrancalanciLeonardo Francalanci
    May 16, 2011 at 3:20 pm
    Jun 16, 2011 at 5:45 pm
  • There is a general need to have Postgres consume fewer CPU cycles and less power when idle. Until something is done about this, shared hosting providers, particularly those who want to deploy many VM ...
    Peter GeogheganPeter Geoghegan
    May 5, 2011 at 7:49 pm
    May 11, 2011 at 10:42 am
  • As background, for most of SSI development I had a TODO comment in the source which was basically around the question of whether a predicate lock on a visible heap tuple should propagate to later ...
    Kevin GrittnerKevin Grittner
    May 21, 2011 at 8:09 pm
    Jun 3, 2011 at 10:04 am
  • Hi I would like to develop function for 'Online base backup from the hot-standby' in PostgreSQL 9.2. Todo : Allow hot file system backups on standby servers (http://wiki.postgresql.org/wiki/Todo) ...
    Jun IshidukaJun Ishiduka
    May 27, 2011 at 6:25 am
    Jul 12, 2011 at 7:14 am
  • Greetings, Someone (*cough*Haas*cough) made a claim over beers at PGCon that it would be very difficult to come up with a way to pre-allocate List entries and maintain the current List API. I'll ...
    Stephen FrostStephen Frost
    May 25, 2011 at 2:56 am
    Aug 30, 2012 at 1:58 am
  • I noticed the 9.1 release notes claim that the new EDITOR_LINENUMBER_SWITCH thing is an environment variable, whereas it is actually a psql variable. This is perhaps sort of a Freudian slip. Since ...
    Peter EisentrautPeter Eisentraut
    May 21, 2011 at 9:54 pm
    Oct 15, 2011 at 4:03 pm
  • Here's an attempt at implementing the necessary gymnastics. Comments? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
    Robert HaasRobert Haas
    May 6, 2011 at 9:47 pm
    Jun 24, 2011 at 6:20 pm
  • I've applied patches to fix Martin Pitt's report of peer auth failing on FreeBSD-amd64 kernels. I tested it with FreeBSD but do not have the resources to check every other platform that uses the same ...
    Tom LaneTom Lane
    May 30, 2011 at 11:57 pm
    Jun 2, 2011 at 5:15 pm
  • I have missed it if this was discussed before but ... Would now be a good time to start deprecating the contrib/ directory as a way to distribute Pg add-ons, with favor given to PGXN and the like ...
    Darren DuncanDarren Duncan
    May 17, 2011 at 8:31 pm
    May 18, 2011 at 7:36 pm
  • If you use "pgbench -S -M prepared" at a scale where all data fits in memory, most of what you are benchmarking is network/IPC chatter, and table locking. Which is fine if that is what you want to ...
    Jeff JanesJeff Janes
    May 29, 2011 at 7:11 pm
    Jul 16, 2012 at 1:57 am
  • I sometimes wonder if we could pull up aggregate query in the optimizer. My typical problem is: Consider two relations, medium size M and large size L. L has reference column to M's primary key. Say, ...
    Hitoshi HaradaHitoshi Harada
    May 4, 2011 at 10:02 am
    Jun 4, 2011 at 4:47 pm
  • This doesn't surprise me too much, because sequences are not expected to contain any live XIDs, so the XID freezing mechanism ignores them. So if you did that in the past, this would eventually ...
    Tom LaneTom Lane
    May 31, 2011 at 3:17 am
    Jun 2, 2011 at 7:54 pm
  • Hi, In my opinion this is actually a bug in < 9.0. As its a (imo) low impact fix thats constrained to two files it seems sensible to backpatch it now that the solution has proven itself in the field? ...
    Andres FreundAndres Freund
    May 5, 2011 at 9:21 am
    May 13, 2011 at 4:17 pm
  • Hi everyone, several members of this mailing list mentioned recently it'd be really useful to have a performance-test farm, that it might improve the development process and make some changes easier. ...
    Tomas VondraTomas Vondra
    May 11, 2011 at 9:32 pm
    Apr 4, 2012 at 1:01 pm
  • [ Moved to hackers list.] Interesting. It can be easily fixed in the C code. Does anyone know of an example where the case of the locale name is significant in controlling the behavior? -- Bruce ...
    Bruce MomjianBruce Momjian
    May 23, 2011 at 1:39 am
    Oct 13, 2011 at 5:09 pm
  • Hi All, Some of the ideas regarding vacuum improvements were discussed here: http://archives.postgresql.org/pgsql-hackers/2008-05/msg00863.php ...
    Pavan DeolaseePavan Deolasee
    May 24, 2011 at 6:58 am
    Jun 8, 2011 at 11:52 pm
  • The attached patch enables to assign security labels on shared database object types (database, tablespace, role). As pg_description stuff doing, it adds a new pg_shseclabel catalog to store related ...
    Kohei KaigaiKohei Kaigai
    May 9, 2011 at 11:15 am
    Jul 20, 2011 at 5:18 pm
  • [I previously posted this to pgsql-sql, but received no response as of yet... it's more of a development team oriented message in any case.] In ORMs like NHibernate, there are a few strategies for ...
    Patrick EarlPatrick Earl
    May 1, 2011 at 5:33 pm
    Jul 11, 2011 at 7:07 pm
  • One of the things that came out of the clustering session is a need for a LOCK DATABASE command. Primarily to be able to drop databases across nodes in a cluster, but later chats lead to ideas about ...
    Alvaro HerreraAlvaro Herrera
    May 18, 2011 at 3:21 am
    May 26, 2011 at 11:23 pm
  • Hackers, I've replaced test-report-by-email with a GoogleDocs application for Beta1. The form for submitting test reports is here: ...
    Josh BerkusJosh Berkus
    May 2, 2011 at 6:21 pm
    May 3, 2011 at 8:38 pm
  • While looking at fixing the multiple-evaluation issue in IN and BETWEEN discussed a while ago, I realized that the current assumption that only one CaseTestExpr placeholder needs to be valid at any ...
    Heikki LinnakangasHeikki Linnakangas
    May 25, 2011 at 11:57 am
    Jun 17, 2011 at 8:55 am
  • While eating good Indian food and talking about aviation accidents on the last night of PGCon, Greg Stark, Heikki Linnakangas, and I found some time to brainstorm about possible ways to reduce the ...
    Robert HaasRobert Haas
    May 24, 2011 at 8:34 pm
    May 27, 2011 at 7:32 pm
  • Hi I want to propose the addition of a new field in IDENTIFY_SYSTEM: xlogversion, which will carry XLOG_PAGE_MAGIC from primary. The idea of sending that info is to allow us to know if the xlog page ...
    Jaime CasanovaJaime Casanova
    May 3, 2011 at 10:57 pm
    May 25, 2011 at 5:56 pm
  • During preparing patch of my GSoC project I found reasonable to move childoffnum (GISTInsertStack structure) from parent to child. This means that now child have childoffnum of parent's link to ...
    Alexander KorotkovAlexander Korotkov
    May 24, 2011 at 12:22 pm
    Jul 15, 2011 at 10:01 am
  • I reviewed the process for configuring replication, and found that we don't have an example for allowing replication access in pg_hba.conf. Before we release 9.1, I think we should add this example ...
    Selena DeckelmannSelena Deckelmann
    May 18, 2011 at 4:17 pm
    May 24, 2011 at 8:01 pm
  • I wonder if we have tested the reasoning behind having SKIP_PAGES_THRESHOLD and the magic number of 32 assigned to it currently. While looking at the code after a long time and doing some tests, I ...
    Pavan DeolaseePavan Deolasee
    May 27, 2011 at 1:52 pm
    Jun 7, 2011 at 10:59 am
  • Just to see how much difference it would make, I tried ripping everything out of the parser except for support for DML queries. In addition to removing the actual rules, I also yanked out most of the ...
    Robert HaasRobert Haas
    May 20, 2011 at 10:41 pm
    May 29, 2011 at 12:28 am
  • Hi, I was trying to create a trigger with parameters. I've found a potential bug when the param is boolean. Here is code replicating the bug: CREATE TABLE x(x TEXT); CREATE OR REPLACE FUNCTION ...
    Szymon GuzSzymon Guz
    May 11, 2011 at 8:47 am
    May 11, 2011 at 6:04 pm
  • I had a chance to give this patch a look. This review is of the second patch posted by Gurjeet, at: ...
    Josh KupershmidtJosh Kupershmidt
    May 14, 2011 at 9:04 pm
    Jul 6, 2011 at 5:08 pm
  • I have found a problem which is specifically related to "HP-UX" compiler. All 'libm' functions on "HP-UX Integrity server" do not set "errno" by default. For 'errno' setting we should compile the ...
    Ibrar AhmedIbrar Ahmed
    May 24, 2011 at 5:21 pm
    May 27, 2011 at 10:10 pm
  • I believe that the "make check" target in src/test/isolation is fundamentally unportable, as is illustrated by the fact that buildfarm member coypu is currently choking on it. The reason is that the ...
    Tom LaneTom Lane
    May 8, 2011 at 11:35 pm
    Feb 29, 2012 at 8:08 pm
  • Hi, Cube code provided by postgres contrib folder. It uses the NDBOX structure. On creating index, it's size increase at a high rate. On inserting some tuple and creating indexes its behaviour is ...
    Nick RajNick Raj
    May 30, 2011 at 8:36 pm
    Jun 4, 2011 at 2:55 pm
  • Hi, Query: ===== I am aware of the fact that Expression evaluator is used to filter tuples based on the qual. However, I think it is not the only purpose it serves. As I manipulated the ExecEvalVar ...
    Vaibhav KaushalVaibhav Kaushal
    May 25, 2011 at 9:57 am
    May 27, 2011 at 3:59 am
May 2011
1234
Group Navigation
period‹ prev | May 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions167
posts1,664
users136
websitepostgresql.org...
irc#postgresql

136 users for May 2011

Tom Lane: 243 posts Robert Haas: 240 posts Bruce Momjian: 79 posts Alvaro Herrera: 65 posts Kevin Grittner: 65 posts Peter Eisentraut: 65 posts Andrew Dunstan: 47 posts Magnus Hagander: 46 posts Joshua Berkus: 43 posts Greg Smith: 38 posts Greg Stark: 36 posts Heikki Linnakangas: 35 posts Simon Riggs: 35 posts Noah Misch: 33 posts Merlin Moncure: 26 posts Cédric Villemain: 24 posts Pavan Deolasee: 23 posts David E. Wheeler: 22 posts Peter Geoghegan: 20 posts Jaime Casanova: 19 posts
show more
Archives