Search Discussions
-
174
MMAP Buffers
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 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 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 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 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 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 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 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. 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 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 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 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 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 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 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 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 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 Page
Apr 27, 2011 at 6:49 pm
Apr 30, 2011 at 7:56 pm -
22
timezone GUC
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Krogh
Apr 9, 2011 at 1:22 pm
Apr 18, 2011 at 10:13 pm -
14
pgindent
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 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 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 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. 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. 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 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 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 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 ...
Jagan
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 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 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 ...
Rajibdk
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 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 ...
Aaronenabs
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 ...
Shiv
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 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 Lane
Apr 19, 2011 at 3:37 pm
Apr 20, 2011 at 4:03 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 184 |
posts | 1,834 |
users | 156 |
website | postgresql.org... |
irc | #postgresql |
156 users for April 2011
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)