FAQ

Search Discussions

155 discussions - 2,173 posts

  • Ganesh Venkitachalam-1Ganesh Venkitachalam-1
    Sep 22, 2010 at 8:38 pm
    Sep 23, 2010 at 4:22 pm
  • I dug into the 9.0 bug reported here: http://archives.postgresql.org/pgsql-sql/2010-09/msg00035.php What is happening is that the planner recognizes that the query is unsatisfiable, because m.ttype ...
    Tom LaneTom Lane
    Sep 14, 2010 at 7:10 pm
    Sep 15, 2010 at 2:30 am
  • Greetings, After watching a database import go abysmally slow on a pretty beefy box with tons of RAM, I got annoyed and went to hunt down why in the world PG wasn't using but a bit of memory. Turns ...
    Stephen FrostStephen Frost
    Sep 20, 2010 at 4:51 pm
    Feb 20, 2011 at 2:42 pm
  • Does the git.postgresql.org down? Harada-san being also unreachable now. -- KaiGai Kohei <kaigai@kaigai.gr.jp
    KaiGai KoheiKaiGai Kohei
    Sep 29, 2010 at 11:44 am
    Sep 29, 2010 at 12:09 pm
  • Is it posible? Either by using heap_form_tuple or BuildTupleFromCStrings. CREATE TYPE p_type AS ( x double precision, y double precision ); CREATE TYPE d_type AS ( i p_type, e p_type, id integer ); ...
    Marios VodasMarios Vodas
    Sep 26, 2010 at 8:20 pm
    Sep 27, 2010 at 2:11 pm
  • If it resembles cvs2cl then why not name it git2cl? Or git_changelog. Since it doesn't do anything specific to Postgres' git, lets not have any pg in there. Regards, -- gurjeet.singh @ EnterpriseDB - ...
    Gurjeet SinghGurjeet Singh
    Sep 24, 2010 at 10:53 pm
    Sep 25, 2010 at 3:11 am
  • Hi. This is a follow up and updated patch on several old discussions: http://archives.postgresql.org/pgsql-hackers/2009-07/msg01065.php http://archives.postgresql.org/pgsql-admin/2010-04/msg00164.php ...
    Jesper KroghJesper Krogh
    Sep 21, 2010 at 6:44 pm
    Sep 22, 2010 at 10:24 am
  • I was thinking of just removing it, but is there anything that ought to replace it? regards, tom lane
    Tom LaneTom Lane
    Sep 21, 2010 at 9:09 pm
    Sep 21, 2010 at 9:34 pm
  • May be this is the wrong place to ask the question. Still, answer me if someone can or please redirect me to some place where it can be answered. My questions are: 1. PostgreSQL can be distributed ...
    Vaibhav KaushalVaibhav Kaushal
    Sep 20, 2010 at 6:48 am
    Sep 20, 2010 at 7:05 am
  • The core committee has decided that it's time to press forward with releasing 9.0. Barring catastrophic bug reports in the next week, 9.0.0 will be wrapped Thursday 9/16 for public announcement ...
    Tom LaneTom Lane
    Sep 8, 2010 at 9:04 pm
    Sep 19, 2010 at 4:22 am
  • Can anyone explain why VACUUM after INSERT shows steadily decreasing freespace, while DELETE of the same rows does not decrease consistently? Specifically, after one row is inserted I see: SELECT ...
    Bruce MomjianBruce Momjian
    Sep 18, 2010 at 12:45 am
    Sep 18, 2010 at 1:34 am
  • Hi, I'm resending it to here, since I didn't got no response from the "general" group. I am trying to create a simple c-language function for "PostgreSQL 8.4.4, compiled by Visual C++ build 1400, ...
    Tomáš KováříkTomáš Kovářík
    Sep 15, 2010 at 7:34 am
    Sep 16, 2010 at 11:45 pm
  • In about a week I propose to have the buildfarm server start to reject results based on snapshots where the newest file is older than the time of the git migration a week ago. That means buildfarm ...
    Andrew DunstanAndrew Dunstan
    Sep 27, 2010 at 12:13 pm
    Oct 15, 2010 at 9:32 pm
  • Hackers, Any tips / conventional wisdom regarding running postgres on large- ish memory ccNUMA intel machines, such as a 32G dual-quad-core, showing two NUMA nodes of 16G each? I expect each postgres ...
    James RobinsonJames Robinson
    Sep 29, 2010 at 7:15 pm
    Oct 1, 2010 at 1:32 am
  • I see this in 9.0 Release note: - Support locale-specific regular expression processing with UTF-8 server encoding (Tom Lane) Locale-specific regular expression functionality includes ...
    Sergey BurladyanSergey Burladyan
    Sep 28, 2010 at 9:35 pm
    Sep 28, 2010 at 10:37 pm
  • Hi all, I'm interested in this parallel project, http://wiki.postgresql.org/wiki/Parallel_Query_Execution But I can't find any discussion and current progress in the website, it seems to stop for ...
    Li JieLi Jie
    Sep 28, 2010 at 5:24 am
    Sep 28, 2010 at 11:17 am
  • I've been looking at the bug reported by Kirill Simonov here: http://archives.postgresql.org/pgsql-bugs/2010-09/msg00265.php This is pretty ugly :-(. What we have is select * from A left join (select ...
    Tom LaneTom Lane
    Sep 27, 2010 at 5:15 pm
    Sep 28, 2010 at 1:27 am
  • Hi, It looks like your transition to git has been a success. Your very careful conversion from CVS to git and your exacting scrutiny of the results are a great check that cvs2git is not doing ...
    Michael HaggertyMichael Haggerty
    Sep 25, 2010 at 12:28 pm
    Sep 26, 2010 at 7:01 pm
  • Some voter in Sweden has an interesting sense of humour.... http://alicebobandmallory.com/articles/2010/09/23/did-little-bobby-tables-migrate-to-sweden -- greg
    Greg StarkGreg Stark
    Sep 24, 2010 at 4:18 pm
    Sep 24, 2010 at 4:54 pm
  • Hello list, We intend to implement $subject, so instead of mycursor CURSOR (myparm text) IS SELECT myparm; OPEN mycursor('A'); it would be possible to do OPEN mycursor(myparm := 'A'); The idea is to ...
    Yeb HavingaYeb Havinga
    Sep 22, 2010 at 3:00 pm
    Sep 22, 2010 at 8:13 pm
  • Folks, I was noticing that, where we have a function which has two versions, timestamp and timestamptz (for example, date_trunc()), if I use a DATE timestamptz is the default cast. Shouldn't ...
    Josh BerkusJosh Berkus
    Sep 18, 2010 at 12:28 am
    Sep 18, 2010 at 1:01 am
  • I was just noticing that, on this page here: http://www.postgresql.org/docs/9.0/static/catalogs.html ...all of the catalogs are in alphabetical order, except for pg_db_role_setting, which is filed in ...
    Robert HaasRobert Haas
    Sep 17, 2010 at 5:17 pm
    Sep 17, 2010 at 5:28 pm
  • Hello all, May be this is notneeded, but I thought I could just introduce myself to the list and why am I here. My name is Vaibhav Kaushal, a good leaner and a really bad student. I bunk classes, ...
    Vaibhav KaushalVaibhav Kaushal
    Sep 16, 2010 at 8:04 am
    Sep 16, 2010 at 6:41 pm
  • Hi, In HEAD, OwnLatch can elog during holding the spinlock WalSnd- mutex. This seems to be unsafe because that elog would cause the walsender to exit without releasing the spinlock. Because of the ...
    Fujii MasaoFujii Masao
    Sep 15, 2010 at 2:27 am
    Sep 15, 2010 at 6:52 am
  • All, As far as I'm concerned, the other big "missing feature" for HS is the ability to promote standbys to become the new master. If we had that feature, then HS can be the backbone of a large-scale ...
    Josh BerkusJosh Berkus
    Sep 3, 2010 at 8:02 pm
    Sep 6, 2010 at 1:35 am
  • Hello I am looking on ToDo topic - Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Some the most simple solution can be enhancing regtype to support this syntax - this can be relative simple, and ...
    Pavel StehulePavel Stehule
    Sep 4, 2010 at 5:30 am
    Sep 4, 2010 at 4:53 pm
  • I just started trying out the new make targets with "world" in the name. `make world` and `make install-world` seem to work (unless I'm missing something), but `make installcheck-world` ends with ...
    Kevin GrittnerKevin Grittner
    Sep 2, 2010 at 5:18 pm
    Sep 2, 2010 at 5:36 pm
  • Hi, Is there any reason the postmaster.pid and external_pid_file contents to be different? -- Euler Taveira de Oliveira http://www.timbira.com/
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Sep 30, 2010 at 12:18 am
    Oct 19, 2010 at 3:09 am
  • Attached is a patch that implements replacing a primary key with another index. This would help overcome the limitation that primary keys cannot be reindexed without taking exclusive locks. The use ...
    Gurjeet SinghGurjeet Singh
    Sep 30, 2010 at 12:43 am
    Sep 30, 2010 at 8:33 pm
  • Hello This patch add iteration over array to plpgsql now is supported only iteration over scalar array Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 8:03 am
    Sep 30, 2010 at 8:55 am
  • This patch suffered a lot of bitrot in the last month, mostly due to the noop patch for SSI. It also used the term SERIALIZABLE in many places to indicate any transaction-snapshot mode transaction, ...
    Kevin GrittnerKevin Grittner
    Sep 18, 2010 at 6:45 pm
    Sep 24, 2010 at 9:19 pm
  • Doing "git log tags/REL8_3_6" I see two commits after the one labeled "tag for 8.3.6". The other tags I checked all seem to match what I would expect. I'm not suggesting that anything be done, I just ...
    Jeff DavisJeff Davis
    Sep 24, 2010 at 6:36 pm
    Sep 24, 2010 at 7:06 pm
  • ... other than it just got forgotten? dolszewski=# create view meh as select * from pg_tables; CREATE VIEW dolszewski=# copy meh to stdout; ERROR: cannot copy from view "meh" HINT: Try the COPY ...
    Josh BerkusJosh Berkus
    Sep 23, 2010 at 8:52 pm
    Sep 23, 2010 at 9:00 pm
  • Hi, In ctid, there are the block num, and the tuple offset inside the block. How can I know the maximum number of tuples in a block? The block size would be BLCKSZ. I am not quite sure where is the ...
    Pei HePei He
    Sep 22, 2010 at 3:42 am
    Sep 22, 2010 at 10:35 am
  • Hi. I'm trying to migrate an application off an existing Full Text Search engine and onto PostgreSQL .. one of my main (remaining) headaches are the fact that PostgreSQL treats as a seperation ...
    JesperJesper
    Sep 20, 2010 at 2:04 pm
    Sep 21, 2010 at 5:38 pm
  • I've been having a look at this guy, trying to get a handle on how much down time it will save. As a quick check, I tried upgrading a cluster with a 1 non default db containing a scale 100 pgbench ...
    Mark KirkwoodMark Kirkwood
    Sep 21, 2010 at 4:14 am
    Sep 21, 2010 at 5:44 am
  • Hey Bruce, how is it that this recent commit http://archives.postgresql.org/pgsql-committers/2010-02/msg00202.php replaced a $PostgreSQL$ CVS keyword with a $Id$ one? The commit message mentions an ...
    Tom LaneTom Lane
    Sep 19, 2010 at 4:43 pm
    Sep 20, 2010 at 3:47 am
  • Please read the thread. The patch is intended to be applied after "sequence scan + sort for CLUSTER" patch. -- Itagaki Takahiro
    Itagaki TakahiroItagaki Takahiro
    Sep 16, 2010 at 12:23 pm
    Sep 17, 2010 at 5:37 pm
  • It just occurred to me that the Windows latch implementation goes through a lot of trouble to dynamically assign the shared Windows event handles to the latches in OwnLatch, but there's really no ...
    Heikki LinnakangasHeikki Linnakangas
    Sep 14, 2010 at 9:57 am
    Sep 14, 2010 at 2:39 pm
  • Hi, In 9.1dev, wal_sender_delay in *milliseconds* is given to WaitLatchOrSocket as *microseconds* timeout. This is obviously wrong. The attached patch fixes this problem. Regards, -- Fujii Masao ...
    Fujii MasaoFujii Masao
    Sep 14, 2010 at 1:02 pm
    Sep 14, 2010 at 1:36 pm
  • Gentlemen, I found this link in PostgreSQL 9 Documentation and we are moving to a different platform Could you please help me with the instruction of how to install the new version of PostgreSQL 9 on ...
    Igor GelmanIgor Gelman
    Sep 10, 2010 at 5:52 pm
    Sep 13, 2010 at 12:15 am
  • Portions Copyright (c) 1994, Regents of the University of California Is that line needed for new files introduced by the Community? Regards, On Sat, Sep 11, 2010 at 11:48 AM, Heikki Linnakangas ...
    Gurjeet SinghGurjeet Singh
    Sep 12, 2010 at 12:42 am
    Sep 12, 2010 at 4:11 am
  • Hey -hackers, In doing a schema upgrade, we noticed the following behavior, which certainly seems like a bug. Steps to reproduce: CREATE USER a; CREATE USER b; CREATE TABLE t1 (id serial primary ...
    David ChristensenDavid Christensen
    Sep 1, 2010 at 3:34 pm
    Sep 1, 2010 at 3:45 pm
  • Hello The attached patch contains a implementation of "subscripts" function. The functionality of this function is same like generate_subscripts function, but it's based for iteration from plpgsql's ...
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 7:29 pm
    Sep 30, 2010 at 7:29 pm
  • Hello What is the way to get tupledesc from array of records? Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Sep 29, 2010 at 7:23 pm
    Sep 29, 2010 at 7:23 pm
  • After some back-and-forth among core and -packagers, we've agreed that we're overdue for update releases for the back branches. Accordingly, we'll be wrapping update tarballs of all active branches ...
    Tom LaneTom Lane
    Sep 27, 2010 at 2:39 pm
    Sep 27, 2010 at 2:39 pm
  • We will take another run at converting our CVS repository to Git on Monday (the 20th). Hopefully this won't interfere too much with the commitfest, since most work will still be on reviewing rather ...
    Tom LaneTom Lane
    Sep 17, 2010 at 4:27 pm
    Sep 17, 2010 at 4:27 pm
  • At first, we should fix the problem that startup process cannot respond to SIGTERM and SIGHUP immediately by committing the patch that I submitted in the following post. ...
    Fujii MasaoFujii Masao
    Sep 17, 2010 at 9:52 am
    Sep 17, 2010 at 9:52 am
  • Folks, If it weren't for the last minute, nothing would ever get done. In the hallowed tradition of Commitfests, and the Feature Freezes that preceded them, the past week has been a flurry of ...
    David FetterDavid Fetter
    Sep 16, 2010 at 6:07 am
    Sep 16, 2010 at 6:07 am
  • Folks, If you've got a patch you want to have as part of this commitfest and it's not already on the page, you have until 2200 PST8PDT to get it on there. Cheers, David. -- David Fetter ...
    David FetterDavid Fetter
    Sep 15, 2010 at 8:50 pm
    Sep 15, 2010 at 8:50 pm
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