FAQ

Search Discussions

152 discussions - 1,059 posts

  • Hi, I'd like to know if there are any plans on introducing bitmap indexes into postgresql. I think this could mean a big performance improvement especially for datawarehousing applications. I know ...
    Yann MichelYann Michel
    Oct 7, 2004 at 7:55 pm
    Nov 4, 2004 at 4:19 pm
  • This seems fairly impractical, at least for indexes where there is no way to do the ALTER before the object is filled with data. Hmm, here's a variant idea: how about a GUC variable named something ...
    Tom LaneTom Lane
    Oct 18, 2004 at 4:27 pm
    Nov 6, 2004 at 7:37 pm
  • I've made a partial implementation of a datatype "timestamp with time zone" as described in the sql standard. The current type "timestamptz" does not store the time zone as a standard one should do. ...
    Dennis BjorklundDennis Bjorklund
    Oct 21, 2004 at 11:23 am
    Jun 5, 2005 at 12:20 am
  • I've been using the ARC debug options to analyse memory usage on the PostgreSQL 8.0 server. This is a precursor to more complex performance analysis work on the OSDL test suite. I've simplified some ...
    Simon RiggsSimon Riggs
    Oct 22, 2004 at 6:52 pm
    Nov 1, 2004 at 10:06 pm
  • I've got the CREATE TABLE AS restructuring almost finished, but came across something that I could use some advice on. The current code stores the "into" relation (and whether or not that relation ...
    Neil ConwayNeil Conway
    Oct 18, 2004 at 6:41 am
    Nov 14, 2004 at 11:42 pm
  • I have annotated the open items: --------------------------------------------------------------------------- PostgreSQL 8.0 Open Items ========================= Current version at ...
    Bruce MomjianBruce Momjian
    Oct 17, 2004 at 7:07 pm
    Dec 2, 2004 at 11:54 pm
  • It has just been brought to my attention that we are being very restrictive about what we allow to be done in trusted plperl. Basically we allow the :default and :base_math set of operations (run ...
    Andrew DunstanAndrew Dunstan
    Oct 14, 2004 at 7:10 pm
    Dec 2, 2004 at 8:09 pm
  • Houston, we have a problem. Shown below is an extract from the traces of make installcheck in contrib. It is decorated with some extra traces I built into src/port/dirmod.c::rmtree(). It shows quite ...
    Andrew DunstanAndrew Dunstan
    Oct 25, 2004 at 3:32 pm
    Oct 27, 2004 at 4:00 pm
  • I have a long term plan to implement charset support in pg and now when I have dropped the work on the timestamps, I've been looking into this subject. Today we store the max length of a string in ...
    Dennis BjorklundDennis Bjorklund
    Oct 30, 2004 at 5:36 pm
    Oct 31, 2004 at 9:46 am
  • Hi every one, I need help to debug the problem I have on Unixware 714 and beta3. postgresql make check hangs on plpgsql test when compiled with --enable-thread-safty. It does hang on select ...
    OhpOhp
    Oct 22, 2004 at 4:20 pm
    Oct 29, 2004 at 1:21 pm
  • I think we are getting closer to a final release. I haven't seen many _major_ failures in a few weeks, and the open items list is shrinking. I would like us to make a concentrated effort to address ...
    Bruce MomjianBruce Momjian
    Oct 16, 2004 at 3:38 am
    Oct 18, 2004 at 7:40 pm
  • I'm trying to change the Makefile system for PL/Java so that it uses PGXS instead of compiling using a complete PostgreSQL source tree. As it turns out, the directory "include/port/win32" is not ...
    Thomas HallgrenThomas Hallgren
    Oct 30, 2004 at 8:23 pm
    Nov 28, 2004 at 3:33 am
  • Hi, I'm getting this error on two different servers, one if them is the server that I build PostgreSQL from CVS daily, the other one is a fresh one (used to double-check the error) Two servers have ...
    Devrim GündüzDevrim Gündüz
    Oct 31, 2004 at 10:48 am
    Nov 1, 2004 at 5:20 pm
  • Having seen a couple recent reports of "could not access status of transaction" for old, not-obviously-corrupt transaction numbers, I went looking to see if I could find a way that the system could ...
    Tom LaneTom Lane
    Oct 13, 2004 at 4:18 pm
    Oct 19, 2004 at 1:02 pm
  • Hi guys, For the latest few weeks Neil and I have been discussing unit testing as a means of testing Postgres more rigorously. A brief overview of the ideas behind unit testing can be found here: ...
    Gavin SherryGavin Sherry
    Oct 11, 2004 at 11:36 am
    Oct 12, 2004 at 1:07 am
  • On looking more closely, I think that all of these functions are mislabeled: oid | prorettype | prosrc | provolatile should be stable not immutable: date_trunc(text,timestamptz) | timestamptz | ...
    Tom LaneTom Lane
    Oct 1, 2004 at 10:53 pm
    Oct 3, 2004 at 10:37 pm
  • Folks, Is there any reason that we don't have pg_functions, pg_users, pg_groups and other system views? pg_tables and pg_views is really useful, but it would be good to cover the other items as well. ...
    Josh BerkusJosh Berkus
    Oct 28, 2004 at 9:33 pm
    Jun 7, 2005 at 6:30 pm
  • Hmm. What's going on here is that the stored default expression is actually of the form ('TODO'::varchar)::varchar(2) where you don't see the coercion to varchar(2) in \d becayuse ruleutils.c doesn't ...
    Tom LaneTom Lane
    Oct 20, 2004 at 6:07 pm
    Oct 24, 2004 at 11:50 pm
  • Hi everyone, I think I'll be taking some time off from the PostgreSQL project, to work on other stuff that has my interest more at the moment :) I'll still be lurking around, but I won't really have ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 18, 2004 at 7:22 am
    Oct 24, 2004 at 3:21 am
  • What kind of security restrictions do we want for prepared transactions? Who has the right to finish a transaction that was started by user A? At least the original user, I suppose, but who else? ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 13, 2004 at 3:13 pm
    Oct 14, 2004 at 5:22 am
  • Here http://www.sans.org/top20/#u9 are listed postgres vulnerability it's sad see that almost all are related to third part components Regards Gaetano Mendola
    Gaetano MendolaGaetano Mendola
    Oct 9, 2004 at 7:50 pm
    Oct 12, 2004 at 4:46 pm
  • In prior versions of Postgres, it has never been possible to remotely find out the data directory location being used by the postmaster (at least not without hacking some C code, which only ...
    Tom LaneTom Lane
    Oct 8, 2004 at 2:09 am
    Oct 9, 2004 at 11:13 pm
  • just wondering: test= select version(); version ------------------------------------------------------------------------------------------ PostgreSQL 8.0.0beta4 on i686-pc-linux-gnu, compiled by GCC ...
    Ian BarwickIan Barwick
    Oct 26, 2004 at 7:19 pm
    Oct 31, 2004 at 8:20 am
  • http://secunia.com/advisories/12860/
    Rod TaylorRod Taylor
    Oct 19, 2004 at 8:19 pm
    Oct 26, 2004 at 2:58 pm
  • As has previously been pointed out, the strings marked up for gettext translation in the pgport library don't work and need to be moved back to where they once came from, unless someone wants to add ...
    Peter EisentrautPeter Eisentraut
    Oct 18, 2004 at 2:32 pm
    Nov 2, 2004 at 3:36 am
  • Hello, For 8.0 are we going to allow group modifications to the data directories for PostgreSQL? It is kind of silly that it must be 700. I think we should allow at least 770. This allows you to have ...
    Joshua D. DrakeJoshua D. Drake
    Oct 12, 2004 at 6:51 pm
    Oct 12, 2004 at 9:59 pm
  • Hi Was already implemented the timeout on the "SELECT ... FOR UPDATE" (non-blocking lock) and/or is possible known if the lock exist on the specified ROW before executing the SELECT? Please note: ...
    RonzoRonzo
    Oct 21, 2004 at 10:45 am
    Dec 2, 2004 at 4:40 am
  • I'd like to set up a BOF with any of the developers who are interested in Boston at the Linux World Expo coming up at the end of February. I don't have anything specific in mind and would like to get ...
    Mark WongMark Wong
    Oct 7, 2004 at 6:24 pm
    Oct 7, 2004 at 10:53 pm
  • psql's slash commands for schemas seem a little weird to me. For example: neilc=# \d nonexistent Did not find any relation named "nonexistent". neilc=# \dt nonexistent No matching relations found. ...
    Neil ConwayNeil Conway
    Oct 29, 2004 at 1:55 am
    Dec 2, 2004 at 6:14 pm
  • I'd like to provide a way for DBAs to specify that the temporary files needed to for sorting, holdable cursors and similar operations should be created in a particular tablespace. (Right now these ...
    Neil ConwayNeil Conway
    Oct 29, 2004 at 5:51 am
    Nov 3, 2004 at 10:20 pm
  • People: Having today spent 3.5 hours correcting a pg_dump file with permissions problems, I've come to the inescapable realization that the "SESSION AUTHORIZATION" concept is WAY too fragile. ...
    Josh BerkusJosh Berkus
    Oct 23, 2004 at 11:57 pm
    Oct 24, 2004 at 4:40 pm
  • Dear Sirs, I would like to know if there are any discussions about creating an embedded version on postgresql. My thoughts go towards building/porting a sqlite equivalent of pg. Regards, GB.
    GevikGevik
    Oct 14, 2004 at 7:49 am
    Oct 20, 2004 at 3:37 pm
  • What do people think about using (sizeof(struct passwd) + BUFLEN/2) rather than BUFLEN for the getpwuid_r size, or (sizeof(struct passwd) + MAXPGPATH*2)? That would reduce the stack requirements and ...
    Bruce MomjianBruce Momjian
    Oct 9, 2004 at 4:14 am
    Oct 14, 2004 at 10:56 pm
  • The Linux fsync man page says: "It does not necessarily ensure that the entry in the directory containing the file has also reached disk. For that an explicit fsync on the file descriptor of the ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 31, 2004 at 11:19 am
    Oct 31, 2004 at 6:20 pm
  • I have an idea for a change to the contributed module pg_autovacuum that I would like to run by people. What I want to do is make sure that when vacuum (or analyze) runs that it takes no time from ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Oct 22, 2004 at 3:53 pm
    Oct 22, 2004 at 8:54 pm
  • Hello, While reviewing PostgreSQL 8's SQL:2003 conformance (see the documentation mailing list), I've come across a - possibly - easy-to-implement conformance improvement for CREATE FUNCTION: ...
    Troels ArvinTroels Arvin
    Oct 17, 2004 at 9:56 pm
    Oct 19, 2004 at 10:31 pm
  • Currently, the assembly for TAS() on x86 does a non-locking test before using an atomic operation to attempt to acquire the spinlock: __asm__ __volatile__( " cmpb $0,%1 \n" " jne 1f \n" " lock \n" " ...
    Neil ConwayNeil Conway
    Oct 17, 2004 at 1:17 pm
    Oct 19, 2004 at 4:02 pm
  • Recent versions of GCC support some additional warning flags that I think would be useful to enable for building PostgreSQL: -Wmissing-declarations ("Warn if a global function is defined without a ...
    Neil ConwayNeil Conway
    Oct 17, 2004 at 12:22 pm
    Oct 18, 2004 at 2:34 pm
  • Hi, I'm trying to add a -project specific- networking feature to my postgres build (or database as function). What I want to do is to send a Query instance (as a String-retrieved through an SPI ...
    Katsaros Kwn/nosKatsaros Kwn/nos
    Oct 14, 2004 at 7:54 am
    Oct 16, 2004 at 4:48 pm
  • pgsql-server renamed to pgsql contrib/earthdistance moved back into pgsql/contrib/earthdistance modules file updated for changes checkout seems to work fine for me ... let me know if there are any ...
    Marc G. FournierMarc G. Fournier
    Oct 11, 2004 at 1:40 am
    Oct 12, 2004 at 4:37 pm
  • A couple of hours ago things started breaking thus, I assume related to the Makefile changes made around then: ccache gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations ...
    Andrew DunstanAndrew Dunstan
    Oct 10, 2004 at 10:30 pm
    Oct 11, 2004 at 8:54 pm
  • I posted to -sql the other day about an atrociously slow DELETE on a table that has two FKs to a 'parent' table ... if the # of records in the table that match the condition is 1, its fast ... in the ...
    Marc G. FournierMarc G. Fournier
    Oct 10, 2004 at 10:14 pm
    Oct 11, 2004 at 1:48 pm
  • I assume this is to be saved for 8.1. This has been saved for the 8.1 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 ...
    Bruce MomjianBruce Momjian
    Oct 8, 2004 at 3:52 pm
    Oct 9, 2004 at 12:33 am
  • If I correctly remember the issue, if I merge earthdistance back into the main source tree (which is a simple mv operation and cvs update on the modules file), it will potentially break everyone's ...
    Marc G. FournierMarc G. Fournier
    Oct 4, 2004 at 4:38 pm
    Oct 4, 2004 at 6:26 pm
  • pg_get_serial_sequence() does dequoting/downcasing on its relation-name argument, but not on its column-name argument. regression=# create table "FOO" ("Ff1" serial); NOTICE: CREATE TABLE will create ...
    Tom LaneTom Lane
    Oct 28, 2004 at 5:13 am
    Nov 27, 2004 at 6:12 am
  • Greets, Would it be possible to get something along the lines of the attached patch in 8? (major,minor,patch,state version defines) (I tried making them shell vars and giving it to AC_INIT, but it ...
    James William PyeJames William Pye
    Oct 31, 2004 at 2:04 pm
    Nov 1, 2004 at 1:25 am
  • The Slony-I team is proud to present the 1.0.4 release of the most advanced replication solution for the most advanced Open Source Database in the world. The release tarball is available for download ...
    Chris BrowneChris Browne
    Oct 21, 2004 at 10:21 pm
    Oct 23, 2004 at 2:20 am
  • Hi all, I've been giving a shot to beta3 since yesterday. make check produces a hang when testing the 14 parallel tests (limit...) at that point, no tests ever returns, one postmaster is 100% cpu ...
    OhpOhp
    Oct 9, 2004 at 2:13 pm
    Oct 10, 2004 at 6:27 pm
  • Hi, I saw a initdb crashes when it is creating the template1 database. I couldn't figure out what is wrong. I attached the backtrace and some architecture/compiler info. If someone needs more info, ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Oct 7, 2004 at 1:45 am
    Oct 8, 2004 at 7:53 pm
  • This case in xlog.c is representative of a disease that pgindent has had for awhile: @@ -4276,7 +4300,8 @@ StartupXLOG(void) if (needNewTimeLine) /* stopped because of stop request */ ereport(FATAL, ...
    Tom LaneTom Lane
    Oct 6, 2004 at 10:06 pm
    Oct 7, 2004 at 2:17 pm
Group Navigation
period‹ prev | Oct 2004 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions152
posts1,059
users131
websitepostgresql.org...
irc#postgresql

131 users for October 2004

Tom Lane: 229 posts Bruce Momjian: 108 posts Andrew Dunstan: 56 posts Reini Urban: 34 posts Josh Berkus: 33 posts Dennis Bjorklund: 31 posts Gavin Sherry: 31 posts Neil Conway: 29 posts Greg Stark: 23 posts Simon Riggs: 21 posts Peter Eisentraut: 20 posts Marc G. Fournier: 19 posts Alvaro Herrera Munoz: 18 posts Gaetano Mendola: 16 posts Magnus Hagander: 13 posts Dave Page: 12 posts Heikki Linnakangas: 12 posts Tatsuo Ishii: 12 posts Ohp: 11 posts Chris Browne: 11 posts
show more
Archives