FAQ

Search Discussions

195 discussions - 1,449 posts

  • Is it my imagination, or is there a problem with the way pg_dump uses off_t etc. My understanding is that off_t may be 64 bits on systems with 32 bit ints. But it looks like pg_dump writes them as 4 ...
    Philip WarnerPhilip Warner
    Oct 1, 2002 at 12:13 pm
    Nov 4, 2002 at 10:38 pm
  • We are putting out beta3 today or tomorrow. It seems we are ready to start considering an RC1 date, perhaps next Friday, November 1? ...
    Bruce MomjianBruce Momjian
    Oct 25, 2002 at 8:18 pm
    Nov 7, 2002 at 1:37 pm
  • Did anybody think about threaded sorting so far? Assume an SMP machine. In the case of building an index or in the case of sorting a lot of data there is just one backend working. Therefore just one ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Oct 4, 2002 at 7:40 am
    Oct 7, 2002 at 6:29 pm
  • ----- Forwarded message from Bruce Momjian <pgman@candle.pha.pa.us ----- I don't know. Would you ask hackers list, and perhaps CC the author of that patch. ...
    Denis A UstimenkoDenis A Ustimenko
    Oct 14, 2002 at 3:32 am
    Oct 16, 2002 at 3:05 pm
  • g'day ... just went through the new config files for v7.3, to make sure, but it doens't look like we have such ... has anyone looked at adding a 'idle timeout' for a postgres process? Or am I missing ...
    Marc G. FournierMarc G. Fournier
    Oct 25, 2002 at 3:00 am
    Oct 29, 2002 at 10:13 am
  • Hi, Today we concluded test for database performance. Attached are results and the schema, for those who have missed earlier discussion on this. We have (almost) decided that we will partition the ...
    Shridhar DaithankarShridhar Daithankar
    Oct 3, 2002 at 12:35 pm
    Oct 12, 2002 at 6:40 am
  • Is there any plans to make postgresql multithreading? Thanks in advance (and also for all who commented to my question regarding replication.) Anuradha NB: please don't open fire to declare war on ...
    Anuradha RatnaweeraAnuradha Ratnaweera
    Oct 16, 2002 at 4:57 am
    Nov 5, 2002 at 10:11 pm
  • Oh? That would be a serious problem, but I've never heard that asserted before. Please provide some evidence. On a filesystem that does have that kind of problem, can't you avoid it just by using ...
    Tom LaneTom Lane
    Oct 4, 2002 at 8:45 pm
    Oct 7, 2002 at 8:42 am
  • Hi All, I wrote a Matlab interface to PostgreSQL based on libpq. It is working fine, supports multiple connections, supports all data types and arrays. It is a C program to do the interface and some ...
    Pedro Miguel Frazao Fernandes FerreiraPedro Miguel Frazao Fernandes Ferreira
    Oct 29, 2002 at 11:40 am
    Nov 8, 2002 at 4:27 am
  • There are a number of statements, such as TRUNCATE TABLE, that refuse to run in a transaction block because they perform actions that can't be rolled back later. These statements currently do not ...
    Tom LaneTom Lane
    Oct 19, 2002 at 1:04 am
    Oct 22, 2002 at 4:51 pm
  • I do not think the situation for ganging of multiple commit-record writes is quite as dire as has been painted. There is a simple error in the current code that is easily corrected: in XLogFlush(), ...
    Tom LaneTom Lane
    Oct 6, 2002 at 12:16 am
    Oct 18, 2002 at 2:00 pm
  • Barry, Is it true ? I create table with one column varchar(500) and enter 1 milion rows with length 10-20 character.JDBC query 'select * from a' get error 'out of memory', but psql not. I insert 8 ...
    SnpeSnpe
    Oct 11, 2002 at 12:06 pm
    Oct 16, 2002 at 12:15 pm
  • Let me add to what I just said: While the above idea doesn't win for normal operation, because each backend waits for the fsync, and we have no good way of determining of other backends are nearing ...
    Bruce MomjianBruce Momjian
    Oct 5, 2002 at 12:01 pm
    Oct 8, 2002 at 2:55 pm
  • You all know this FAQ: "Why does Postgres not use my index?" Half of the time this problem can easily be solved by casting a literal to the type of the respective column; this is not my topic here. ...
    Manfred KoizarManfred Koizar
    Oct 2, 2002 at 7:50 pm
    Aug 20, 2003 at 5:56 pm
  • Hi everyone, Have just put together a prototype page to show off the multi-lingual capabilities that the Advocacy sites' infrastructure has: http://advocacy.postgresql.org/?lang=de The text was ...
    Justin CliftJustin Clift
    Oct 2, 2002 at 10:53 pm
    Oct 15, 2002 at 2:47 pm
  • [ Thread moved to hackers.] OK, I have enough information from the various other databases to make a proposal. It seems the other databases, particularly Oracle, record CURRENT_TIMESTAMP as the time ...
    Bruce MomjianBruce Momjian
    Oct 3, 2002 at 8:18 pm
    Oct 7, 2002 at 5:13 am
  • As of current CVS, PL/Perl doesn't seem to compile against Perl 5.8. I get the following compile error: gcc -O2 -g -fpic -I. -I/usr/lib/perl/5.8.0/CORE -I../../../src/include -c -o plperl.o plperl.c ...
    Neil ConwayNeil Conway
    Oct 17, 2002 at 2:41 am
    Nov 7, 2002 at 7:54 pm
  • Just to update the list of supported platforms, 7.3b3 compiles and passes all the regression tests on MacOSX 10.2.1 Although don't know if this is relevant but this appears when running the tests: ...
    Adam WitneyAdam Witney
    Oct 28, 2002 at 12:34 pm
    Nov 1, 2002 at 10:59 pm
  • I've started playing a little with Postgres to determine if there were memory leaks running around. After some very brief checking, I'm starting[1] to think that the answer is yes. Has anyone already ...
    Greg CopelandGreg Copeland
    Oct 22, 2002 at 9:16 pm
    Oct 29, 2002 at 11:09 am
  • Looks good from my end, Peter, I pulled the same docs that I pulled for v7.2.2, which I hope is okay?
    Marc G. FournierMarc G. Fournier
    Oct 3, 2002 at 12:45 am
    Oct 8, 2002 at 9:37 pm
  • Hi all, I am trying to add some replication features to postgres (yes, I have already looked at ongoing work), in a peer to peer manner. The goal is to achive `nearly complete fault tolerence' by ...
    Anuradha RatnaweeraAnuradha Ratnaweera
    Oct 11, 2002 at 10:17 am
    Oct 14, 2002 at 6:05 am
  • OK, we are down to one open item, related to pg_dumping on 64-bit off_t. We had discussion today on this so it should be completed shortly. ...
    Bruce MomjianBruce Momjian
    Oct 21, 2002 at 11:18 pm
    Nov 24, 2002 at 9:56 pm
  • OK, I went and tested this and I found that default expressions (at least nextval) are executed with the permissions of the user doing the insert and not the owner of the table. I would like to ...
    Bruno Wolff IIIBruno Wolff III
    Oct 30, 2002 at 7:54 pm
    Nov 5, 2002 at 10:35 pm
  • ERROR: RelationClearRelation: relation 11584078 deleted while still in use I've been unable to come up with a test case that will cause the problem, seems to be timing related. The queries that are ...
    Rod TaylorRod Taylor
    Oct 30, 2002 at 8:14 pm
    Nov 2, 2002 at 5:42 am
  • First of all PREPARE/EXECUTE is a wonderful thing to speed up things significantly. I wonder if there is a way to store a parsed/rewritten/planned query in a table so that it can be loaded again. ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Oct 23, 2002 at 2:16 pm
    Oct 25, 2002 at 3:04 am
  • Could anyone please tell me if we found a solution? It seems I missed any discussion or whatsoever. The only things I know is that postgresql.org still has bison 1.35 installed and 7.3 release is ...
    Michael MeskesMichael Meskes
    Oct 18, 2002 at 3:45 pm
    Oct 21, 2002 at 2:42 pm
  • The Internet Society (ISOC) won the bid to replace Verisign as the .org registry. They're going to subcontract to Afilias, who has been running the .info registry. See: ...
    David De GraffDavid De Graff
    Oct 14, 2002 at 7:43 pm
    Oct 16, 2002 at 7:44 pm
  • Is there any way to prevent superuser to acces the database ? I mean something like "GRANT / REVOKE CONNECT" MECHANISM I have no idea how to prevent root from access data in one of this ways : root @ ...
    Igor GeorgievIgor Georgiev
    Oct 22, 2002 at 2:05 pm
    Oct 25, 2002 at 12:57 pm
  • Hello to all the Doers of Postgres!!! Last time I went through forums, people spoke highly about 7.3 and its capability to do hot backups. My problem is if the database goes down and I lose my main ...
    Sandeep ChadhaSandeep Chadha
    Oct 7, 2002 at 5:21 pm
    Oct 24, 2002 at 9:15 pm
  • I thought this was worked on for 7.3? I remember speaking to someone (?) at OSCON because I had been working on 'ENABLE TRIGGER <trigname ' and is compliment on the plane. Much of the work seemed to ...
    Gavin SherryGavin Sherry
    Oct 13, 2002 at 5:45 am
    Dec 9, 2002 at 9:57 am
  • Hi all, Without modifying anything, postgresql (since today) has a strange behavior: All connections are rejected with No space left on device. There's plenty of space in shm, disk... It occurs on ...
    Olivier PRENANTOlivier PRENANT
    Oct 21, 2002 at 1:46 pm
    Oct 21, 2002 at 5:59 pm
  • I think we should move /contrib/retep to gborg. It is 400k and isn't anywhere near our core functionality. I will add to TODO: Move /contrib/retep to gborg Can I move this during beta? I don't think ...
    Bruce MomjianBruce Momjian
    Oct 19, 2002 at 2:30 am
    Oct 21, 2002 at 12:36 am
  • I just noticed that rewriteHandler.c contains a subroutine orderRules() that reorders the rules for a relation into the order non-instead rules qualified instead rules unqualified instead rules This ...
    Tom LaneTom Lane
    Oct 14, 2002 at 7:13 pm
    Oct 18, 2002 at 3:38 am
  • Hi all, I'm thinking that there is an improvement to vacuum which could be made for 7.4. VACUUM FULLing large, heavily updated tables is a pain. There's very little an application can do to minimise ...
    Gavin SherryGavin Sherry
    Oct 16, 2002 at 12:22 am
    Oct 16, 2002 at 5:23 pm
  • I did some research on this. It turns out the parser uses 0 for ALL, so when you do a FETCH ALL it is passing zero. Now, when you do MOVE 0, you are really asking for FETCH ALL and all the tuples are ...
    Bruce MomjianBruce Momjian
    Oct 30, 2002 at 5:04 am
    Nov 3, 2002 at 1:21 am
  • wow=# select 5.3::float; ERROR: Bad float8 input format '5.3' wow=# select 5.3::float8; ERROR: Bad float8 input format '5.3' wow=# select 5.3::float4; ERROR: Bad float4 input format '5.3' wow=# ...
    Teodor SigaevTeodor Sigaev
    Oct 17, 2002 at 6:34 pm
    Oct 19, 2002 at 7:37 am
  • Any news about new DBD::Pg ? It's a stopper for many projects based on perl interface to use 7.3. Regards, Oleg Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical ...
    Oleg BartunovOleg Bartunov
    Oct 2, 2002 at 5:17 pm
    Oct 31, 2002 at 7:06 pm
  • Hi, I am not subscribed (and I would prefer to continue read the list through web interface only). Does the developers team follow the http://developer.postgresql.org/regress/report.php ? May be it's ...
    Vladimir ChukharevVladimir Chukharev
    Oct 29, 2002 at 8:46 am
    Oct 30, 2002 at 6:50 am
  • All, I'd like to help work on some 7.4 features, however, since you've not seen my name before, I'm obviously new to the list and the org. I really like working on speed optimizations and rewrites. I ...
    Curtis FaithCurtis Faith
    Oct 2, 2002 at 8:13 pm
    Oct 4, 2002 at 5:26 am
  • Hi all, Over the last few weeks we've put together a new "Advocacy and Marketing" website for PostgreSQL: http://advocacy.postgresql.org It's now ready for public release. It has the first few case ...
    Justin CliftJustin Clift
    Oct 2, 2002 at 12:34 am
    Oct 2, 2002 at 2:02 pm
  • I'm looking at different ways of optimizing queries with a large number of joins. I write the same query in a number of different ways and compare the running times. Now the problem is I do not want ...
    Ben McMahanBen McMahan
    Oct 24, 2002 at 8:09 pm
    Oct 31, 2002 at 6:34 pm
  • Regression Diffs: *** ./expected/geometry-positive-zeros-bsd.out Tue Sep 12 16:07:16 2000 --- ./results/geometry.out Mon Oct 28 00:06:41 2002 *************** *** 114,120 **** *************** *** ...
    Larry RosenmanLarry Rosenman
    Oct 28, 2002 at 6:09 am
    Oct 29, 2002 at 3:52 am
  • According to the syntax diagram in the documenation, I can write COPY table TO STDOUT WITH BINARY OIDS; Shouldn't the "binary", being an adjective, be attached to something? -- Peter Eisentraut ...
    Peter EisentrautPeter Eisentraut
    Oct 15, 2002 at 6:48 pm
    Oct 18, 2002 at 3:17 am
  • Now that we are changing relfilenode in 7.3, I think we need to rename oid2name to relfilenode2name, and perhaps move it into the main tree. TODO item added: Rename oid2name to relfilenode2name and ...
    Bruce MomjianBruce Momjian
    Oct 12, 2002 at 7:03 pm
    Oct 15, 2002 at 9:35 pm
  • A lot of different things going on but my perl program (whose backend crashed) was doing a lot of insert into table as select * from another table for a lot of different tables. I see triggers ...
    Laurette CisnerosLaurette Cisneros
    Oct 8, 2002 at 11:34 pm
    Oct 14, 2002 at 4:57 pm
  • All, I'm trying to implement row level security using PostgreSQL. I envision having column on each and every table in the database that will contain a discriminating value that determines if a given ...
    Bruce DavidBruce David
    Oct 25, 2002 at 6:38 pm
    Oct 30, 2002 at 5:42 pm
  • Hello! I'm tring to move a database and an application from linux to IRIX and I have some problems getting postgresql to work on IRIX. My problem is that postgres crashes is killed by the kernel ...
    Nicolae MihalacheNicolae Mihalache
    Oct 23, 2002 at 4:04 pm
    Oct 24, 2002 at 8:24 am
  • [ Thread moved to hackers.] Crash reproduced here. My guess is that you are recursing and crashing the backend, which then forces the other backends to reset. I think we need to fix this by either ...
    Bruce MomjianBruce Momjian
    Oct 21, 2002 at 3:53 pm
    Oct 21, 2002 at 6:23 pm
  • 1. Why i do this: I try to migrate a database with a 200 tables from Sybase SQL Anywhere to PostgreSQL, but SQL Anywhere escapes special characters like a HEX values ( like \x0D \x2C ..... ). ...
    Igor GeorgievIgor Georgiev
    Oct 16, 2002 at 4:43 pm
    Oct 17, 2002 at 6:55 pm
  • Hello, i've got this query that's really slow... Figure this: testdb= select now() ; select gid from bs where gid not in ( select x from z2test ); select now(); now ------------------------------- ...
    Magnus Naeslund(f)Magnus Naeslund(f)
    Oct 9, 2002 at 9:34 pm
    Oct 9, 2002 at 10:47 pm
Group Navigation
period‹ prev | Oct 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions195
posts1,449
users159
websitepostgresql.org...
irc#postgresql

159 users for October 2002

Bruce Momjian: 288 posts Tom Lane: 253 posts Greg Copeland: 39 posts Philip Warner: 38 posts Peter Eisentraut: 36 posts Curtis Faith: 35 posts Shridhar Daithankar: 34 posts Larry Rosenman: 33 posts Marc G. Fournier: 33 posts Joe Conway: 27 posts Justin Clift: 26 posts Neil Conway: 23 posts Manfred Koizar: 19 posts Andreas Zeugswetter: 17 posts Hannu Krosing: 17 posts Dave Page: 15 posts Michael Paesold: 15 posts Alvaro Herrera: 14 posts Anuradha Ratnaweera: 14 posts Bruno Wolff III: 14 posts
show more
Archives