Search Discussions

149 discussions - 1,369 posts

  • Few proposals - Can we say "smoothed" rather than "distributed" checkpoints? "Smoothed checkpoints greatly reduce checkpoint I/O spikes" - Heap-Only Tuples (HOT) accelerate space reuse for UPDATEs ...
    Simon RiggsSimon Riggs
    Nov 30, 2007 at 6:31 am
    Dec 16, 2007 at 1:09 pm
  • Hi -hackers, I'm currently testing 8.3devel on the database of one of our customers (4 GB database used by a website - mostly read only activity). My main concern was to discover if there is any ...
    Guillaume SmetGuillaume Smet
    Nov 21, 2007 at 7:04 pm
    Nov 29, 2007 at 9:00 am
  • Hi, We've seen several cases of people (running 8.1 or 8.2) that see messages like this: 2007-11-26 11:41:59 ERROR: could not open relation 1663/352369/353685: Invalid argument The platform is Win32. ...
    Alvaro HerreraAlvaro Herrera
    Nov 28, 2007 at 2:57 pm
    Dec 21, 2007 at 12:19 pm
  • For some time I have been working on removing some inefficiencies from a large DW-type app. This app does a large daily batch update, and this is what is the major bottleneck. One of the things I ...
    Andrew DunstanAndrew Dunstan
    Nov 2, 2007 at 3:49 pm
    Oct 30, 2008 at 3:24 am
  • Something Tom Dunstan just mentioned has made me ask the question "Why does our full text search feature look so strange?". It's the operator-laden syntax that causes the problem. By any stretch, ...
    Simon RiggsSimon Riggs
    Nov 12, 2007 at 3:03 pm
    Mar 8, 2008 at 5:55 pm
  • Just wanted to review a few thoughts and ideas around improving external sorts, as recently encouraged to do by Jim Nasby. Current issues/opportunities are these: ISSUES a) Memory is always in short ...
    Simon RiggsSimon Riggs
    Nov 27, 2007 at 6:03 pm
    Mar 27, 2008 at 8:38 pm
  • It appears that Marc has got autoconf 2.61 installed now, instead of the 2.59 that we've been using for some time. I'm a bit concerned about the implications of switching to a version that's got zero ...
    Tom LaneTom Lane
    Nov 16, 2007 at 4:37 am
    Nov 26, 2007 at 12:31 pm
  • I notice that slony records the oldestxmin that was running when it last ran a VACUUM on its tables. This allows slony to avoid running a VACUUM when it would be clearly pointless to do so. AFAICS ...
    Simon RiggsSimon Riggs
    Nov 22, 2007 at 6:04 pm
    Nov 3, 2008 at 7:04 pm
  • All, Time for the annual update of this list: http://www.postgresql.org/developer/bios Here's the list of people I gleaned from the release notes (btw, if people have countries for the folks who ...
    Josh BerkusJosh Berkus
    Nov 28, 2007 at 12:07 am
    Dec 3, 2007 at 7:38 am
  • Though 8.3 isn't out of the oven just yet, I've been thinking about the dead space map a lot, and decided I have to start writing down those thoughts. Reducing VACUUM time is important, but the real ...
    Heikki LinnakangasHeikki Linnakangas
    Nov 5, 2007 at 9:53 am
    Nov 8, 2007 at 9:22 am
  • By chance I happened to notice in the release notes Release 7.3 Release date: 2002-11-27 Man, it feels like a long time since that came out... There has been some discussion of making a project ...
    Tom LaneTom Lane
    Nov 27, 2007 at 7:02 pm
    Mar 17, 2008 at 10:53 pm
  • Ok, I've been following this tangentially, but here is one thing I really don't understand: Sure, you might save this cost during update, but you do incur this cost while updating the head of the ...
    Martijn van OosterhoutMartijn van Oosterhout
    Nov 5, 2007 at 4:48 pm
    Nov 5, 2007 at 4:58 pm
  • I have a pretty small table (~20MB) that is accessed very frequently and randomly, so I want to make sure it's 100% in memory all the time. There is a lot of other staff that's also gets accessed ...
    Nov 12, 2007 at 6:50 am
    Mar 7, 2008 at 8:02 pm
  • Hi hackers, I'm now testing 8.3beta2 on a relatively big (10G) database. I've tried with pg_dymp -Fc/pg_restore and pg_dump/pgsql and get those errors: ERROR: trigger "<unnamed " for relation ...
    Nov 2, 2007 at 5:58 pm
    Nov 6, 2007 at 7:19 pm
  • Hi, ftp://elsie.nci.nih.gov/pub/tzdata2007i.tar.gz Per announcement: "...is now available; this reflects changes for Cuba and Syria circulated earlier this week on the time zone mailing list. There ...
    Devrim GÃNDÃZDevrim GÃNDÃZ
    Nov 7, 2007 at 9:53 pm
    Nov 9, 2007 at 8:01 pm
  • Every release we seem to have the same debates about performance issues. In 8.0 we shipped knowing that bgwriter had serious deficiencies, plus had no way of logging SQL statements for performance ...
    Simon RiggsSimon Riggs
    Nov 27, 2007 at 5:32 pm
    Nov 28, 2007 at 9:34 am
  • Hi Guys, I'm one of the hibernate(http://hibernate.org) team commiters and I'm here to ask you for a little help :-) I'm trying to improve the support of hibernate to Postgre(and other databases), ...
    Diego Pires PlentzDiego Pires Plentz
    Nov 11, 2007 at 3:05 pm
    Nov 12, 2007 at 5:30 pm
  • [moving thread to -hackers] Thanks for the link Martijn. I'd be interested in taking a swing at this if nobody else has laid claim. Since that thread died back in January, I'm guessing it's wide ...
    Brendan JurdBrendan Jurd
    Nov 25, 2007 at 8:08 pm
    Mar 21, 2008 at 3:02 am
  • Hello, The test lab is finally starting to come to fruition. We (the community) have been donated hardware via MyYearbook and Hi5. It is my understanding that we may also have some coming from HP. We ...
    Joshua D. DrakeJoshua D. Drake
    Nov 2, 2007 at 5:42 pm
    Nov 23, 2007 at 10:25 am
  • We might be able to do something with the suggested workaround. I will see what I can do, unless you have already tried. cheers andrew
    Andrew DunstanAndrew Dunstan
    Nov 28, 2007 at 7:32 pm
    Dec 2, 2007 at 6:51 am
  • I've been hacking on the idea of an Append node which maintains the ordering of its subtables merging their records in order. This is important for partitioned tables since otherwise a lot of plans ...
    Gregory StarkGregory Stark
    Nov 22, 2007 at 2:40 pm
    Apr 7, 2008 at 9:22 am
  • Hi, I would like to propose an additional feature for Postgres to enable time-travelling inside a transaction. I went through the source code and i found Savepoint is already saving the necessary ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Nov 2, 2007 at 9:13 am
    Nov 12, 2007 at 8:30 pm
  • Letting psql execute a script file that is really a directory doesn't complain at all: $ psql -f /tmp Should we do some kind of stat() before opening the file and abort if it's a directory? -- Peter ...
    Peter EisentrautPeter Eisentraut
    Nov 14, 2007 at 7:31 pm
    Nov 27, 2007 at 8:06 pm
  • Hi, I just installed v8.3beta3 and discovered that the way WAL archiving is handled has changed. From postgresql.conf: #archive_mode = off # allows archiving to be done (change requires restart) ...
    Rudolf van der LeedenRudolf van der Leeden
    Nov 21, 2007 at 1:54 pm
    Nov 22, 2007 at 3:39 pm
  • Hello, I am running tests with PG8.3b2 on Solaris 10 8/07 and I still see IO flood when checkpoint happens. I have tried increasing the bg_lru_multiplier from 2 to 5 from default but I dont see any ...
    Jignesh K. ShahJignesh K. Shah
    Nov 13, 2007 at 4:03 pm
    Nov 19, 2007 at 1:58 pm
  • I was playing with a Nevada server and noticed a rush on the FPU (the Nevada has a single shared FPU for its 32 threads). Looking at the spinlock code, I found : cur_delay += (int) (cur_delay * ...
    Magne MæhreMagne Mæhre
    Nov 14, 2007 at 9:35 am
    Nov 19, 2007 at 10:59 am
  • Hi all. I have read the documentation, searched the mailing lists and inspected the code JDBC driver code. I do need to address this question to actual developers. Simply put, what is the client ...
    Nov 27, 2007 at 12:52 pm
    Dec 2, 2007 at 8:29 am
  • I found a nice paper describing a few free space management algorithms: M. L. McAuliffe, M. J. Carey and M. H. Solomon, Towards Effective and Efficient Free Space Management, Proceedings of the ACM ...
    Heikki LinnakangasHeikki Linnakangas
    Nov 8, 2007 at 3:25 pm
    Nov 10, 2007 at 4:58 pm
  • I am investigating the possibility of having stored procedures and functions written in .NET language flavors. I remember a long time ago there was a gborg project wanting to implement it, but that ...
    Gevik BabakhaniGevik Babakhani
    Nov 30, 2007 at 1:32 pm
    Dec 3, 2007 at 8:57 am
  • Hi everyone, I'm working on a piece of code for PostGIS to allow the loading of projection configuration files from the share/postgresql directory, but I can't find a way of getting this to work ...
    Mark Cave-AylandMark Cave-Ayland
    Nov 26, 2007 at 2:53 pm
    Nov 27, 2007 at 7:30 am
  • Hello all, testing 8.3b3, i found out an interesting thing: we have some plpgsql functions which use quote_literal() regardless of the data type. With Beta 3 this does not work anymore[1]. Given the ...
    Andreas 'ads' ScherbaumAndreas 'ads' Scherbaum
    Nov 25, 2007 at 2:05 am
    Nov 29, 2007 at 8:57 am
  • hold the presses... Narwhal just broke :-( -------- Original Message -------- Subject: PGBuildfarm member narwhal Branch HEAD Status changed from OK to Make failure Date: Thu, 15 Nov 2007 13:23:06 ...
    Dave PageDave Page
    Nov 15, 2007 at 9:26 pm
    Nov 16, 2007 at 3:37 am
  • If the postmaster is stopped with 'pg_ctl stop' while an online backup is in progress, the 'backup_label' file will remain in the data directory. There is no recovery.conf file present. When the ...
    Albe LaurenzAlbe Laurenz
    Nov 20, 2007 at 2:20 pm
    Mar 17, 2008 at 10:25 pm
  • I have updated the patches queue with open 8.3 items: http://momjian.postgresql.org/cgi-bin/pgpatches FYI, I worked with a Borland CC user offlist and 8.3 CVS now compiles cleanly for him. -- Bruce ...
    Bruce MomjianBruce Momjian
    Nov 24, 2007 at 8:31 pm
    Nov 25, 2007 at 1:02 pm
  • This patch: http://archives.postgresql.org/pgsql-patches/2007-11/msg00137.php seems simple and useful enough that I think we ought to slip it into 8.3, even though we are far past feature freeze. As ...
    Tom LaneTom Lane
    Nov 14, 2007 at 4:29 pm
    May 7, 2008 at 4:35 am
  • Do we care to maintain a maximum width for programs' --help output (and psql's \?)? I think 79 characters was once a recommendation (or perhaps 72), but we have a couple of violations either way, ...
    Peter EisentrautPeter Eisentraut
    Nov 15, 2007 at 8:58 pm
    Nov 19, 2007 at 9:39 pm
  • _________________________________________________ Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné, nous vous ...
    Nov 27, 2007 at 1:48 pm
    Dec 1, 2007 at 4:37 am
  • There was some discussion in pgsql-performance about the problem that the live-and-dead-tuple counts that ANALYZE reports to the stats collector don't reflect insert-in-progress tuples properly: ...
    Tom LaneTom Lane
    Nov 17, 2007 at 5:27 pm
    Nov 21, 2007 at 6:56 pm
  • Hi All, I've been writing some code[1] to support Javascript in the backend. I've got the basic bits working, the next job for me is implementing SPI support. Currently, it runs simple bits of code ...
    Sam MasonSam Mason
    Nov 16, 2007 at 8:10 am
    Nov 16, 2007 at 5:18 pm
  • Hi, I had a chance to test one of the real world cases with Oracle and PostgreSQL. Create a Table with 10 million rows (i worked on a 1GB RAM machine) both in oracle and Postgresql. Just write a JDBC ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Nov 12, 2007 at 10:21 am
    Nov 12, 2007 at 2:16 pm
  • I noticed this problem in 8.2 and 8.3: pei=# select mod( trunc( 1 ), 2 ); ERROR: 42883: function mod(double precision, integer) does not exist LINE 1: select mod( trunc( 1 ), 2 ); ^ It apparently ...
    Peter EisentrautPeter Eisentraut
    Nov 6, 2007 at 3:33 pm
    Nov 7, 2007 at 6:56 pm
  • Sometime ago there was a discussion about user/database quota and IIRC there was also some patch for this (probably got rejected). Does anyone know to which direction we went for having quotas? ...
    Gevik BabakhaniGevik Babakhani
    Nov 28, 2007 at 8:21 pm
    Dec 11, 2007 at 1:08 pm
  • In an attempt to move us toward 8.3 RC1 I have put all open item emails into the patches queue: http://momjian.postgresql.org/cgi-bin/pgpatches -- Bruce Momjian <bruce@momjian.us http://momjian.us ...
    Bruce MomjianBruce Momjian
    Nov 5, 2007 at 5:47 pm
    Dec 5, 2007 at 8:37 pm
  • I was able to reproduce the problem complained of here http://archives.postgresql.org/pgsql-bugs/2007-11/msg00322.php with this function: create or replace function foo() returns int as $$ declare r ...
    Tom LaneTom Lane
    Nov 29, 2007 at 8:40 pm
    Dec 2, 2007 at 12:33 am
  • OK, so the big question then is if we are un-depricating this data type, does it have the behavior we want? (And the regression addition will be helpful too.) -- Bruce Momjian <bruce@momjian.us ...
    Bruce MomjianBruce Momjian
    Nov 24, 2007 at 7:35 pm
    Nov 27, 2007 at 7:33 am
  • I mentioned in #postgres a bit ago to no avail that I couldn't get my plperl stored procedures to work after upgrading to OS X 10.5, with only a obtuse "ERROR: null prosrc". I was using 8.2.4 and ...
    B. MaustB. Maust
    Nov 21, 2007 at 7:25 am
    Nov 21, 2007 at 9:41 pm
  • Hello I am writing tsearch2 wrapper and I testing functionality. I found some little bit strange on default parser. It can't parse tags with numbers: test=# select * from parse('<h1 zluty kun se ...
    Pavel StehulePavel Stehule
    Nov 6, 2007 at 10:13 pm
    Nov 13, 2007 at 7:42 pm
  • OK, I tried it in fr_FR locale and what I find is that regression=# select '123/' < '1230'::text; ?column? ---------- t (1 row) so make_greater_string() will still think that its first try at ...
    Tom LaneTom Lane
    Nov 8, 2007 at 5:22 pm
    Nov 9, 2007 at 8:57 pm
  • I wanted to give everyone an overview of where we are for 8.3. We have addressed almost every major issue for 8.3 but we are getting a steady stream of minor cleanups. These cleanups are vital to ...
    Bruce MomjianBruce Momjian
    Nov 29, 2007 at 4:26 pm
    Nov 30, 2007 at 12:35 am
  • Hi all, I'm trying to write a trigger that converts integer to bytea. My schema is like this: Create table xx ( id int, .... ... data bytea); the first 3 bytes of data are the binary representation ...
    Nov 29, 2007 at 1:45 pm
    Nov 29, 2007 at 4:55 pm
Group Navigation
period‹ prev | Nov 2007 | next ›
Group Overview
grouppgsql-hackers @

142 users for November 2007

Tom Lane: 264 posts Simon Riggs: 77 posts Bruce Momjian: 71 posts Gregory Stark: 65 posts Andrew Dunstan: 64 posts Heikki Linnakangas: 52 posts Peter Eisentraut: 50 posts Joshua D. Drake: 46 posts Magnus Hagander: 43 posts Alvaro Herrera: 41 posts Gokulakannan Somasundaram: 34 posts Guillaume Smet: 32 posts Pavel Stehule: 26 posts Zdenek Kotala: 20 posts Brendan Jurd: 19 posts Dave Page: 19 posts Martijn van Oosterhout: 17 posts Alvaro Herrera: 16 posts Ohp: 15 posts Gevik Babakhani: 15 posts
show more