Search Discussions
-
I've finally wrapped my head around exactly what the max_standby_delay code is doing, and I'm not happy with it. The way that code is designed is that the setting represents a maximum allowed ...
Tom Lane
May 3, 2010 at 3:37 pm
May 14, 2010 at 10:20 pm -
Hi, I'm now designing the "synchronous" replication feature based on SR for 9.1, while discussing that at another thread. http://archives.postgresql.org/pgsql-hackers/2010-04/msg01516.php At the ...
Fujii Masao
May 24, 2010 at 1:21 pm
Sep 8, 2010 at 2:53 pm -
Patch adds a keepalive message to ensure max_standby_delay is useful. No WAL format changes, no libpq changes. Just an additional message type for the streaming replication protocol, sent once per ...
Simon Riggs
May 15, 2010 at 1:17 pm
Jul 3, 2010 at 8:18 pm -
In some systems (data warehousing, replication), the order of commits is important, since that is the order in which changes have become visible. This information could theoretically be extracted ...
Jan Wieck
May 23, 2010 at 8:23 pm
Aug 30, 2010 at 9:19 am -
It turns out that the SQL standard uses the function call notation foo(this AS that) for something else: <routine invocation ::= <routine name <SQL argument list <routine name ::= [ <schema name ...
Peter Eisentraut
May 26, 2010 at 8:44 pm
Jun 5, 2010 at 8:32 pm -
From a discussion at dinner at pgcon, I wanted to send this to the list for people to poke holes in it: Problem: currently, if your database has a large amount of "cold" data, such as 350GB of ...
Josh Berkus
May 21, 2010 at 9:57 pm
Jun 12, 2010 at 4:55 pm -
In yesterday's development meeting, we talked about the possibility of a basic SE-PostgreSQL implementation that checks permissions only for DML. Greg Smith offered the opinion that this could ...
Robert Haas
May 20, 2010 at 4:14 pm
Jul 22, 2010 at 1:19 am -
68
List traffic
Traffic on the PostgreSQL lists is very high now and I freely admit that reading every email is simply not possible for me, even the ones that mention topics that keyword searches tell me are of ...Simon Riggs
May 9, 2010 at 8:43 pm
May 28, 2010 at 9:23 pm -
Folks, I feel dumb. I have been looking for a document which specifies what trusted and untrusted PLs must do and forbid, so far without result. Where do we document this, and if we don't where ...
David Fetter
May 21, 2010 at 12:33 pm
May 30, 2010 at 2:24 am -
Hello attached patch contains to_string and to_array functions. These functions are equivalent of array_to_string and string_to_array function with maybe more correct NULL handling. postgres=# select ...
Pavel Stehule
May 5, 2010 at 6:42 pm
Aug 10, 2010 at 9:57 pm -
I can reproduce the behavior Stefan is seeing consistently using the attached patch. W1: postgres -D ~/pgslave W2: pg_ctl -D ~/pgslave stop -- Robert Haas EnterpriseDB: http://www.enterprisedb.com ...
Robert Haas
May 13, 2010 at 12:48 am
May 27, 2010 at 2:03 am -
39
pg_trgm
Hi, Anyone working on make contrib/pg_trgm mutibyte encoding aware? If not, I'm interested in the work. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: ...Tatsuo Ishii
May 27, 2010 at 3:08 am
May 30, 2010 at 5:51 pm -
Hi After the recent discussion about the impossibility of efficiently implementing FK-like constraint triggers in PL/PGSQL that work correctly under SERIALIZABLe transactions, I've compared our ...
Florian Pflug
May 13, 2010 at 9:25 pm
Aug 6, 2010 at 3:15 pm -
Andy Balholm wrote: You would basically move the functions and their prototypes to cash.c and cash.h, and then (instead of CREATE FUNCTION, etc.) add corresponding entries to pg_proc.h and ...
Kevin Grittner
May 30, 2010 at 1:54 pm
Jul 18, 2010 at 2:27 pm -
Someone just posted to the -admin list with a database corrupted while running with fsync=off. I was all set to refer him to the documentation explaining why he should stop doing this, but to my ...
Kevin Grittner
May 7, 2010 at 1:47 pm
May 31, 2010 at 3:53 pm -
hi, i mistakenly had posted this to pgsql-bugs already and got a response (see below - edited). i'm posting here since afaik it is the way i should be requesting new features. my suggestion is to add ...
Ben Hockey
May 18, 2010 at 10:26 pm
Dec 7, 2011 at 9:41 pm -
Hi. I am working on getting full-text-search to work and have come across something I think look a bit strange. The document base is arount 350.000 documents and I have set the statistics target on ...
Jesper Krogh
May 19, 2010 at 8:03 pm
Jun 1, 2010 at 4:51 am -
Hi. I'm trying to do a test move of one of our applications onto 9.0beta1. We use storable and serializes data into a bytea column in the database. This script uses that: #!/usr/bin/perl use strict; ...
Jesper Krogh
May 18, 2010 at 8:54 pm
May 19, 2010 at 5:57 pm -
Hi, we came across an interesting problem. =# create table parent (id serial primary key, t text); NOTICE: CREATE TABLE will create implicit sequence "parent_id_seq" for serial column "parent.id" ...
Boszormenyi Zoltan
May 6, 2010 at 8:52 am
May 18, 2010 at 10:21 am -
With the parameter checkpoint_segment and wal_keep_segments the max. number of wal segments are set. If now the max number is reached, (1) the segments are deleted/recycled or (2) if the time set by ...
Sander, Ingo (NSN - DE/Munich)
May 27, 2010 at 1:40 pm
Jul 21, 2010 at 3:25 am -
Assuming we want a release Postgres 9.0 by mid-August, here is how the timetable would look: Need RC release to be stable for 1-2 weeks before final RC must be released by August 1 Beta must be ...
Bruce Momjian
May 29, 2010 at 8:19 pm
May 31, 2010 at 4:24 pm -
Hi, I started to analyze XLogInsert because it was the major bottleneck when creating some materialized view/cached tables/whatever. Analyzing it I could see that content of the COMP_CRC32 macro was ...
Andres Freund
May 20, 2010 at 8:28 pm
Nov 3, 2010 at 8:10 am -
I noticed by accident that there are some cases where the planner fails to inline the SQL functions that underlie the || operator for text vs non-text cases. The reason is that these functions are ...
Tom Lane
May 16, 2010 at 1:52 am
May 29, 2010 at 9:11 pm -
First off, thank you for allowing me to participate in Google Summer of Code 2010. I'm sorry I haven't been active for the past few weeks. Today, I added the wiki page for my project, but the project ...
Joseph Adams
May 14, 2010 at 1:47 am
May 27, 2010 at 7:57 pm -
I have been thinking about this collation support business a bit. Ignoring for the moment where we would get the actual collation routines from, I wonder how we are going to pass this information ...
Peter Eisentraut
May 28, 2010 at 4:28 pm
Jun 3, 2010 at 3:46 pm -
While looking at the docs for pg_upgrade I noticed some stuff that the following patch attempts to at least partly address. There is quite some confusion going on between using "Postgres" and ...
Stefan Kaltenbrunner
May 19, 2010 at 8:17 pm
May 25, 2010 at 2:54 pm -
When firing up a properly shut down HS slave, I get: LOG: database system was interrupted while in recovery at log time 2010-05-12 20:35:24 EDT HINT: If this has occurred more than once some data ...
Robert Haas
May 13, 2010 at 1:01 am
Jun 5, 2010 at 2:05 am -
Suppose you have an object name as a CString and you want to convert it to an OID. The method of doing this varies widely depending on the object type: oid = get_database_oid(name); oid = ...
Robert Haas
May 23, 2010 at 4:50 am
May 26, 2010 at 7:03 pm -
FYI, I test pg_upgrade by loading the old cluster's regression database from a pg_dump output file, then after the upgrade, I dump the regression database of the new cluster and diff the changes. The ...
Bruce Momjian
May 16, 2010 at 2:23 am
May 18, 2010 at 3:30 am -
I read pg_upgrade code glance over, and found 4 issues in it. Are there any issues to be fixed before 9.0 release? 1. NAMEDATASIZE 2. extern PGDLLIMPORT 3. pathSeparator 4. EDB_NATIVE_LANG ==== 1. ...
Takahiro Itagaki
May 13, 2010 at 6:12 am
May 15, 2010 at 7:21 am -
Hi hackers, Although this is a very small change I figured I'd practice the policy of outlining your change before you write the code and attempt a patch submission. Essentially I see the function as ...
Mike Fowler
May 6, 2010 at 2:10 pm
Aug 8, 2010 at 7:18 pm -
Link to previous discussion: http://archives.postgresql.org/pgsql-hackers/2010-05/msg01195.php Attached, please find a patch which standardizes the following interface for object types that use ...
Robert Haas
May 27, 2010 at 2:52 am
Jul 6, 2010 at 1:25 pm -
The server's messages and the documentation uses all of these terms in mixed ways. Maybe we could decide on some preferred terminology and adjust the existing texts. Ideas?
Peter Eisentraut
May 12, 2010 at 4:34 pm
Jun 8, 2010 at 9:03 pm -
I notice that there are more than a few projects on pgfoundry that are marked as "BSD licence" but then the project files don't contain any mention of the licence details. In some cases, projects are ...
Simon Riggs
May 18, 2010 at 6:10 am
May 20, 2010 at 7:19 pm -
Hi, Can any one tell me whats the effect of the below Query SELECT substring(B'1111000000000001' from 5 for -2); SELECT substring(B'1111000000000001' from 4 for -3); its observed that there's an ...
Srinivas Naik
May 4, 2010 at 6:47 am
May 5, 2010 at 11:32 pm -
I've been reading the SQL/XML standard and discovered that it defines a function named XMLEXISTS that does exactly what the todo item xpath_exists defines. My original patch named the function as per ...
Mike Fowler
May 25, 2010 at 2:31 pm
Jun 1, 2010 at 4:06 pm -
Hi I just tried to checkout REL9_0_BETA1 from my local clone of the GIT repository at git.postgresql.org and discovered that none of the tags from CVS seem to exist in there. For alpha1 to alpha1 ...
Florian Pflug
May 12, 2010 at 6:28 pm
May 13, 2010 at 12:54 pm -
A look at the MSVC buildfarm members shows that they are not building most of the files added to contrib/pg_upgrade. The reason seems to be that that module tries to build both an executable program ...
Tom Lane
May 12, 2010 at 6:08 pm
May 12, 2010 at 11:56 pm -
It has been discussed several times in the past that there is no way for a client to authenticate a server over Unix-domain sockets. So depending on circumstances, a local user could easily insert ...
Peter Eisentraut
May 30, 2010 at 11:00 am
Jul 9, 2010 at 3:40 am -
Currently, the check for exclusion constraints performs a sanity check that's slightly too strict -- it assumes that a tuple will conflict with itself. That is not always the case: the operator might ...
Jeff Davis
May 21, 2010 at 7:11 pm
Jul 16, 2010 at 12:46 am -
Hi I tried running pg_upgrade from the current snapshot of postgresql and upgrading from 8.4.4 to the snapshot version. Everything seem to look fine in the process and all that came out was only ...
Jesper
May 18, 2010 at 1:12 pm
May 19, 2010 at 7:58 pm -
While preparing a replication test setup with 9.0beta1 I noticed strange page allocation patterns which Andrew Gierth found interesting enough to report here. I've written a simple tool to generate ...
Michael Renner
May 15, 2010 at 11:59 pm
Feb 17, 2011 at 3:23 am -
Hi, If a backend killed by pg_terminate_backend(), the backend returns 57P01 which is identical to the one when it's killed by postmaster. Problem is, pgpool-II needs to trigger failover if ...
Tatsuo Ishii
May 13, 2010 at 12:25 am
Jan 21, 2011 at 3:49 pm -
Hi, i migrate a ms sql server database to postgres and was trying some queries from the application to find if everything works right... when i was looking to those queries i found some that has a ...
Jaime Casanova
May 13, 2010 at 10:32 pm
Jul 3, 2010 at 2:38 pm -
In the original patch I had Pause/Resume feature for controlling recovery during Hot Standby. It was removed for lack of time. With all the discussion around the HS UI, it would be something that ...
Simon Riggs
May 4, 2010 at 8:14 am
May 6, 2010 at 8:04 am -
And.. it's way too big to send to the list. The patch is available here: http://snowman.net/~sfrost/psql-regress-help.patch Of course, if people want to suggest tests that just shouldn't be included, ...
Stephen Frost
May 25, 2010 at 2:51 am
May 30, 2010 at 12:38 am -
Greetings, Toying around with FETCH_COUNT today, I discovered that it didn't do the #1 thing I really wanted to use it for- query large tables without having to worry about LIMIT to see the first ...
Stephen Frost
May 14, 2010 at 3:41 pm
May 28, 2010 at 8:04 pm -
Hi, I saw this behavior with latest GIT head: create table xlarge(val numeric(19,0)); insert into xlarge values(generate_series(1,5)); The above generate series will return an int8 which will then be ...
Nikhil Sontakke
May 5, 2010 at 2:00 pm
May 8, 2010 at 4:54 pm -
Why do the release notes say this, under plperl: * PL/Perl subroutines are now given names (Tim Bunce) This is for the use of profiling and code coverage tools. DIDN'T THEY HAVE NAMES BEFORE? No they ...
Andrew Dunstan
May 17, 2010 at 3:27 pm
Jun 16, 2010 at 6:23 pm -
I'm thinking about exporting the raw parser and related modules as a C library. Though this will not be an immediate benefit of PostgreSQL itself, it will be a huge benefit for any PostgreSQL ...
Tatsuo Ishii
May 27, 2010 at 1:02 am
Jun 7, 2010 at 8:13 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 168 |
posts | 1,961 |
users | 129 |
website | postgresql.org... |
irc | #postgresql |
129 users for May 2010
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)