FAQ

Search Discussions

128 discussions - 1,921 posts

  • Hi, all I am a student of Computer Science and Applied Math in a university in Singapore. I'm planning to join Google Summer Code 2012 on PostgreSQL. It's quite an honor to join the postgresql hacker ...
    HuangQiHuangQi
    Mar 17, 2012 at 3:51 pm
    May 14, 2012 at 11:57 am
  • I decided to investigate the possible virtues of allowing "text" to use the sortsupport infrastructure, since strings are something people often want to sort. I generated 100,000 random alphanumeric ...
    Robert HaasRobert Haas
    Mar 2, 2012 at 8:45 pm
    Oct 9, 2012 at 7:22 am
  • Hi, Pavel's patch for CHECK FUNCTION is adding another command besides that one, which is CHECK TRIGGER. The idea behind this is that you give it the relation to which the trigger is attached in ...
    Alvaro HerreraAlvaro Herrera
    Mar 3, 2012 at 8:49 pm
    Apr 5, 2012 at 10:47 am
  • As noted by the manual, pg_statistic is ported in any way when performing pg_upgrade. I have been investigating what it would take to (even via just a connected SQL superuser client running UPDATE or ...
    Daniel FarinaDaniel Farina
    Mar 13, 2012 at 1:39 am
    Mar 16, 2012 at 10:55 pm
  • Dear Developers, I am looking for elegant and effective way for running jobs inside a database or cluster - for now I can not find that solution. OK if You say "use cron" or "pgAgent" I say I know ...
    Artur LitwinowiczArtur Litwinowicz
    Mar 5, 2012 at 7:19 pm
    Mar 12, 2012 at 9:02 am
  • Hi, I guess it's time to start a new thread here. Please find attached version 16 of the command trigger patch, with augmented documentation and “magic variable” support (TG_WHEN, TG_OBJECTID and ...
    Dimitri FontaineDimitri Fontaine
    Mar 15, 2012 at 6:13 pm
    Mar 28, 2012 at 2:44 pm
  • Hi All, I am Atri Sharma.I am a C developer with experience in database designing and database management systems.I have worked with MySql,Oracle and other database systems.I have designed databases ...
    Atri SharmaAtri Sharma
    Mar 17, 2012 at 8:39 am
    Apr 9, 2012 at 7:21 pm
  • Hi, I guess I sent v17 a little early considering that we now already have v18 including support for CREATE TABLE AS and SELECT INTO, thanks to the work of Andres and Tom. There was some spurious ...
    Dimitri FontaineDimitri Fontaine
    Mar 20, 2012 at 5:49 pm
    Apr 3, 2012 at 12:29 pm
  • It's been bugging me for a while now that we don't have a prewarming utility, for a couple of reasons, including: 1. Our customers look at me funny when I suggest that they use pg_relation_filepath() ...
    Robert HaasRobert Haas
    Mar 9, 2012 at 4:13 am
    Aug 16, 2012 at 5:37 am
  • Folks, This is for 9.3, of course. I noticed that CREATE FOREIGN TABLE (LIKE some_table) doesn't work. I believe it should, as it would: - Remove a POLA violation - Make data loading into an extant ...
    David FetterDavid Fetter
    Mar 13, 2012 at 3:25 pm
    Jul 12, 2012 at 9:00 pm
  • This thread evolved out of an attempt to implement pg_terminate_backend for non-superusers. I thought -- probably erroneously -- that the major objection to that was the known possibility of a ...
    Daniel FarinaDaniel Farina
    Mar 18, 2012 at 12:29 am
    Mar 28, 2012 at 2:33 pm
  • To avoid any confusion as to where this proposed feature is now, I'd like to summarise my understanding, make proposals and also request clear feedback on them. Checksums have a number of objections ...
    Simon RiggsSimon Riggs
    Mar 5, 2012 at 3:03 pm
    Mar 8, 2012 at 9:02 pm
  • I ended up taking a stab at writing some userspace code for this - see attached. It measures the amount of time taken for each contended lwlock acquisition and prints a crude histogram of the results ...
    Robert HaasRobert Haas
    Mar 31, 2012 at 3:41 am
    Apr 6, 2012 at 4:30 am
  • When sorting small tuples, the memtuples array can use a substantial fraction of the total per-tuple memory used. (In the case of pass by value, it is all of it) The way it grows leads to sub-optimal ...
    Jeff JanesJeff Janes
    Mar 3, 2012 at 8:23 pm
    Dec 21, 2012 at 6:43 pm
  • I'm not sure if this is a bug, but I have wrestling with this problem for a client. Platform is Windows Servers 2003 64 bit, PostgreSQL 8.4.8., 4Gb RAM, running on an Amazon VM. Shared buffers ...
    Andrew DunstanAndrew Dunstan
    Mar 26, 2012 at 3:04 pm
    Mar 31, 2012 at 12:13 pm
  • Hi guys, Something from Josh's recent blog post about summer of code clicked with me - the HTTP / SQL concept. It was something I'd been thinking about earlier, how people really like HTTP APIs and ...
    Dobes VandermeerDobes Vandermeer
    Mar 29, 2012 at 2:37 pm
    Apr 4, 2012 at 4:40 pm
  • I reviewed this and so far have not found any serious problems, although as is par for the course it contains some of the fiddly bits involved in any string manipulations in C. I made a few edits -- ...
    Daniel FarinaDaniel Farina
    Mar 15, 2012 at 8:50 am
    Apr 11, 2012 at 7:46 am
  • For 9.3 at a minimum. The topic of LZO became mired in doubts about: * Potential Patents * The author's intention for the implementation to be GPL Since then, Google released "Snappy," also an ...
    Daniel FarinaDaniel Farina
    Mar 14, 2012 at 6:07 pm
    Apr 5, 2012 at 9:06 am
  • Parallel to pg_cancel_backend, it'd be nice to allow the user to just outright kill a backend that they own (politely, with a SIGTERM), aborting any transactions in progress, including the idle ...
    Daniel FarinaDaniel Farina
    Mar 15, 2012 at 11:14 pm
    Jun 27, 2012 at 12:47 pm
  • Postgres 9.2 has been modified so psql no longer uppercases SQL keywords when using tab completation, by this commit: commit 69f4f1c3576abc535871c6cfa95539e32a36120f Author: Peter Eisentraut ...
    Bruce MomjianBruce Momjian
    Mar 22, 2012 at 9:50 pm
    May 31, 2012 at 6:21 am
  • I've finally been able to run some more tests of the effect of adjusting wal_buffers to values higher than 16MB. I ran the test on the 16 core (x 4 hw threads/core) IBM POWER7 machine, with my usual ...
    Robert HaasRobert Haas
    Mar 11, 2012 at 3:55 am
    Mar 14, 2012 at 8:54 pm
  • Hi, I'd like to propose to change pg_controldata so that it reports the name of WAL file containing the latest checkpoint's REDO record, as follows: $ pg_controldata $PGDATA ... Latest checkpoint's ...
    Fujii MasaoFujii Masao
    Mar 23, 2012 at 4:07 am
    Jul 14, 2012 at 6:34 pm
  • There are two checkpoint-related patches in this CommitFest that haven't gotten much love, one from me and the other from Greg Smith: https://commitfest.postgresql.org/action/patch_view?id=752 ...
    Robert HaasRobert Haas
    Mar 21, 2012 at 7:16 pm
    Apr 6, 2012 at 2:55 pm
  • Greetings! I've done a brief search of the postgresql mail archives, and I've noticed a few projects for adding query caches to postgresql, (for example, Masanori Yamazaki's query cache proposal for ...
    Billy EarneyBilly Earney
    Mar 23, 2012 at 3:29 pm
    Mar 30, 2012 at 12:54 am
  • Some time ago I reported bug 6291[0], which reported a Xid wraparound, both as reported in pg_controldata and by txid_current_snapshot. Unfortunately, nobody could reproduce it. Today, the same ...
    Daniel FarinaDaniel Farina
    Mar 23, 2012 at 12:27 am
    Jun 18, 2012 at 1:55 pm
  • A user complained on pgsql-performance that SELECT col FROM table GROUP BY col LIMIT 2; performs a full table scan. ISTM that it's safe to return tuples from hash-aggregate as they are found when no ...
    Ants AasmaAnts Aasma
    Mar 28, 2012 at 2:38 am
    Jul 2, 2012 at 3:23 pm
  • Buildfarm member mussel (OS X 10.7.3, llvm-gcc 4.2.1, x86_64)seems to be getting consistent warnings when running the pgcrypto regression tests, that look like this: WARNING: detected write past ...
    Andrew DunstanAndrew Dunstan
    Mar 9, 2012 at 10:28 pm
    Mar 11, 2012 at 1:20 pm
  • I have a plan to support 'Create index on foreign table' for 9.3. Here is my plan. The index creation is supported for a flat file such as CSV and a remote table on a RDB e.g., Postgres using CREATE ...
    Etsuro FujitaEtsuro Fujita
    Mar 16, 2012 at 8:42 am
    Mar 22, 2012 at 9:38 am
  • When the root tuple of a HOT chain is dead, but there's still at least one non-dead member of the chain, we end up with a REDIRECT line pointer, which points to a USED line pointer, which in turn ...
    Robert HaasRobert Haas
    Mar 21, 2012 at 11:19 pm
    Apr 9, 2012 at 7:37 pm
  • Hello folks, I am in the process of accelerating down the rabbit hole of regex internals. Something that came up during my reading, is that a POSIX compliant regex engine ought to always prefer the ...
    Brendan JurdBrendan Jurd
    Mar 4, 2012 at 6:37 am
    Mar 5, 2012 at 8:30 pm
  • This is a fair position, but I think it's a bit unfair to be applying such pressure to just the command-triggers patch and not all the other open issues. Hence, $SUBJECT: is it time to start forcing ...
    Tom LaneTom Lane
    Mar 9, 2012 at 7:47 pm
    Mar 10, 2012 at 11:07 pm
  • Hi, pg_stat_statements is basically very helpful to find out slow queries. But since it doesn't report the time spent in the planner, we cannot find out slow queries which take most time to do query ...
    Fujii MasaoFujii Masao
    Mar 7, 2012 at 11:46 am
    Mar 8, 2012 at 4:43 pm
  • When I compiled this, I got a compiler warning. Attached patch silences the warning. Also I found one trivial problem in the doc of pg_test_timing. The patch fixes that. Regards, -- Fujii Masao ...
    Fujii MasaoFujii Masao
    Mar 28, 2012 at 2:11 am
    Mar 30, 2012 at 12:19 pm
  • Folks, I got a system here (8.3.7), that is locked up. Few queries waiting for autovacuum aquired locks on a table or two. But it looks like autovacuum is also waiting for some semaphore: #0 ...
    Gregg JaskiewiczGregg Jaskiewicz
    Mar 2, 2012 at 10:44 am
    Mar 5, 2012 at 2:34 pm
  • After my pg_upgrade commit yesterday, I started receiving dozens of spam emails from github. I am not sure if it was because I was the committer, or because I am subscribed to the github postgres ...
    Bruce MomjianBruce Momjian
    Mar 17, 2012 at 1:46 pm
    Mar 17, 2012 at 3:59 pm
  • All, I've discovered a built-in performance issue with replication failover at one site, which I couldn't find searching the archives. I don't really see what we can do to fix it, so I'm posting it ...
    Josh BerkusJosh Berkus
    Mar 13, 2012 at 11:54 pm
    Aug 30, 2012 at 2:05 pm
  • I'm implementing an extention to mdwrite() at backend/storage/smgr/md.c When a block is written to the local storage using mdwrite(), I'm sending this block to an HDFS storage. So far I don't need to ...
    Tareq AljabbanTareq Aljabban
    Mar 15, 2012 at 5:50 pm
    Mar 27, 2012 at 2:34 pm
  • Hi, We have noticed the following issue with vacuumlo database that have millions of record in pg_largeobject i.e. WARNING: out of shared memoryFailed to remove lo 155987: ERROR: out of shared memory ...
    MUHAMMAD ASIFMUHAMMAD ASIF
    Mar 20, 2012 at 9:34 am
    Mar 20, 2012 at 9:10 pm
  • I have a query where the LIMIT clause is incorrectly reducing the cost of the query. This results in queries doing LIMIT m run much longer when m is small (e.g. 1-3) than if m is larger. (PG 9.0) ...
    Simon RiggsSimon Riggs
    Mar 16, 2012 at 6:26 pm
    Mar 20, 2012 at 4:34 am
  • There is one more (known) stop-ship problem in SPGiST, which I'd kind of like to get out of the way now before I let my knowledge of that code get swapped out again. This is that SPGiST is unsafe for ...
    Tom LaneTom Lane
    Mar 13, 2012 at 2:50 am
    Aug 3, 2012 at 6:02 pm
  • I noticed while doing some tests that the checkpointer process does not recover very nicely after a backend crashes under postmaster -T (after all processes have been kill -CONTd, of course, and ...
    Alvaro HerreraAlvaro Herrera
    Mar 30, 2012 at 4:32 pm
    May 11, 2012 at 9:45 pm
  • I created an index on an hstore function, fetchval(hstore, text), however when I use the - infix operator which resolves to the very same function, this index is not used. It should be used. I have ...
    Will LeinweberWill Leinweber
    Mar 6, 2012 at 12:27 am
    Apr 15, 2012 at 3:22 pm
  • AFAICT that buys nothing except to greatly complicate the API specification for simplify_function, something that is now proving problematic for Marti's requested refactoring [1]. If it's ...
    Tom LaneTom Lane
    Mar 23, 2012 at 2:56 pm
    Mar 23, 2012 at 4:52 pm
  • I was trying to compile orafce on the current master and it yield an error at line tupdesc = trigdata- tg_relation- rd_att; alert.c: In function ‘dbms_alert_defered_signal’: alert.c:839:33: error ...
    Marco NenciariniMarco Nenciarini
    Mar 20, 2012 at 10:53 am
    Mar 20, 2012 at 8:16 pm
  • Hi, A colleague came to me to express his surprise about this quite simple use case: =# alter table toto add column user text; ERROR: syntax error at or near "user" LINE 1: alter table toto add ...
    Dimitri FontaineDimitri Fontaine
    Mar 14, 2012 at 2:11 pm
    Mar 16, 2012 at 2:20 pm
  • I have just found, after an hour or two of frustration, that pg_regress' --inputdir and --outputdir options don't play nicely with the convert_sourcefiles routines. In effect these options are ...
    Andrew DunstanAndrew Dunstan
    Mar 8, 2012 at 6:23 pm
    Mar 8, 2012 at 9:49 pm
  • Is there any way to get more info out of CLUSTER VERBOSE so it says what index it's working on AFTER the table re-write? INFO: clustering "public.values" using sequential scan and sort INFO: ...
    Larry RosenmanLarry Rosenman
    Mar 5, 2012 at 9:41 pm
    Mar 7, 2012 at 8:54 pm
  • I have a report related to pg_upgrade where the user states that dropping a PL language retains the PL support functions, and retains the dependency on the PL library, which causes pg_upgrade to ...
    Bruce MomjianBruce Momjian
    Mar 6, 2012 at 12:37 am
    Mar 6, 2012 at 9:48 pm
  • I've been playing around with "perf record" on the IBM POWER7 machine, and it's pretty cool. One of the things I don't like is that some of the tools don't produce very nice text reports that you can ...
    Robert HaasRobert Haas
    Mar 30, 2012 at 4:27 pm
    Mar 31, 2012 at 2:47 am
  • Hi, I have a hard time figuring out why my replication stopped with a message like FATAL: password authentication failed for user "foo" in the logs. I thought it was some pg_hba.conf change, a pgpass ...
    Euler TaveiraEuler Taveira
    Mar 14, 2012 at 2:22 pm
    Mar 22, 2012 at 6:09 am
Group Navigation
period‹ prev | Mar 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions128
posts1,921
users132
websitepostgresql.org...
irc#postgresql

132 users for March 2012

Robert Haas: 304 posts Tom Lane: 289 posts Simon Riggs: 87 posts Alvaro Herrera: 83 posts Dimitri Fontaine: 76 posts Bruce Momjian: 68 posts Peter Eisentraut: 64 posts Daniel Farina: 55 posts Pavel Stehule: 54 posts Andrew Dunstan: 47 posts Fujii Masao: 42 posts Kevin Grittner: 36 posts Noah Misch: 32 posts Thom Brown: 32 posts Heikki Linnakangas: 31 posts Andres Freund: 30 posts Peter Geoghegan: 30 posts Greg Stark: 28 posts Marko Kreen: 24 posts Magnus Hagander: 23 posts
show more
Archives