Search Discussions

160 discussions - 1,446 posts

  • I have a table with about 16,000,000 rows in it. When I do a: SELECT * FROM <table LIMIT 1; it takes about 10 minutes (thats about how long it takes to do a full sequential scan). I had originally ...
    David BlasbyDavid Blasby
    May 26, 2004 at 9:01 pm
    Jun 13, 2004 at 10:03 pm
  • Dear hackers, I wish to submit a small patch so that server includes and all necessary configuration files could be installed *by default*. The current status is that server includes files are only ...
    Fabien COELHOFabien COELHO
    May 15, 2004 at 2:01 pm
    May 22, 2004 at 9:02 am
  • Win32 is going to need relocatable installs, and Unix packagers have asked for this too. A relocatable install is one where you can do 'gmake install', tar up the directory where you installed it, ...
    Bruce MomjianBruce Momjian
    May 8, 2004 at 6:49 pm
    May 20, 2004 at 3:26 am
  • At the risk of getting my butt kicked again, is there any way we can talk about how to deal with threads on UnixWare and the libpq stuff? Has any other platform come up with a need to look for the ...
    Larry RosenmanLarry Rosenman
    May 12, 2004 at 2:50 pm
    May 13, 2004 at 3:51 pm
  • Hackers, Ok, I've finally coded solutions to most problems regarding nested transactions. This means: - reversing for the lock manager, catcache, relcache, buffer manager, asynchronous notifies, ...
    Alvaro HerreraAlvaro Herrera
    May 26, 2004 at 10:04 pm
    Jun 12, 2004 at 5:55 pm
  • TODO items completed: o -ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT o -ALTER TABLE ADD COLUMN column DEFAULT should fill existing rows with DEFAULT value o -Allow ALTER ...
    Bruce MomjianBruce Momjian
    May 5, 2004 at 2:36 pm
    May 7, 2004 at 11:05 am
  • I have been looking at our use of fixed directory specifications in binaries. Right now we have libdir (dynamic_library_path) predefined in the compile, with a GUC to override it. initdb also needs ...
    Bruce MomjianBruce Momjian
    May 2, 2004 at 11:54 am
    May 19, 2004 at 12:39 am
  • One of the comments I saw over the past few days on how to make things on pgFoundry more visible was to have the commit messages for its projects sent out through pgsql-committers as well ... How ...
    Marc G. FournierMarc G. Fournier
    May 20, 2004 at 5:10 pm
    May 21, 2004 at 5:53 am
  • Now that it looks like tablespaces will become a practical reality, I want to suggest some changes in documented procedure and preferred setup. The reason why I suggest these changes is to enlighten ...
    Mark L. WoodwardMark L. Woodward
    May 26, 2004 at 8:11 pm
    May 28, 2004 at 8:41 pm
  • Hi, I was toying around with idea of converting all the memory related parameters in postgresql.conf to kilobytes for simplicity and uniformity. Attached is a proof of concept patch that converts ...
    Shridhar DaithankarShridhar Daithankar
    May 30, 2004 at 12:50 pm
    Jun 4, 2004 at 2:25 pm
  • Nearing our June 1 feature freeze, we now have patches for all our major outstanding features. Their status is: Win32 - almost done, fsync needed, bug fixes, etc PITR - Simon is away until Sunday and ...
    Bruce MomjianBruce Momjian
    May 27, 2004 at 8:32 pm
    Jun 1, 2004 at 9:31 pm
  • We are seeing occasional long lockouts from out DB. When I do a 'select * from pg_locks', I find that everybody is waiting for pg_listener, and that the lock on pg_listener is currently held by a ...
    Philip WarnerPhilip Warner
    May 3, 2004 at 1:41 am
    May 3, 2004 at 3:41 pm
  • Just so that everyone is aware, we are going to push the freeze date for 7.5 to July 1st. Although we feel that there are enough improvements and features already in place for 7.5, Tom's felt that if ...
    Marc G. FournierMarc G. Fournier
    May 31, 2004 at 6:10 pm
    Jun 6, 2004 at 5:12 am
  • Hackers, I've whacked the subtrans patch enough so that the simple tests (i.e. non concurrent) for tuple visibility work. I can create a table and populate it in subtransactions, rollback or commit ...
    Alvaro HerreraAlvaro Herrera
    May 5, 2004 at 2:33 am
    May 17, 2004 at 2:59 pm
  • Hello pgsql-hackers, Following a recent discussion on the JDBC list (http://archives.postgresql.org/pgsql-jdbc/2004-05/msg00100.php) I'm looking at modifying when unnamed statements received via a v3 ...
    Oliver JowettOliver Jowett
    May 20, 2004 at 3:00 am
    Jun 15, 2004 at 2:23 am
  • Hackers, I'm trying to figure out how to log the subtransaction operations. A simple idea would be to add the committed subxact Xids to the xl_xact_commit and xl_xact_abort structs. However, this ...
    Alvaro HerreraAlvaro Herrera
    May 10, 2004 at 11:13 pm
    May 12, 2004 at 9:20 am
  • Greetings all, We have noticed a way to make a major improvement in Pg's performance on our workload, and I would like to get your thoughts before I go off to work up a patch. The basic problem is ...
    Jeffrey W. BakerJeffrey W. Baker
    May 18, 2004 at 3:32 am
    Jun 9, 2004 at 9:04 pm
  • Hi everybody, 1 .... EXPLAIN SELECT COUNT(*) AS c FROM articletbl WHERE ((mydate BETWEEN '2004-04-24' AND '2004-05-24' ) ) 2 .... EXPLAIN SELECT COUNT(*) AS c FROM articletbl WHERE ((mydate = ...
    Ismail KizirIsmail Kizir
    May 24, 2004 at 4:39 pm
    May 25, 2004 at 10:21 pm
  • I have a table with a tsearch2 index on it. Now, I have all the tsearch2 stuff installed into a 'contrib' schema. I have had to change the default database schema to include the contrib schema as ...
    Christopher Kings-LynneChristopher Kings-Lynne
    May 7, 2004 at 7:14 am
    May 14, 2004 at 2:11 am
  • Hi all, this is the alpha version for the new email data type, is not written as built in type but as plug in, Tome Lane and others drove me in this direction. The type is indexable and provide also ...
    Gaetano MendolaGaetano Mendola
    May 16, 2004 at 5:17 pm
    May 17, 2004 at 8:03 pm
  • Can we add the MERGE command to the TODO list? Is anyone actively examining this issue? And yes, I realize it is not for 7.5. It would be good to be able to say it is on the list for some future ...
    May 8, 2004 at 9:40 pm
    May 14, 2004 at 6:14 pm
  • I'm not really sure what to call this feature, but I have been talking to a potential customer and they need a particular feature and they need to to be very FAST. Take this query: select sum(num) ...
    Mark L. WoodwardMark L. Woodward
    May 28, 2004 at 8:37 pm
    Jun 2, 2004 at 9:08 pm
  • I'm looking at the new timezone support. First I initdb'd without TZ set. So every time I start the server I get LOG: could not recognize system timezone, defaulting to "Etc/GMT-4" HINT: You can ...
    Alvaro HerreraAlvaro Herrera
    May 23, 2004 at 7:53 pm
    May 26, 2004 at 12:47 am
  • Hi guys, A guy on the IRC channel managed to accidentally click the wrong thing in phpPgAdmin and managed to remove superuser privileges from his only superuser. We thought and though but it seems ...
    Christopher Kings-LynneChristopher Kings-Lynne
    May 24, 2004 at 1:54 pm
    May 25, 2004 at 1:38 am
  • Is there any security risk if we enable tcpip_socket by default? We restrict connection from localhost only by default so I think enabling tcpip_socket adds no security risk. Please correct me if I ...
    Tatsuo IshiiTatsuo Ishii
    May 17, 2004 at 4:24 am
    May 18, 2004 at 2:59 am
  • Deepak Bhole of Red Hat asked me about the following situation: regression=# create table test (f1 int); CREATE TABLE regression=# revoke insert,update,delete,references on test from postgres; REVOKE ...
    Tom LaneTom Lane
    May 13, 2004 at 9:02 pm
    May 17, 2004 at 3:37 pm
  • Hackers Are there any default query rewrite rules that kick in, in the absence of any user-defined RULE or VIEW ? Also, is there any place that lists any "interesting" query rewrite that PG does on ...
    Sailesh KrishnamurthySailesh Krishnamurthy
    May 28, 2004 at 12:15 am
    May 28, 2004 at 10:47 pm
  • I get this since Tom's commit. Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    May 23, 2004 at 6:39 am
    May 25, 2004 at 8:49 pm
  • Hackers, I'm stuck trying to figure out how to decrease reference counting for relcache entries at subtransaction abort. Initially I thought I could just drop them all to zero, because a ...
    Alvaro HerreraAlvaro Herrera
    May 13, 2004 at 3:53 am
    May 24, 2004 at 4:16 am
  • Is it feasible or practical to consider adding ALTER DOMAIN TYPE type? (basically following the same rules as ALTER TABLE). I don't mind bringing down all the views before I do this, it would be just ...
    Merlin MoncureMerlin Moncure
    May 6, 2004 at 3:53 pm
    May 20, 2004 at 2:08 am
  • The really horrid hack below fixes for me a MINGW/MSys problem that otherwise occurs inconsistently (fails on different links, and pretends to have succeeded), but reliably (every run at least one ...
    Andrew DunstanAndrew Dunstan
    May 1, 2004 at 3:17 pm
    May 3, 2004 at 9:55 pm
  • I've encountered a situation where I'd like to store some information about the database when I do a pg_dump. For instance, the timestamp of the dump. And some other information that I pull from the ...
    Chris CampbellChris Campbell
    May 28, 2004 at 2:10 am
    Jun 1, 2004 at 8:10 am
  • CVS tip built on Debian unstable, i386, Linux 2.6.5 SMP. gcc 3.3.3 ./configure --with-openssl --with-pam --with-krb5 --with-gnu-ld --with-python --with-perl --with-tcl --with-pgport=5342 ...
    Oliver ElphickOliver Elphick
    May 30, 2004 at 9:53 pm
    Jun 1, 2004 at 1:51 pm
  • Hello, I have discovered a problem with psql 7.3.4 where it does not seem to like statements containing "NATURAL CROSS JOIN". I have a test that I have created that will show the problem. Please have ...
    Jonathan ScottJonathan Scott
    May 7, 2004 at 1:22 am
    May 7, 2004 at 9:34 pm
  • I wish modify COPY command for support of CSV files (dump/load files in CSV format). I think this option is very important from import data from spreedsheet as OpenOffice/calc or M$/excel. I have ...
    Umberto ZappiUmberto Zappi
    May 2, 2004 at 3:03 pm
    May 7, 2004 at 6:34 pm
  • I got tired of reading complaints about how upper/lower don't work with Unicode, so I went and prototyped a solution. The attached code uses the C99-standard functions mbstowcs and wcstombs to ...
    Tom LaneTom Lane
    May 13, 2004 at 2:42 am
    May 19, 2004 at 3:26 pm
  • I am seeing the following failure of initdb in CVS: The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will ...
    Bruce MomjianBruce Momjian
    May 5, 2004 at 5:49 pm
    May 6, 2004 at 2:29 pm
  • I'm using CVS HEAD in a windows environment. I'm trying to start the postmaster using "postmaster -c dynamic_library_path=C:/foo/bar". It starts just fine, then, when I ask it to load a module, an ...
    Thomas HallgrenThomas Hallgren
    May 29, 2004 at 9:51 am
    May 30, 2004 at 3:08 am
  • Against current CVS HEAD: $ ./createuser test Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) n CREATE USER $ ./createdb -O ...
    Oliver JowettOliver Jowett
    May 28, 2004 at 2:09 pm
    May 29, 2004 at 6:16 am
  • I'd like to make a small suggestion that would enable external modules to manage dependencies to PostgreSQL versions. Consider the following code: #if PGSQL_MAJOR_VER 7 || (PGSQL_MAJOR_VER == 7 && ...
    Thomas HallgrenThomas Hallgren
    May 11, 2004 at 7:18 pm
    May 12, 2004 at 12:47 pm
  • Hi all, about you is it ok for you if I write the email built in type ? I know of course that I can do it with a DOMAIN. Regards Gaetano Mendola
    Gaetano MendolaGaetano Mendola
    May 8, 2004 at 12:17 pm
    May 10, 2004 at 11:27 pm
  • Hello, June 1 is pretty close now, so I'm asking about yet another contrib module, pg_trgm which is rather mature and quite useful. Is't worth to put it into 7.5 contrib ? trgm - Trigram matching for ...
    Oleg BartunovOleg Bartunov
    May 28, 2004 at 12:24 pm
    May 31, 2004 at 3:34 pm
  • I've applied the list rewrite patch to CVS HEAD. I've also sent a copy of the patch I applied to the -patches list. Notes: - the tree compiles without warnings and passes the regression tests. I'm ...
    Neil ConwayNeil Conway
    May 26, 2004 at 4:47 am
    May 28, 2004 at 8:40 pm
  • Greets, Is there a way for me to clean up fn_extra in flinfo when the function is not a Set Returning Function(SRF)? I know I can use RegisterExprContextCallback and the RSI's econtext to register a ...
    James William PyeJames William Pye
    May 17, 2004 at 6:58 am
    May 23, 2004 at 12:02 pm
  • Not sure if I like the URLs, myself ... opinions? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
    Marc G. FournierMarc G. Fournier
    May 20, 2004 at 11:02 pm
    May 21, 2004 at 2:36 am
  • Our customer has problems with Pg 7.3.2 on Solaris. There are numerous errors in the app. server log and in the database log, including these: LOG: open of /mnt_c1t2d0s0/<some-path ...
    Michael BrusserMichael Brusser
    May 13, 2004 at 9:31 pm
    May 15, 2004 at 3:31 am
  • We're sort of halfway there on coping with the Turkish-locale i-vs-I problem. I'd like to finish the job for 7.5. What we presently have is that identifier and keyword downcasing is done without ...
    Tom LaneTom Lane
    May 6, 2004 at 1:02 pm
    May 28, 2004 at 7:00 am
  • [ BCC to hackers and advocacy.] Ingres is to be released as open source: http://developers.slashdot.org/article.pl?sid=04/05/25/0043219&mode=nested&tid=126&tid=137&tid=163&tid=185&tid=198 -- Bruce ...
    Bruce MomjianBruce Momjian
    May 25, 2004 at 2:22 am
    May 26, 2004 at 5:05 pm
  • Hi guys, The latest thing we've noticed in the IRC channel and the phpPgAdmin lists is that people want to be able to grant on all objects in a database, etc: grant select on all tables to blah; or ...
    Christopher Kings-LynneChristopher Kings-Lynne
    May 23, 2004 at 7:18 am
    May 24, 2004 at 7:07 am
  • In the current build on the anon cvs server, if I try to \d a table from psql, the backend comes down. I played with the query a bit and discovered any query using '~' operator in the where clause on ...
    Merlin MoncureMerlin Moncure
    May 21, 2004 at 3:28 pm
    May 21, 2004 at 4:53 pm
Group Navigation
period‹ prev | May 2004 | next ›
Group Overview
grouppgsql-hackers @

147 users for May 2004

Tom Lane: 226 posts Bruce Momjian: 171 posts Christopher Kings-Lynne: 76 posts Marc G. Fournier: 69 posts Alvaro Herrera Munoz: 67 posts Andrew Dunstan: 51 posts Gaetano Mendola: 46 posts Mark L. Woodward: 40 posts Greg Stark: 35 posts Fabien COELHO: 28 posts Peter Eisentraut: 28 posts Joshua D. Drake: 22 posts Jan Wieck: 21 posts Larry Rosenman: 21 posts Sdv mailer: 21 posts Neil Conway: 19 posts Tatsuo Ishii: 19 posts Oliver Jowett: 18 posts Magnus Hagander: 17 posts Rod Taylor: 17 posts
show more