Search Discussions

99 discussions - 1,347 posts

  • After the various recent discussions on list, I present what I believe to be a working patch implementing 16-but checksums on all buffer pages. page_checksums = on | off (default) There are no ...
    Simon RiggsSimon Riggs
    Dec 24, 2011 at 12:19 pm
    Aug 10, 2012 at 11:16 pm
  • Where are we with adding JSON for Postgres 9.2? We got bogged down in the data representation last time we discussed this. -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    Dec 5, 2011 at 8:12 pm
    Apr 16, 2012 at 4:41 pm
  • Hi, A while ago when blogging about WAL [1], I noticed a function to deal with xlog location arithmetic is wanted. I remembered Depez [2] mentioning it and after some questions during trainings and ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Dec 6, 2011 at 4:22 am
    Apr 14, 2012 at 12:08 pm
  • I've been looking at various ways to make WALInsertLock less of a bottleneck on multi-CPU servers. The key is going to be to separate the two things that are done while holding the WALInsertLock: a) ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 15, 2011 at 1:51 pm
    Mar 22, 2012 at 1:32 am
  • Folks, What: Please find attached a patch for 9.2-to-be which implements page checksums. It changes the page format, so it's an initdb-forcing change. How: In order to ensure that the checksum ...
    David FetterDavid Fetter
    Dec 17, 2011 at 9:33 pm
    Jan 24, 2012 at 5:31 pm
  • I'll try and keep this terse. I've promised to justify the number of specialisations that are in my fast-path sorting patch, and I may yet conclude that a reduction is appropriate. Not today though - ...
    Peter GeogheganPeter Geoghegan
    Dec 30, 2011 at 2:03 am
    Feb 16, 2012 at 12:03 am
  • Hi, The extensions work we began in 9.1 is not yet finished entirely (*cough*), so I'm opening a new patch series here by attacking the dependency problems. Some people want us to manage extension ...
    Dimitri FontaineDimitri Fontaine
    Dec 18, 2011 at 2:36 pm
    Apr 5, 2012 at 4:59 pm
  • A few weeks ago I posted some performance results showing that increasing NUM_CLOG_BUFFERS was improving pgbench performance. http://archives.postgresql.org/pgsql-hackers/2011-12/msg00095.php I spent ...
    Robert HaasRobert Haas
    Dec 21, 2011 at 4:52 am
    Jan 28, 2012 at 9:23 pm
  • Folks, One of the things VMware is working on is double writes, per previous discussions of how, for example, InnoDB does things. I'd initially thought that introducing just one of the features in ...
    David FetterDavid Fetter
    Dec 21, 2011 at 9:59 pm
    Jan 5, 2012 at 3:05 pm
  • Hello Hackers, Attached is a work-in-progress patch for URI connection string syntax support in libpq. The recent discussion (also pointing to the original one) is here: ...
    Alexander ShulginAlexander Shulgin
    Dec 12, 2011 at 10:06 pm
    Mar 7, 2012 at 9:54 pm
  • Hi all, I’m new here so maybe someone else already has this in the works ? Anyway, proposed change/patch : Add a new parameter : synchronous_standalone_master = on | off To control whether a master ...
    Alexander BjörnhagenAlexander Björnhagen
    Dec 25, 2011 at 8:08 pm
    Aug 26, 2012 at 3:26 am
  • Hello this patch adds a bytea_agg aggregation. It allow fast bytea concatetation. Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Dec 21, 2011 at 10:05 am
    Apr 11, 2012 at 5:57 pm
  • Hi, I am having a scenario where I get consistent warnings in the pglog folder: 2011-12-11 00:00:03 JST WARNING: pgstat wait timeout 2011-12-11 00:00:14 JST WARNING: pgstat wait timeout 2011-12-11 ...
    Dec 15, 2011 at 4:56 pm
    Jan 31, 2012 at 9:10 am
  • Over in the "add timing of buffer I/O requests" thread I mentioned having a system where EXPLAIN ANALYZE of a modest COUNT(*) takes 10X as long as just executing the statement. Attached is a bit of ...
    Greg SmithGreg Smith
    Dec 7, 2011 at 2:58 am
    Aug 28, 2012 at 4:59 pm
  • 2011/12/30 Tom Lane <tgl@sss.pgh.pa.us I'm a bit confused and might miss the point, but... If we can decide whether to use the hint operand when we build postgres, I think it's better to check if we ...
    Manabu OriManabu Ori
    Dec 30, 2011 at 5:47 am
    Jan 5, 2012 at 12:41 pm
  • The check_postgres txn_wraparound action[0] runs this query: SELECT datname, age(datfrozenxid) AS age FROM pg_database WHERE datallowconn ORDER BY 1, 2 On a hot standby, this fails with: ERROR: ...
    Peter EisentrautPeter Eisentraut
    Dec 28, 2011 at 6:04 pm
    May 9, 2012 at 4:14 pm
  • A client has again raised with me the ugliness of "pretty printed" viewdefs. We looked at this a couple of years ago, but discussion went off into the weeds slightly, so I dropped it, but as ...
    Andrew DunstanAndrew Dunstan
    Dec 19, 2011 at 6:52 pm
    Jan 16, 2012 at 3:44 pm
  • Hi guys, I have added the '-n' option to pg_archivecleanup which performs a dry-run and outputs the names of the files to be removed to stdout (making possible to pass the list via pipe to another ...
    Gabriele BartoliniGabriele Bartolini
    Dec 11, 2011 at 2:52 pm
    Feb 6, 2012 at 3:10 pm
  • Dear Hackers, I have written some notes about autonomous subtransactions, which have already been touched (at least) in two separate threads; please find them at ...
    Gianni CiolliGianni Ciolli
    Dec 18, 2011 at 8:28 am
    Jan 22, 2012 at 11:17 pm
  • AFAIK, we don't. What you can do is take the db offline, change the symlink, start it up agin and manually change pg_tablespace.spclocation. That seems quite ugly though. And if you forget one step, ...
    Magnus HaganderMagnus Hagander
    Dec 4, 2011 at 4:22 pm
    Dec 7, 2011 at 9:39 am
  • The patch is in context format, includes docs and additional regression tests, applies cleanly, passes "world" regression tests. The parser changes don't cause any "backing up". Discussion on the ...
    Kevin GrittnerKevin Grittner
    Dec 3, 2011 at 8:53 pm
    Dec 14, 2011 at 1:59 pm
  • Recently I attempted to build an external package (pg_bulkload) against the latest Fedora packages. Unfortunately this fails, as pgxs adds "-lpgport" to any link line for an executable, and the ...
    Andrew DunstanAndrew Dunstan
    Dec 9, 2011 at 4:13 pm
    Dec 13, 2011 at 9:29 pm
  • Hello I have a relative simple query SELECT q.object_id FROM queue q JOIN outgoing.cps_forms f ON f.id = q.object_id AND q.object_type = 'cp' JOIN flat_file_ex fe ON fe.id = q.rejected_flat_file_id ...
    Pavel StehulePavel Stehule
    Dec 4, 2011 at 7:41 am
    Dec 5, 2011 at 7:30 pm
  • Hello everybody, this patch adds two counters to pg_stat_database to track temporary files - number of temp files and number of bytes. I see this as a useful feature, as temporary files often cause a ...
    Tomas VondraTomas Vondra
    Dec 20, 2011 at 1:00 am
    Jan 26, 2012 at 1:54 pm
  • Hi all, most of the time I use auto_explain, all I need is duration of the query and the plan with estimates and actual row counts. And it would be handy to be able to catch long running queries with ...
    Tomas VondraTomas Vondra
    Dec 23, 2011 at 12:37 am
    Dec 24, 2011 at 5:32 am
  • archive_command and restore_command describe how to ship WAL files to/from an archive. When there is nothing to ship, we delay sending WAL files. When no WAL files, the standby has no information at ...
    Simon RiggsSimon Riggs
    Dec 16, 2011 at 3:01 pm
    Aug 27, 2012 at 8:40 pm
  • Hi, I've written a simple extension that limits number of connection by IP/db/user, and I do receive this exception: psql: FATAL: cannot read pg_class without having selected a database I've found ...
    Tomas VondraTomas Vondra
    Dec 3, 2011 at 10:33 pm
    Dec 5, 2011 at 3:58 pm
  • Hi, I've revived the old moribund / bitrotten OpenOffice driver for PostgreSQL (originally at http://dba.openoffice.org/drivers/postgresql/index.html). As you may already know, OpenOffice was forked ...
    Lionel Elie MamaneLionel Elie Mamane
    Dec 13, 2011 at 10:15 am
    Dec 16, 2011 at 8:37 am
  • Attached is a patch that addresses the todo item "Improve relation size functions such as pg_relation_size() to avoid producing an error when called against a no longer visible relation." ...
    Phil SorberPhil Sorber
    Dec 17, 2011 at 8:52 pm
    Jan 19, 2012 at 11:19 am
  • Compare: int PQntuples(const PGresult *res) Reasonable: doesn't modify 'res'. With: char *PQcmdStatus(PGresult *res); char *PQcmdTuples(PGresult *res); Unreasonable: a. What, these two can modify ...
    Alex GoncharovAlex Goncharov
    Dec 13, 2011 at 12:56 pm
    Jan 15, 2012 at 7:52 pm
  • Hi, I've been trying to implement the holy grail of decoupling logical/physical column sort order representation, i.e., the feature that lets the server have one physical order, for storage ...
    Alvaro HerreraAlvaro Herrera
    Dec 20, 2011 at 8:53 pm
    Dec 27, 2011 at 8:04 pm
  • If you add this Assert to lock.c: diff --git a/src/backend/storage/lmgr/lock.c b/src/backend/storage/lmgr/lock.c index 3ba4671..d9c15e0 100644 *** a/src/backend/storage/lmgr/lock.c --- ...
    Tom LaneTom Lane
    Dec 14, 2011 at 4:15 am
    Dec 15, 2011 at 2:48 pm
  • Back in 2007 (commit a8d539f12498de52453c8113892cbf48cc62478d), we reduced the maximum number of backup blocks per WAL record from 4 to 3, in order to permit addition of an XLR_BKP_REMOVABLE flag bit ...
    Tom LaneTom Lane
    Dec 12, 2011 at 3:17 pm
    Dec 13, 2011 at 12:27 am
  • Hello I am trying to create simple extension according to doc http://www.postgresql.org/docs/9.1/interactive/extend-extensions.html I have a problem with line that contains backslash statement -- ...
    Pavel StehulePavel Stehule
    Dec 7, 2011 at 12:28 pm
    Dec 8, 2011 at 5:08 am
  • We're either pretty inconsistent with our output in psql, or I'm not completely understanding it.. I was trying to implement a switch that would let me put all the output in the query output channel ...
    Magnus HaganderMagnus Hagander
    Dec 12, 2011 at 1:48 pm
    Aug 26, 2012 at 2:59 am
  • These days we have pause_at_recovery_target, which lets us pause when we reach a PITR target. Is there a particular reason we don't have a way to pause at end of recovery if we *didn't* specify a ...
    Magnus HaganderMagnus Hagander
    Dec 20, 2011 at 1:40 pm
    Jan 26, 2012 at 5:42 pm
  • Hello, I tried to generalize a function that creates partitions for a table and found out it's impossible to do it for grants. Basically, what I want is a child table that takes it's grants from ...
    Marko KreenMarko Kreen
    Dec 29, 2011 at 6:05 pm
    Jan 4, 2012 at 6:30 pm
  • I recently upgraded my postgres server from 9.0 to 9.1.2 and I am finding a peculiar problem.I have a program that periodically adds rows to this table using INSERT. Typically the number of rows is ...
    Sushant SinhaSushant Sinha
    Dec 19, 2011 at 3:31 pm
    Dec 19, 2011 at 8:50 pm
  • Hi, why the libraries loaded using local_preload_libraries need to be placed in a different subdirectory than libraries loaded using shared_preload_libraries? And why it does not use ...
    Tomas VondraTomas Vondra
    Dec 3, 2011 at 2:57 pm
    Dec 5, 2011 at 11:25 pm
  • All, I have a large PG 9.1.1 server (over 1TB of data) and replica using log shipping. I had some hardware issues on the replica system and now I am getting the following in my pg_log/* files. Same 2 ...
    Jim ButtafuocoJim Buttafuoco
    Dec 1, 2011 at 6:41 pm
    Dec 1, 2011 at 10:54 pm
  • It's not a big thing, but I just found myself in a shared environment wanting to be able to set alternative locations for the psql startup file and history. I know there's the HISTFILE variable, but ...
    Andrew DunstanAndrew Dunstan
    Dec 31, 2011 at 3:52 pm
    Aug 27, 2012 at 2:21 am
  • Hi list, Back in June we had a discussion about parsing denormal floating-point values. A float8- text conversion could result in a number that can't be converted back to float8 anymore for some ...
    Marti RaudseppMarti Raudsepp
    Dec 21, 2011 at 4:21 pm
    Feb 3, 2012 at 9:06 am
  • It would not take very much at all to make the SP-GiST stuff support index-only scans, except for one thing: it's conceivable that an opclass might choose to store only a lossy version of the ...
    Tom LaneTom Lane
    Dec 14, 2011 at 6:01 pm
    Jan 8, 2012 at 10:09 pm
  • Hi all, I mean to create a typed hstore, called tstore for now. I'm open to name suggestions. It'll only support a subset of core Postgres types to begin with. Keys are always text, it's the value ...
    Johann 'Myrkraverk' OskarssonJohann 'Myrkraverk' Oskarsson
    Dec 22, 2011 at 1:33 am
    Dec 22, 2011 at 10:45 pm
  • According to the docs [1], you should escape embedded colons in .pgpass (fair enough). Below is PG 9.1.1 user = "te:st", db = "te:st", password = "te:st" $ cat ~/.pgpass *:*:te:st:te:st:te:st $ ...
    Richard HuxtonRichard Huxton
    Dec 16, 2011 at 2:55 pm
    Dec 22, 2011 at 7:36 pm
  • Is there any reason why the setting synchronize_seqscans is in the section "version/platform compatibility" in postgresql.conf? Is it just because nobody could find a better place for it? ;) It seems ...
    Magnus HaganderMagnus Hagander
    Dec 20, 2011 at 1:36 pm
    Dec 20, 2011 at 3:33 pm
  • Hi, I've used LISTEN/NOTIFY in a few apps with great success (both the new and the old implementation) but I've found myself wondering why I couldn't use a richer payload, and wondered if anyone ...
    Thomas MunroThomas Munro
    Dec 13, 2011 at 11:30 pm
    Dec 14, 2011 at 4:11 pm
  • Hi list, As discussed on the pgsql-general list, the bool_and() and bool_or() aggregate functions behave exactly like min() and max() would over booleans. While it's not likely that people would have ...
    Marti RaudseppMarti Raudsepp
    Dec 19, 2011 at 10:17 am
    Feb 8, 2012 at 9:13 pm
  • Hackers, For better GiST indexing of range types it's important to have real-life datasets for testing on. Real-life range datasets would help to proof (or reject) some concepts and get more ...
    Alexander KorotkovAlexander Korotkov
    Dec 20, 2011 at 12:50 pm
    Jan 11, 2012 at 2:16 am
  • Hi all, When SELECTing from one particular view, I get reproducible SEGFAULTs in my pg 9.1.2 production database. To test for hardware errors, I ran memtest, which succeeded. I then asked for help in ...
    Chris r.Chris r.
    Dec 29, 2011 at 10:43 pm
    Jan 4, 2012 at 1:38 am
Group Navigation
period‹ prev | Dec 2011 | next ›
Group Overview
grouppgsql-hackers @

122 users for December 2011

Robert Haas: 174 posts Tom Lane: 159 posts Greg Smith: 71 posts Simon Riggs: 64 posts Andrew Dunstan: 57 posts Pavel Stehule: 57 posts Magnus Hagander: 48 posts Alvaro Herrera: 47 posts Peter Eisentraut: 44 posts Heikki Linnakangas: 39 posts Kevin Grittner: 37 posts Dimitri Fontaine: 31 posts Andres Freund: 30 posts Marti Raudsepp: 26 posts Noah Misch: 26 posts Tomas Vondra: 19 posts Merlin Moncure: 18 posts Peter Geoghegan: 18 posts Bruce Momjian: 17 posts Albe Laurenz: 12 posts
show more