FAQ

PostgreSQL > pgsql-hackers > April 2011

Search Discussions

184 discussions - 1,834 posts

  • Hello, If I may, I want to share some concept to use mmap in PG. It's far, far away from perfect, but it's keeps WAL before data. As well I crated table, with index, inserted few values, and I done ...
    Radosław SmoguraRadosław Smogura
    Apr 15, 2011 at 10:33 am
    Oct 12, 2011 at 8:45 pm
  • So the topic of "real" "stored procedures" came up again. Meaning a function-like object that executes outside of a regular transaction, with the ability to start and stop SQL transactions itself. I ...
    Peter EisentrautPeter Eisentraut
    Apr 21, 2011 at 3:24 pm
    Sep 23, 2011 at 6:18 pm
  • The recent and wide-ranging "formatting curmudgeons" thread included suggestions by Tom and myself that we should consider branching the tree immediately after beta1. ...
    Robert HaasRobert Haas
    Apr 25, 2011 at 1:18 pm
    Oct 12, 2011 at 8:23 pm
  • Seeing that 9.1-to-9.1 pg_upgrade has apparently been broken for months, it would probably be good to have some kind of automatic testing for it. Attached is something I hacked together that at least ...
    Peter EisentrautPeter Eisentraut
    Apr 7, 2011 at 8:03 pm
    Dec 5, 2011 at 8:11 pm
  • While I was out at the MySQL conference last week, I heard that one of the forthcoming MySQL features is "time-delayed replication": http://forge.mysql.com/worklog/task.php?id=344 That is, a standby ...
    Robert HaasRobert Haas
    Apr 20, 2011 at 2:47 am
    Jul 2, 2011 at 12:32 pm
  • Composing my rather long-winded response to Simon got me thinking -- which just led me to realize there is probably a need to fix another thing related to SSI. For correct serializable behavior in ...
    Kevin GrittnerKevin Grittner
    Apr 27, 2011 at 8:17 pm
    Jun 8, 2011 at 2:46 pm
  • Hi, I read the discussion at http://archives.postgresql.org/pgsql-hackers/2011-01/msg00315.php From what I can understand, going from/to unlogged to/from logged in the wal_level == minimal case is ...
    Leonardo FrancalanciLeonardo Francalanci
    Apr 8, 2011 at 10:02 am
    Jun 3, 2011 at 4:05 pm
  • Hackers, I finally got round to updating a couple of my extensions to support 9.1 extensions. Unlike the contrib extensions, these needed to target older versions of PostgreSQL, as well. Case in ...
    David E. WheelerDavid E. Wheeler
    Apr 21, 2011 at 12:14 am
    May 17, 2011 at 4:51 pm
  • Hi, Today (and previously) I wished that pgbench had a mechanism to help create simple random databases. For example, I could create a table "tenk" and fill it with random stuff like \setrandom foo 1 ...
    Alvaro HerreraAlvaro Herrera
    Apr 18, 2011 at 9:03 pm
    Apr 23, 2011 at 3:11 pm
  • pgindent seems to have muffed it when it comes to BulkInsertStateData: diff --git a/src/backend/access/heap/hio.c b/src/backend/access/heap/hio.c index 2849992..72a69e5 100644 --- ...
    Robert HaasRobert Haas
    Apr 20, 2011 at 3:50 am
    Oct 12, 2011 at 8:54 pm
  • A recent complaint in pgsql-novice revealed that if you have say hostssl all all 127.0.0.1/32 md5 clientcert=1 in pg_hba.conf, but you forget to enable SSL in postgresql.conf, you get something like ...
    Tom LaneTom Lane
    Apr 25, 2011 at 4:52 pm
    May 30, 2011 at 8:37 pm
  • Hi, I have made very small modifications to a few files in the documentation directory, which involve SGML entity declarations. Currently they are all written lowercase, the patch makes them ...
    Gabriele BartoliniGabriele Bartolini
    Apr 4, 2011 at 9:12 am
    Apr 14, 2011 at 6:37 pm
  • Unlogged tables are a good new feature. I noticed Bruce had mentioned they were the equivalent of NoSQL, which I don't really accept. I guess it depends upon whether you mean NoSQL for caches (e.g. ...
    Simon RiggsSimon Riggs
    Apr 24, 2011 at 5:22 pm
    May 3, 2011 at 9:20 pm
  • A quick review of the open items list suggests that we have three main areas that need attention before we can declare ourselves ready for beta. In no particular order: 1. There are a bunch of small, ...
    Robert HaasRobert Haas
    Apr 6, 2011 at 1:21 pm
    Apr 25, 2011 at 11:34 pm
  • This week several list regulars here waded into the MySQL Convention. I decided to revisit PostgreSQL vs. MySQL performance using the sysbench program as part of that. It's not important to what I'm ...
    Greg SmithGreg Smith
    Apr 14, 2011 at 7:08 am
    Apr 15, 2011 at 9:33 pm
  • I just hit this, which at least violated my sense of least astonishment, if it's not an outright bug: After creating a role foo, I added to following lines to my (9.0) pg_hba.conf: local all +foo ...
    Andrew DunstanAndrew Dunstan
    Apr 6, 2011 at 11:04 pm
    Nov 3, 2011 at 1:42 am
  • I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in ...
    Dave PageDave Page
    Apr 27, 2011 at 6:49 pm
    Apr 30, 2011 at 7:56 pm
  • If you have the timezone configured to a non-default value in postgresql.conf, and you comment it out and reload, it says: LOG: parameter "TimeZone" removed from configuration file, reset to default ...
    Robert HaasRobert Haas
    Apr 7, 2011 at 4:11 am
    Sep 13, 2011 at 2:34 pm
  • The attached patch is intended to clean up a bunch of compiler warnings seen on Windows due to mismatches of signedness or constness, unused variables, redefined macros and a missing prototype. It ...
    Andrew DunstanAndrew Dunstan
    Apr 24, 2011 at 5:29 am
    Jul 31, 2011 at 11:28 pm
  • I'm getting JDBC exceptions when I try to connect to 9.1 (master) with the postgresql-9.0-801.jdbc3.jar I don't have this issue with 9.0. There is nothing obvious at http://jdbc.postgresql.org or in ...
    Steve SingerSteve Singer
    Apr 18, 2011 at 1:32 pm
    Apr 19, 2011 at 4:32 pm
  • Daniel Farina points out to me that the Linux man page for fsync() says "Calling fsync() does not necessarily ensure that the entry in the directory containing the file has also reached disk. For ...
    Simon RiggsSimon Riggs
    Apr 21, 2011 at 8:26 am
    May 9, 2011 at 7:01 pm
  • I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR UPDATE or wait while they will ...
    Vlad ArkhipovVlad Arkhipov
    Apr 27, 2011 at 8:35 am
    May 4, 2011 at 9:05 pm
  • We sometimes transform IN-clauses to a list of ORs: postgres=# explain SELECT * FROM foo WHERE a IN (b, c); QUERY PLAN ------------------------------------------------------ Seq Scan on foo ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 1, 2011 at 11:25 am
    Sep 6, 2011 at 5:58 pm
  • Hackers, I'm currently looking at a database which has some extreme bloating of intarray GiST indexes. As in 1000% bloating in only a few months. This is not a particularly high-transaction-rate ...
    Josh BerkusJosh Berkus
    Apr 28, 2011 at 7:11 pm
    May 4, 2011 at 6:50 pm
  • Over at http://archives.postgresql.org/pgsql-novice/2011-04/msg00102.php there's an interesting thread about a novice who forgot to put a semicolon at the end of his SQL commands, and what psql might ...
    Tom LaneTom Lane
    Apr 29, 2011 at 3:10 pm
    May 1, 2011 at 7:18 pm
  • All or almost all the warnings seen on Windows/Mingw of the type "warning: unknown conversion type character 'm' in format" come from checking of three functions: errmsg, elog and errdetail. I ...
    Andrew DunstanAndrew Dunstan
    Apr 27, 2011 at 4:11 am
    Apr 29, 2011 at 8:19 am
  • Asynchronous functions *Problem* Postgresql does not have support for asynchronous function calls. *Solution* An asynchronous function would allow a user to call a function and have it return ...
    Sim ZacksSim Zacks
    Apr 26, 2011 at 7:30 am
    Apr 28, 2011 at 4:20 am
  • While looking at the typed table/pg_upgrade problem, I ran into a few smaller problems in the area. I'm not envisioning a need for much code shift to fix them, but there are a few points of policy. * ...
    Noah MischNoah Misch
    Apr 10, 2011 at 1:57 am
    Apr 21, 2011 at 3:08 pm
  • Hi guys, I have noticed that during VACUUM FULL on reasonably big tables, replication lag climbs. In order to smooth down the replication lag, I propose the attached patch which enables vacuum delay ...
    Gabriele BartoliniGabriele Bartolini
    Apr 30, 2011 at 6:21 pm
    May 9, 2011 at 11:20 am
  • I use tables all the time that have sequences on smallint's; I'd like to simplify my create files by not having to create the sequence first, but I also don't want to give up those 2 bytes per ...
    Mike PultzMike Pultz
    Apr 21, 2011 at 1:34 am
    Jun 22, 2011 at 3:35 pm
  • The attached patch merges synchronous_replication into synchronous_commit. With the patch, valid values of synchronous_commit are "on" (waits for local flush and sync rep), "off" (waits for neither ...
    Fujii MasaoFujii Masao
    Apr 4, 2011 at 8:54 am
    Apr 5, 2011 at 6:51 pm
  • Folks, I think it might be about time to start thinking concretely about when we might like to kick beta1 out the door. The open issues list still has 9 issues on it, but we now have patches awaiting ...
    Robert HaasRobert Haas
    Apr 4, 2011 at 2:52 pm
    Apr 5, 2011 at 2:32 pm
  • This seems like a place where there is room for improvement. 2011-04-09 15:18:08.016 testdb=# select id from test1 where id < 3 order by id; id ---- 1 2 (2 rows) Time: 0.328 ms 2011-04-09 ...
    Jesper KroghJesper Krogh
    Apr 9, 2011 at 1:22 pm
    Apr 18, 2011 at 10:13 pm
  • So, we talked about running pgindent a few weeks ago, but reading over the thread, I guess we're still waiting for Andrew to update the list of typedefs? It would be really nice to get this done. ...
    Robert HaasRobert Haas
    Apr 8, 2011 at 10:05 pm
    Apr 10, 2011 at 4:34 pm
  • I looked into David Johnston's report of curious planner behavior: http://archives.postgresql.org/pgsql-general/2011-04/msg00885.php What is happening is that the planner doesn't reliably see the ...
    Tom LaneTom Lane
    Apr 26, 2011 at 11:23 pm
    May 24, 2011 at 6:40 pm
  • Now that Dan has finished the comparative performance tests, and the version with SSI sometimes tests faster, sometimes slower, with the difference always a fraction of a percent even on a fairly ...
    Kevin GrittnerKevin Grittner
    Apr 23, 2011 at 1:54 pm
    May 7, 2011 at 1:55 am
  • The current structure of .pgpass is: hostname:port:database:username:password Bare, useful, but not really friendly nor flexible. I would love to be able to do this: If no ini block: ...
    Joshua D. DrakeJoshua D. Drake
    Apr 5, 2011 at 10:35 pm
    Apr 7, 2011 at 11:29 am
  • Hackers, I wanted to get a (ok, not so) quick note in about this before the beta dropped. I've been thinking about the "requires" parameter on extensions control files. Right now it just lists the ...
    David E. WheelerDavid E. Wheeler
    Apr 1, 2011 at 3:46 pm
    Apr 5, 2011 at 10:51 pm
  • I came across this today, while helping a customer. The following will happily create a piece of XML with an embedded ^A: select xmlelement(name foo, null, E'abc\x01def'); Now, a ^A is totally ...
    Andrew DunstanAndrew Dunstan
    Apr 25, 2011 at 11:25 pm
    May 11, 2011 at 11:39 pm
  • Hello Actually we had to solve a issue with slow SELECT. The problem was in low value of JOIN_COLLAPSE_LIMITS. Can we increase a default of this value. I checked some complex query, and planner ...
    Pavel StehulePavel Stehule
    Apr 30, 2011 at 4:17 pm
    May 6, 2011 at 4:42 pm
  • Hi, In the thread http://archives.postgresql.org/message-id/4DA69D60.4000108@2ndquadrant.com / "Single client performance on trivial SELECTs" I wondered whether it might be possible to increase the ...
    Andres FreundAndres Freund
    Apr 25, 2011 at 9:45 pm
    Apr 26, 2011 at 8:43 pm
  • Hi, Suppose I create a table as follows: CREATE TABLE test2 (name TEXT, age INTEGER) WITH oids; Now, for every tuple in this table is associated with a unique oid, which I can retrieve by: SELECT ...
    JaganJagan
    Apr 11, 2011 at 8:42 pm
    Apr 15, 2011 at 10:45 pm
  • I was poking around in the allocator code out of curiosity after reading the thread 'Improving the memory allocator', and noticed the following in spell.c: /* * "Compact" palloc: allocate without ...
    Merlin MoncureMerlin Moncure
    Apr 26, 2011 at 1:43 pm
    May 2, 2011 at 8:02 pm
  • I noticed again that make check in contrib doesn't work, so here is a patch to fix it. Perhaps someone wants to fill in the Windows support for it. Naturally, this works only for contrib itself, not ...
    Peter EisentrautPeter Eisentraut
    Apr 24, 2011 at 11:18 pm
    Apr 25, 2011 at 5:52 pm
  • Hello List, We are getting the following log while configuring hot standby, 2011-04-20 17:34:40 ETC/GMT FATAL: the database system is starting up 2011-04-20 17:34:41 ETC/GMT FATAL: database system ...
    RajibdkRajibdk
    Apr 20, 2011 at 1:28 pm
    Apr 22, 2011 at 4:13 pm
  • As for apostrophes, isn't the cause that initdb loses the single quote of locale? ([BUGS] BUG #5818: initdb lose the single quote of locale) As the bug reporter mentions, initdb loses the single ...
    Hiroshi InoueHiroshi Inoue
    Apr 19, 2011 at 11:59 pm
    Apr 20, 2011 at 9:40 pm
  • Hi All, I was wondering if anyone can tell me how i can access the transaction log within postgresql 9.0.3. I have carried out some updated and deletions within the database and am hoping the ...
    AaronenabsAaronenabs
    Apr 6, 2011 at 1:25 am
    Apr 6, 2011 at 7:52 pm
  • Dear pgsql-hackers, My name is Sivasankar Ramasubramanian (you can call me Shiv). I am one of the students taking part in this years Google Summer of Code program. I am Indian but I study and live in ...
    ShivShiv
    Apr 27, 2011 at 6:21 am
    May 10, 2011 at 2:52 pm
  • Hackers! I was happy to know that my proposal "Fast GiST index build" was accepted to GSoC 2011! Thank you very much for support! Especially thanks to Heikki Linnakangas for becoming my mentor! The ...
    Alexander KorotkovAlexander Korotkov
    Apr 25, 2011 at 8:10 pm
    May 6, 2011 at 9:05 am
  • Last week we fixed a problem in which REINDEX could corrupt pg_index's own indexes by forbidding it from setting indcheckxmin on a system catalog's index. While thinking about bug #5985 I realized ...
    Tom LaneTom Lane
    Apr 19, 2011 at 3:37 pm
    Apr 20, 2011 at 4:03 pm
Apr 2011
1234
Group Navigation
period‹ prev | Apr 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions184
posts1,834
users156
websitepostgresql.org...
irc#postgresql

156 users for April 2011

Tom Lane: 286 posts Robert Haas: 244 posts Andrew Dunstan: 102 posts Peter Eisentraut: 89 posts Bruce Momjian: 82 posts Kevin Grittner: 71 posts Joshua Berkus: 56 posts Alvaro Herrera: 53 posts Merlin Moncure: 43 posts Noah Misch: 42 posts Heikki Linnakangas: 40 posts Greg Stark: 36 posts David E. Wheeler: 28 posts Greg Smith: 26 posts Andres Freund: 25 posts Magnus Hagander: 25 posts Simon Riggs: 24 posts Pavel Stehule: 20 posts Joshua D. Drake: 19 posts Yves Weißig: 18 posts
show more
Archives