FAQ

PostgreSQL > pgsql-hackers > September 2010

Search Discussions

155 discussions - 2,173 posts

  • Attached is a small patch that adds a few comments for the settings that require restart. Applicable for 9.0+. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer ...
    Devrim GündüzDevrim Gündüz
    Sep 27, 2010 at 8:58 am
    Oct 14, 2010 at 5:18 pm
  • I just discovered the --patience flag on the git diff command, and I'd like to suggest that we encourage people to use it when possible for building patches. I just looked at output with and without ...
    Kevin GrittnerKevin Grittner
    Sep 15, 2010 at 5:58 pm
    Oct 1, 2010 at 9:53 pm
  • Can we please change the comment lines below the patch heading to have the real name instead of the postgresql.org ID? Patch by Pavel Stehule Patch by Gurjeet Singh instead of Patch by okbobcz Patch ...
    Gurjeet SinghGurjeet Singh
    Sep 30, 2010 at 9:38 pm
    Oct 1, 2010 at 6:06 pm
  • ... or did we just forget to remove it? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com
    Josh BerkusJosh Berkus
    Sep 21, 2010 at 1:19 am
    Sep 22, 2010 at 4:17 pm
  • Hi, http://archives.postgresql.org/pgsql-hackers/2010-05/msg00921.php Let's revisit this issue. The problem here is that pg_ctl might emit the following warning messages when it shuts down the ...
    Fujii MasaoFujii Masao
    Sep 13, 2010 at 10:08 am
    Sep 14, 2010 at 2:58 pm
  • This is an attempt to sum up the open issues remaining before we can make another try at converting our source code to git. * As I noted previously, up till about 2003 we were quite haphazard about ...
    Tom LaneTom Lane
    Sep 13, 2010 at 4:32 pm
    Sep 13, 2010 at 6:41 pm
  • I'm not subscribed to pgsql-committers, but apparently under the new git-enabled setup, I'm getting a "Stalled post to pgsql-committers" message for every commit. Fix that please.
    Peter EisentrautPeter Eisentraut
    Sep 25, 2010 at 4:43 pm
    Sep 29, 2010 at 7:16 pm
  • [moving to pgsql-hackers; this isn't the simple bug I initially suspected it might be] I think you're right. Looking into it more, though, I'm not even sure what the correct behaviour even is. I ...
    Craig RingerCraig Ringer
    Sep 22, 2010 at 8:25 am
    Sep 25, 2010 at 6:49 am
  • It's not hard to tell if we're missing a file that ought to be listed in .gitignore --- git status will find that problem soon enough. However, it seems that git isn't so willing to tell you about ...
    Tom LaneTom Lane
    Sep 23, 2010 at 12:54 am
    Sep 24, 2010 at 4:26 pm
  • Alpha1 has been bundled and is available at http://developer.postgresql.org/~petere/alpha/ Please check that it is sane. If there are no concerns, I will move them to the FTP site tomorrow (Sunday) ...
    Peter EisentrautPeter Eisentraut
    Sep 4, 2010 at 5:27 pm
    Sep 6, 2010 at 10:08 pm
  • All, While working on some database maintenance, I was just tripped up by the fact that there is no good way to query reloptions for tables. By "no good way" I mean "no way which does not involve ...
    Josh BerkusJosh Berkus
    Sep 27, 2010 at 5:19 am
    Feb 26, 2011 at 5:49 pm
  • In http://www.postgresql.org/docs/9.0/static/tutorial-window.html it say "Although avg will produce the same result no matter what order it processes the partition's rows in, this is not true of all ...
    Dennis BjörklundDennis Björklund
    Sep 22, 2010 at 10:35 am
    Feb 20, 2011 at 5:02 am
  • Hi, When I using an index scan, can I get the offset of the tuple in the table? Thanks -- Pei
    Pei HePei He
    Sep 21, 2010 at 9:03 pm
    Sep 22, 2010 at 10:31 am
  • There are a couple of weird-looking commits way back near the beginning of the converted Postgres history: commit 91f2ac21a1e085dfe81aae110cee2246a803f600 refs/tags/Release_2_0_0 Author: PostgreSQL ...
    Tom LaneTom Lane
    Sep 12, 2010 at 4:02 pm
    Sep 13, 2010 at 3:52 pm
  • I have implemented your suggestion of setting LANG, LANGUAGE, and LC_MESSAGES based on code in pg_regress.c; that is the only place I see where we force English, and it certainly has received more ...
    Bruce MomjianBruce Momjian
    Sep 1, 2010 at 8:35 pm
    Sep 7, 2010 at 2:11 pm
  • Hi, I'm researching if smallint can be made a higher-class citizen of our type system than currently. Does anyone know where to find the discussion refered to here? ...
    Alvaro HerreraAlvaro Herrera
    Sep 3, 2010 at 10:42 pm
    Sep 5, 2010 at 1:22 pm
  • Compiling with RELCACHE_FORCE_RELEASE doesn't pass "make check" on my machine. Is it supposed to pass? Regards, Jeff Davis
    Jeff DavisJeff Davis
    Sep 1, 2010 at 6:33 pm
    Sep 2, 2010 at 1:12 pm
  • Awhile back I ranted about replacing the planner's concept of inner indexscans with a more generalized notion of "parameterized paths": ...
    Tom LaneTom Lane
    Sep 2, 2010 at 9:31 pm
    Nov 10, 2011 at 2:06 am
  • Hello who is psycopg maintainer, please? Can somebody explains to me, why psycopg doesn't support twophase commit still, although some implementation was done in summer 2008? Now two phase commit is ...
    Pavel StehulePavel Stehule
    Sep 18, 2010 at 4:02 pm
    Nov 6, 2010 at 4:34 pm
  • Where does PGXS makefile get /usr/share/doc/pgsql/contrib directory from? While building 3rd party RPMs using PGXS, even if I specify docdir in Makefile, README.* files are installed to this ...
    Devrim GündüzDevrim Gündüz
    Sep 19, 2010 at 9:25 pm
    Oct 12, 2010 at 1:50 pm
  • Hey all, Here is simple test case of LOB usage, please, note the comments: #include <libpq-fe.h #include <libpq/libpq-fs.h int main(int argc, char* argv[]) { PGconn* c = PQconnectdb("password=test"); ...
    Dmitriy IgrishinDmitriy Igrishin
    Sep 24, 2010 at 1:13 pm
    Sep 27, 2010 at 10:17 pm
  • psql's \dn command hides pg_temp_nn schemas, except for the current backend's own temp schema (if any). However, when we added separate pg_toast_temp_nn schemas for TOAST tables, \dn wasn't taught ...
    Tom LaneTom Lane
    Sep 18, 2010 at 7:11 pm
    Sep 27, 2010 at 12:09 pm
  • Now that we have the wonderful latch facility, let's use it to reduce the delay between receiving a piece of WAL and applying in the standby. Currently, the startup process polls every 100ms to see ...
    Heikki LinnakangasHeikki Linnakangas
    Sep 13, 2010 at 11:40 am
    Sep 14, 2010 at 1:46 pm
  • Hi, I found walsender didn't process options (e.g., application_name in primary_conninfo) passed in the startup packet. The cause is that walsender doesn't execute process_postgres_switches() and ...
    Fujii MasaoFujii Masao
    Sep 10, 2010 at 10:17 am
    Sep 13, 2010 at 9:02 am
  • Hi, Starting from 9.0, it seems unable to generate man pages for Japanese translated sgml(generating html is ok). Until 8.4 it worked fine. Does anybody succeeded in generating non English/multibyte ...
    Tatsuo IshiiTatsuo Ishii
    Sep 29, 2010 at 2:23 pm
    Sep 30, 2010 at 6:11 am
  • Hello, just doing an upgrade form PostgreSQL 8.4.4 on Windows 2007 64bit to PostgreSQL 9.0 64bit on the same system. I am working along http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html ...
    Massa, Harald ArminMassa, Harald Armin
    Sep 26, 2010 at 9:42 am
    Sep 29, 2010 at 6:27 pm
  • If I have this sql composite type: CREATE TYPE d_type AS ( i integer, e integer, id integer ); and this table: CREATE TABLE my_tab ( d_col d_type NOT NULL ) CREATE INDEX my_tab_d_col_gist ON my_tab ...
    Marios VodasMarios Vodas
    Sep 27, 2010 at 8:27 am
    Sep 27, 2010 at 3:52 pm
  • At the moment, to enable logging, a service restart is required. Is there any way to remove this requirement or is there a fundamental reason why it must always be like that? -- Thom Brown Twitter: ...
    Thom BrownThom Brown
    Sep 24, 2010 at 8:34 am
    Sep 24, 2010 at 4:01 pm
  • Hi, I want to shut down the server under certain conditions that can be checked inside a backend process. For instance, while running symmetric replication, if the primary dies, I want the the ...
    Fazool meinFazool mein
    Sep 21, 2010 at 12:48 am
    Sep 22, 2010 at 11:28 pm
  • Hi ! I wonder if the SSI implementation will give some way of detecting the cause of a serialization failure. Something like the deadlock detection maybe where you get the sql-statements involved. ...
    Dan SDan S
    Sep 20, 2010 at 5:56 pm
    Sep 21, 2010 at 5:15 pm
  • I notice that RelationCreateStorage() creates the main fork on disk before writing (let alone flushing) WAL. So if PG gets killed at that point, we end up with an orphaned file on disk. I think that ...
    Robert HaasRobert Haas
    Sep 15, 2010 at 10:40 pm
    Sep 16, 2010 at 10:57 pm
  • Folks, I noticed a little unimplemented feature which I suspect a lot of people would find useful, namely the ability to "freeze" certain settings for a role. Example: We'd like to create a role ...
    David FetterDavid Fetter
    Sep 7, 2010 at 6:39 pm
    Sep 7, 2010 at 11:44 pm
  • Hello, At work, I've been tasked with providing some Windows connection libraries, etc. Are people still using MinGW, or should I just recommend using a proprietary toolkit to do the builds? If so, ...
    David FetterDavid Fetter
    Sep 3, 2010 at 3:11 pm
    Sep 6, 2010 at 1:24 pm
  • Hi, I always wondered why ps ax|grep postgres shows several extra blank lines after the process name, i.e. 972 ?? Ss 0:00.69 postgres: writer process 973 ?? Ss 0:00.51 postgres: wal writer process (I ...
    Alexey KlyukinAlexey Klyukin
    Sep 3, 2010 at 6:25 pm
    Sep 5, 2010 at 3:06 pm
  • It would crash if input is of unrecognized format. Probably than there's going to be more problems to be concerned with, but just in case, don't crash in -- GJ
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    Sep 28, 2010 at 1:31 pm
    Sep 28, 2010 at 3:28 pm
  • Dear all, Environement: - OS : Ubuntu 10.04 LTS. - DB: postgresql 8.4. - Connection to postgresql using sslmode = disable Scenario : 1. I use pgadmin to connect/disconnect to the postgresql server on ...
    Guillaume Du PasquierGuillaume Du Pasquier
    Sep 27, 2010 at 3:56 pm
    Sep 27, 2010 at 5:49 pm
  • Hi all. My name is Jose Arthur and I use PostgreSQL for a while, but never contributed to the main project, until now. Since nobody else take this patch to review in this commitfest, I'm going to try ...
    José Arthur Benetasso VillanovaJosé Arthur Benetasso Villanova
    Sep 25, 2010 at 10:55 pm
    Sep 27, 2010 at 1:43 pm
  • Seems like it's probably a good idea, but I wanted to double-check that no one has a different thought. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
    Robert HaasRobert Haas
    Sep 26, 2010 at 6:26 pm
    Sep 27, 2010 at 8:06 am
  • Hello everyone, I am designing a heartbeat system between replicas to know when a replica goes down so that necessary measures can be taken. As I see, there are two ways of doing it: 1) Creating a ...
    Fazool meinFazool mein
    Sep 16, 2010 at 9:49 pm
    Sep 26, 2010 at 11:27 pm
  • I have these types: CREATE TYPE p_type AS ( x double precision, y double precision ); CREATE TYPE d_type AS ( i p_type, e p_type, id integer ); CREATE OR REPLACE FUNCTION d_swap(d_type) RETURNS ...
    Marios VodasMarios Vodas
    Sep 26, 2010 at 3:35 pm
    Sep 26, 2010 at 6:36 pm
  • The psql \dd command has a couple of infelicities. 1. It doesn't actually list comments on all of the object types to which they can be applied using the COMMENT command. 2. It also doesn't list ...
    Robert HaasRobert Haas
    Sep 20, 2010 at 4:53 am
    Sep 24, 2010 at 1:41 pm
  • Hi. My new clone of git://git.postgresql.org/git/postgresql.git is 196MB, whereas my old clone (last synced around the beginning of September) was 285MB. Does anyone know offhand why the sizes are so ...
    Abhijit Menon-SenAbhijit Menon-Sen
    Sep 21, 2010 at 9:45 pm
    Sep 22, 2010 at 2:19 pm
  • I would like to apply the attached patch to README.HOT so clarify when single-page cleanup happens, e.g. not during INSERT. -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    Sep 17, 2010 at 7:53 pm
    Sep 19, 2010 at 5:52 pm
  • I don't know if this is a bug or not, but if not, it looks like a misfeature ... When executing the following in Pg 8.4.4: CREATE OR REPLACE FUNCTION f () RETURNS TABLE(a1 INTEGER) AS $BODY$ BEGIN ...
    Darren DuncanDarren Duncan
    Sep 16, 2010 at 6:33 am
    Sep 17, 2010 at 3:13 am
  • Like latches, nice one. The way the loop in WalSender now happens it won't send any outstanding WAL if a shutdown is requested while it is waiting. That probably needs to change and we'd do similarly ...
    Simon RiggsSimon Riggs
    Sep 14, 2010 at 3:16 pm
    Sep 15, 2010 at 7:09 am
  • I haven't had a chance to do a great deal of work on this project, but I'm hoping to get back to it at some point and, in the meantime, thought that it might be useful to circulate a few thoughts ...
    Robert HaasRobert Haas
    Sep 7, 2010 at 2:55 am
    Sep 14, 2010 at 2:37 am
  • Can someone update the PostgreSQL shared memory usage table for 9.0? http://www.postgresql.org/docs/9.0/static/kernel-resources.html#SYSVIPC Right now it says "Approximate shared memory bytes ...
    Bruce MomjianBruce Momjian
    Sep 13, 2010 at 8:44 pm
    Feb 21, 2011 at 3:08 am
  • Hello, I propose a new hook type - that helps with controlling a life cycle of some tsearch dictionaries. This hook has minimal impact on performance - it's called once per session for one tsearch ...
    Pavel StehulePavel Stehule
    Sep 5, 2010 at 6:37 am
    Sep 30, 2010 at 9:37 am
  • When we drop an operator used by other operators as COMMUTATOR or NEGATOR, pg_dump generates an invalid SQL command for the operators depending on the dropped one. Is it an unavoidable restriction? ...
    Itagaki TakahiroItagaki Takahiro
    Sep 29, 2010 at 7:56 am
    Sep 29, 2010 at 3:25 pm
  • Folks, We're almost half way through the commitfest, and so I'll start with: The Good: - Most patches still in play have a reviewer. - It's possible for one person to post 5 reviews in a day. Robert ...
    David FetterDavid Fetter
    Sep 28, 2010 at 9:03 pm
    Sep 29, 2010 at 2:16 am
Sep 2010
1234
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions155
posts2,173
users126
websitepostgresql.org...
irc#postgresql

126 users for September 2010

Tom Lane: 367 posts Robert Haas: 332 posts Heikki Linnakangas: 120 posts Magnus Hagander: 114 posts Pavel Stehule: 77 posts Simon Riggs: 74 posts Kevin Grittner: 73 posts Fujii Masao: 61 posts Bruce Momjian: 58 posts Andrew Dunstan: 54 posts Peter Eisentraut: 53 posts Itagaki Takahiro: 51 posts Alvaro Herrera: 49 posts Markus Wanner: 42 posts David Fetter: 36 posts Dimitri Fontaine: 33 posts Thom Brown: 31 posts Josh Berkus: 25 posts Dave Page: 24 posts David E. Wheeler: 23 posts
show more
Archives