FAQ

PostgreSQL > pgsql-hackers > May 2010

Search Discussions

168 discussions - 1,961 posts

  • 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 LaneTom 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 MasaoFujii 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 RiggsSimon 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 WieckJan 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 EisentrautPeter 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 BerkusJosh 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 HaasRobert Haas
    May 20, 2010 at 4:14 pm
    Jul 22, 2010 at 1:19 am
  • 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 RiggsSimon 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 FetterDavid 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 StehulePavel 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 HaasRobert Haas
    May 13, 2010 at 12:48 am
    May 27, 2010 at 2:03 am
  • 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 IshiiTatsuo 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 PflugFlorian 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 GrittnerKevin 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 GrittnerKevin 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 HockeyBen 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 KroghJesper 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 KroghJesper 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 ZoltanBoszormenyi 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)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 MomjianBruce 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 FreundAndres 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 LaneTom 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 AdamsJoseph 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 EisentrautPeter 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 KaltenbrunnerStefan 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 HaasRobert 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 HaasRobert 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 MomjianBruce 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 ItagakiTakahiro 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 FowlerMike 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 HaasRobert 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 EisentrautPeter 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 RiggsSimon 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 NaikSrinivas 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 FowlerMike 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 PflugFlorian 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 LaneTom 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 EisentrautPeter 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 DavisJeff 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 ...
    JesperJesper
    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 RennerMichael 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 IshiiTatsuo 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 CasanovaJaime 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 RiggsSimon 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 FrostStephen 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 FrostStephen 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 SontakkeNikhil 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 DunstanAndrew 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 IshiiTatsuo Ishii
    May 27, 2010 at 1:02 am
    Jun 7, 2010 at 8:13 am
May 2010
1234
Group Navigation
period‹ prev | May 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions168
posts1,961
users129
websitepostgresql.org...
irc#postgresql

129 users for May 2010

Tom Lane: 266 posts Robert Haas: 247 posts Simon Riggs: 161 posts Bruce Momjian: 150 posts Heikki Linnakangas: 78 posts Fujii Masao: 68 posts Andrew Dunstan: 63 posts Stephen Frost: 52 posts Kevin Grittner: 49 posts Josh Berkus: 48 posts Florian Pflug: 40 posts Peter Eisentraut: 39 posts Jan Wieck: 34 posts Pavel Stehule: 33 posts Greg Stark: 31 posts Magnus Hagander: 28 posts Marc G. Fournier: 28 posts Tatsuo Ishii: 25 posts Alvaro Herrera: 24 posts Dimitri Fontaine: 22 posts
show more
Archives