FAQ

Search Discussions

196 discussions - 1,618 posts

  • The time from release 7.3 to release 7.4 was 355 days, an all-time high. We really need to shorten that. We already have a number of significant improvements in 7.5 now, and several good ones coming ...
    Peter EisentrautPeter Eisentraut
    Nov 17, 2003 at 11:46 pm
    Dec 9, 2003 at 12:50 am
  • Folks, If possible, for the upcoming release we'd like to get the Contributor List on developer.postgresql.org updated. Can everyone please take a gander at: http://developer.postgresql.org/bios.php ...
    Josh BerkusJosh Berkus
    Nov 5, 2003 at 9:51 pm
    Nov 10, 2003 at 7:02 pm
  • Here are the major things I do for the PostgreSQL project. Are there some items I should be doing more/less of? o Patches o TODO/FAQ o Email discussion, coordination o Win32 o Talks o Books/articles ...
    Bruce MomjianBruce Momjian
    Nov 7, 2003 at 5:16 pm
    Dec 26, 2003 at 4:47 pm
  • I'd like to add a new column to pg_attribute that specifies the attribute's "logical position" within its relation. The idea here is to separate the logical order of the columns in a relation from ...
    Neil ConwayNeil Conway
    Nov 17, 2003 at 4:48 pm
    Nov 26, 2003 at 11:21 pm
  • Folks, Of course, while I was editing press releases at 2am, I started thinking about our next version. It seems certain that the next release, in 6-9 months, will have at a minimum the Windows port ...
    Josh BerkusJosh Berkus
    Nov 17, 2003 at 11:12 pm
    Nov 20, 2003 at 5:32 am
  • It appears there's not a lot of interest in discussing the possibility of FK constraint creation WITHOUT the verification check. How then should one handle the situation with pg_restore and large dbs ...
    OwOw
    Nov 26, 2003 at 9:01 am
    Nov 28, 2003 at 2:06 pm
  • I thought someone might be interested in a data point I have comparing 7.3.4 and 7.4beta5 with results from our DBT-2 workload. Keep in mind I haven't done much tuning with either version. The ...
    MarkwMarkw
    Nov 1, 2003 at 12:18 am
    Nov 20, 2003 at 7:48 pm
  • QUERY PLAN -------------------------------------------------------------------------------------------------------------------- Aggregate (cost=11177.19..11177.19 rows=1 width=4) (actual ...
    Tom LaneTom Lane
    Nov 28, 2003 at 7:45 pm
    Nov 29, 2003 at 1:15 pm
  • No. that is correct. It is calculated as threshold = base + scale*numebr of current rows Which translates to 21,000 = 1000 + 2*1000 However I do not agree with this logic entirely. It pegs the next ...
    Shridhar DaithankarShridhar Daithankar
    Nov 19, 2003 at 2:11 pm
    Nov 26, 2003 at 4:28 am
  • I've been looking all over but I can't seem to see a company that is providing *up-to-date* postgresql support and provides their own supported binaries. Am I barking up the wrong tree entirely here? ...
    Austin GonyouAustin Gonyou
    Nov 18, 2003 at 10:22 pm
    Nov 25, 2003 at 6:59 pm
  • I've just uploaded http://developer.postgresql.org/~wieck/all_performance.v4.74.diff.gz This patch contains the "still not yet ready" performance improvements discussed over the couple last days. ...
    Jan WieckJan Wieck
    Nov 5, 2003 at 7:08 pm
    Nov 10, 2003 at 4:18 pm
  • Attached is a first trial implementation of the Adaptive Replacement Cache (ARC). The patch is against CVS HEAD of 7.4. The algorithm is based on what's described in these papers: ...
    Jan WieckJan Wieck
    Nov 3, 2003 at 6:50 pm
    Nov 7, 2003 at 8:53 pm
  • OK, I've been spreading rumours about fixing the internationalization problems, so let me make it a bit more clear. Here are the problems that need to be fixed: - Only one locale per process ...
    Peter EisentrautPeter Eisentraut
    Nov 24, 2003 at 7:08 pm
    Nov 26, 2003 at 7:26 pm
  • What is the status of CVS head? Isn't it in sync with 7.4.RC2? I just upgraded from CVS and rebuilt clean and initdb now gives this lovely informative initdb failed message. I haven't had trouble ...
    EleinElein
    Nov 13, 2003 at 2:07 am
    Nov 16, 2003 at 5:58 pm
  • Just looking at the information schema in 7.4 and noticed something odd/annoying/problematic: create table pk(f1 int primary key); create table fk1(f1 int references pk(f1)); create table fk2(f1 int ...
    Philip WarnerPhilip Warner
    Nov 6, 2003 at 1:01 pm
    Nov 8, 2003 at 2:47 am
  • Hello, As Command Prompt is about to release it's Replication product we are open sourcing our pgManage. pgManage is similar to pgAdmin but as it is java based it is truly cross platform and should ...
    Joshua D. DrakeJoshua D. Drake
    Nov 4, 2003 at 7:14 pm
    Nov 5, 2003 at 5:39 pm
  • The attached diff is another attempt for distributing the write IO. It is a separate background process much like the checkpointer. It's purpose is to keep the number of dirty blocks in the buffer ...
    Jan WieckJan Wieck
    Nov 13, 2003 at 9:36 pm
    Nov 19, 2003 at 4:10 pm
  • Hi, I just noticed some incorrect behaviour for postgresql-7.4 related to locale. After installing 7.4 I created database completely from scratch with cyrillic locale: su postgres export ...
    E.RodichevE.Rodichev
    Nov 27, 2003 at 7:57 pm
    Dec 4, 2003 at 3:46 pm
  • All: Does anyone know if there is going to be a port to Solaris 9 x86 in the near future. What is the decission to develop on this platform since Sun is pushing Solaris x86 harder than ever. -- ...
    Christoper SmigaChristoper Smiga
    Nov 18, 2003 at 4:06 pm
    Nov 20, 2003 at 1:12 am
  • This worked in 7.3: regression=# select '1999-jan-08'::date; ERROR: date/time field value out of range: "1999-jan-08" HINT: Perhaps you need a different "datestyle" setting. Setting DateStyle to YMD ...
    Tom LaneTom Lane
    Nov 14, 2003 at 11:15 pm
    Nov 16, 2003 at 5:34 am
  • Dear community, for some reason the post I sent yesterday night still did not show up on the mailing lists. I have set up some links on the developers side under ...
    Jan WieckJan Wieck
    Nov 11, 2003 at 3:34 pm
    Nov 13, 2003 at 4:25 pm
  • Hi everyone, I'm just interested in what everyone's personal plans for 7.5 development are? Shridar, Gavin and myself are trying to get the tablespaces stuff off the ground. Hopefully we'll have a ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 27, 2003 at 2:23 am
    Nov 28, 2003 at 5:41 am
  • While people add more executable files to CVS (cf. initdb.c), can we do something about it? -- Peter Eisentraut peter_e@gmx.net
    Peter EisentrautPeter Eisentraut
    Nov 23, 2003 at 9:25 pm
    Nov 24, 2003 at 1:23 pm
  • A couple days ago, Manfred Spraul mentioned the posix_fadvise() API on -hackers: http://www.opengroup.org/onlinepubs/007904975/functions/posix_fadvise.html I'm working on making use of ...
    Neil ConwayNeil Conway
    Nov 3, 2003 at 6:08 am
    Nov 3, 2003 at 11:38 pm
  • Hi, Consider the following input data: 1234,24.50,10-Jan-2003,10/1/03,10-01-2003,hiall The interpretation for the numbers is: 1234 = 12.34, 24.50 = 24.50 The interpretation for the dates is: January ...
    Stephen FrostStephen Frost
    Nov 27, 2003 at 2:15 pm
    Nov 28, 2003 at 6:37 pm
  • The PostgreSQL group has recently had a patch submitted with a snippet of code from FreeBSDs src/bin/mkdir/mkdir.c. http://www.freebsd.org/cgi/cvsweb.cgi/src/bin/mkdir/mkdir.c?annotate=1.27 Is this ...
    Rod TaylorRod Taylor
    Nov 17, 2003 at 7:48 pm
    Nov 20, 2003 at 8:27 pm
  • I think I have some more information on the statistics collector startup problem on Solaris. I inserted the following into pgstat.c: if (bind(pgStatSock, addr- ai_addr, addr- ai_addrlen) < 0) { /* ...
    Derek MorrDerek Morr
    Nov 13, 2003 at 9:05 pm
    Nov 15, 2003 at 6:16 pm
  • As Tom announced on Friday, Release Candidate 1 has now been tag'd and bundled ... please test to confirm that nothing seems off with this build ... I'm going to do a broader announce on it tonight, ...
    Marc G. FournierMarc G. Fournier
    Nov 3, 2003 at 5:40 am
    Nov 5, 2003 at 4:15 pm
  • I'm thinking about attacking pg_dump's lack of knowledge about using dependencies to determine a safe dump order. But if there's someone out there actively working on the problem, I don't want to ...
    Tom LaneTom Lane
    Nov 21, 2003 at 4:40 pm
    Nov 25, 2003 at 8:51 am
  • Redirected to -hackers Neil Conway kirjutas L, 15.11.2003 kell 22:20: For me, the "start of transaction" is not about time, but about grouping a set of statements into one. So making the exact moment ...
    Hannu KrosingHannu Krosing
    Nov 16, 2003 at 11:58 am
    Nov 18, 2003 at 7:35 am
  • I just noticed tonight that the new initdb introduced a subtle change of behavior. I use a shell script to automate the process of - rm old data directory - mkdir new data directory - initdb - load ...
    Joe ConwayJoe Conway
    Nov 14, 2003 at 5:56 am
    Nov 14, 2003 at 5:50 pm
  • I'm in the middle of implementing function parameter names. In pg_proc the types of the parameters are currently stored as an oidvector, but how should I store the parameter names? Would it be a good ...
    Dennis BjorklundDennis Bjorklund
    Nov 23, 2003 at 4:53 pm
    Nov 26, 2003 at 2:52 am
  • Here's my notes on how to build PostgreSQL 7.4 (CVS) on OS X 10.3 (7B85) with (seems to be working, but I haven't really ran any tests) python, tcl, perl, readline. I noticed today that you guys are ...
    Bob IppolitoBob Ippolito
    Nov 8, 2003 at 12:44 am
    Nov 8, 2003 at 11:48 pm
  • A fair number of the performance problems posted to mailing lists are the result of the query planner choosing a poor query plan. Some of these instances are due to a defect in PostgreSQL (e.g. index ...
    Neil ConwayNeil Conway
    Nov 26, 2003 at 3:11 pm
    Nov 27, 2003 at 2:54 am
  • Failed to build on Solaris. Summary 1. Checking for pstat... no 2. Regression Failur stats ..... FAILED . 3. Not running stats buffer process and stats collector process. ...
    Kiyoshi SawadaKiyoshi Sawada
    Nov 11, 2003 at 6:28 am
    Nov 14, 2003 at 5:40 am
  • I have just committed the implementation of ARC into the 7.5devel tree. This doesn't contain the vacuum page delay, or the test implementation of the background writer based on the checkpoint ...
    Jan WieckJan Wieck
    Nov 13, 2003 at 12:54 am
    Nov 13, 2003 at 4:22 pm
  • I haven't seen any discussion on the topic, so thought I might start one. We currently provide rpms for Red Hat 7.x, 8.x, and 9, and I'm assuming that we'll have rpms for all of those for 7.4 once ...
    Robert TreatRobert Treat
    Nov 12, 2003 at 1:58 pm
    Nov 13, 2003 at 3:11 pm
  • Hi, I've searched through libpq and looked for global or static variables as indicators of non-threadsafe code. I found: - Win32 and BeOS: there is a global "ioctlsocket_ret variable, but it seems to ...
    Manfred SpraulManfred Spraul
    Nov 17, 2003 at 9:56 pm
    Mar 14, 2004 at 3:06 pm
  • Do we have any data on how many people download the partial tarballs (-base, -opt, etc.)? I have a feeling that more people are confused by them than use them. -- Peter Eisentraut peter_e@gmx.net
    Peter EisentrautPeter Eisentraut
    Nov 11, 2003 at 6:44 pm
    Nov 12, 2003 at 4:28 am
  • When I start up with -i, I get the following log: LOG: could not bind IPv4 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and ...
    Peter EisentrautPeter Eisentraut
    Nov 6, 2003 at 7:51 pm
    Nov 11, 2003 at 6:38 pm
  • Hi all, This is my first patch for PostgreSQL against the 7.5devel cvs (please advise if this is the wrong place to post patches). This patch simply enables the \xDD (or \XDD) hexadecimal import in ...
    Jason GoddenJason Godden
    Nov 5, 2003 at 11:30 am
    Nov 6, 2003 at 6:45 am
  • Here is what I get: peter ~$ pg-install/bin/initdb pg-install/var/data ... creating directory pg-install/var/data ... initdb: failed No points for details in the error message here either. If I ...
    Peter EisentrautPeter Eisentraut
    Nov 23, 2003 at 6:17 pm
    Dec 1, 2003 at 11:15 pm
  • Late in the 7.4 release we've added a patch that changed -fpic to -fPIC for Linux Sparc. We wanted to investigate that issue further later on. I've tried building PostgreSQL with -fpic on Sparc and ...
    Peter EisentrautPeter Eisentraut
    Nov 28, 2003 at 9:16 am
    Nov 30, 2003 at 1:56 pm
  • Based on discussions on -hackers, and baring any objections betwen now and then, I'm going to go through all files in CVS and change: $Id$ - $PostgreSQL$ I will do this the evening of Friday, ...
    Marc G. FournierMarc G. Fournier
    Nov 27, 2003 at 5:53 am
    Nov 29, 2003 at 10:43 pm
  • Hi folks, Is there any pre-existing protocol for a company to pay for specific features to be added to PostgreSQL? I've gotten full executive buy-in to the idea that it would be far cheaper to ...
    James RogersJames Rogers
    Nov 18, 2003 at 7:34 pm
    Nov 24, 2003 at 6:20 pm
  • Since this is a large query, attachments for the explains / query. Configuration: dev_iqdb=# select version(); version ------------------------------------------------------------------------ ...
    Rod TaylorRod Taylor
    Nov 5, 2003 at 7:18 pm
    Nov 6, 2003 at 7:29 pm
  • Hello, I'm running Postgresql 7.3.4 with ru_RU.UTF-8 locale (with UNICODE database encoding), and all is almost well, except that UPPER() and LOWER() seem to ignore locale. I searched the sources ...
    Alexey MahotkinAlexey Mahotkin
    Nov 4, 2003 at 12:42 pm
    Mar 27, 2004 at 2:57 am
  • Hello! Explain analyze takes 3 times more time for execution. Why? wow=# \timing Timing is on. wow=# select max(click.accesses) from click; max ---------- 10944762 (1 row) Time: 105,654 ms wow=# ...
    Teodor SigaevTeodor Sigaev
    Nov 27, 2003 at 2:14 pm
    Nov 28, 2003 at 8:14 pm
  • Hi Everyone, This is my first post here so please tell me to go somewhere else if this is the wrong place to post questions like this. I am using PostgreSQL 7.3.2 and have used earlier versions ...
    Slavisa GaricSlavisa Garic
    Nov 14, 2003 at 7:46 am
    Nov 15, 2003 at 5:27 am
  • Barring surprises, we will institute a code freeze in the 7.4 branch tonight with an eye to wrapping the release Sunday. Is anyone aware of critical loose ends that still need to be dealt with? The ...
    Tom LaneTom Lane
    Nov 13, 2003 at 5:44 pm
    Nov 14, 2003 at 7:54 am
Group Navigation
period‹ prev | Nov 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions196
posts1,618
users183
websitepostgresql.org...
irc#postgresql

183 users for November 2003

Tom Lane: 256 posts Bruce Momjian: 135 posts Peter Eisentraut: 99 posts Marc G. Fournier: 79 posts Jan Wieck: 74 posts Andrew Dunstan: 64 posts Neil Conway: 51 posts Christopher Kings-Lynne: 50 posts Josh Berkus: 35 posts Andreas Pflug: 30 posts Greg Stark: 29 posts Alvaro Herrera Munoz: 28 posts Robert Treat: 27 posts Shridhar Daithankar: 24 posts Larry Rosenman: 23 posts Hannu Krosing: 22 posts Joe Conway: 21 posts Joshua D. Drake: 20 posts Rod Taylor: 20 posts Manfred Spraul: 18 posts
show more
Archives