Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Zdenek Kotala
Josh Berkus napsal(a): Zdenek, Hmmm ... we're not using the -fast option for the standard PostgreSQL packages. Where did you start using it? Yes, I know. The -fast option generates architecture depending code and it is not possible use in common packages. I found out this option when I

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

2006-09-27 Thread Magnus Hagander
What's bugging me is that 0 and O_EXCL give the same answer, and O_TRUNC and O_TRUNC | O_EXCL give the same answer, This is ok, as (iirc) O_EXCL only has effect in the presence of O_CREAT. snip more explanation Thanks, Claudio! After looking at the code some more, and actually reading

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Heikki Linnakangas
Jim C. Nasby wrote: Do I understand that to mean that you can no longer lazy vacuum a functional index? With the normal B-trees we have now, there's no problem vacuuming a functional index. But it would be a problem with the Block B-tree, because the proposed way of vacuuming a Block B-tree

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Heikki Linnakangas
Jim C. Nasby wrote: Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do that anyway right now? You mean _index_ tuples marked dead? Sure, no problem there. Granted, you'd want to periodically ensure that you scan the entire index, but that shouldn't be horribly hard to set

Re: [HACKERS] Constant changes (Re-Build)

2006-09-27 Thread Heikki Linnakangas
luis garcia wrote: Hi I'm a student from Valencia-Venezuela and I'm working with some other friends to make PostgreSQL allows the definition of Temporal Databases and their respective Selection, Insertion and some other functions needed to treat this paradigm (all based in TSQL2 Query

Re: [HACKERS] jar in repository

2006-09-27 Thread Markus Schaber
Hi, Strk, strk wrote: Markus, I noticed we have a .jar file in the repository. Why is that ? Can't we build it from sources with free software tools ? It was a mistake when chekcing in the EJB3 code. It's just a copy of the normal postgis.jar that's needed to compile the EJB3 code, it was

Re: [HACKERS] Developer's Wiki

2006-09-27 Thread Lukas Kahwe Smith
Dave Page wrote: I have now moved the wiki installation to: http://developer.postgresql.org/ BTW: I am wondering if there is an RSS feed of the changes? On my wiki I have an RSS feed for every page, subwiki (aka area) and the entire wiki people can subscribe to:

Re: [HACKERS] Developer's Wiki

2006-09-27 Thread Jeremy Drake
On Wed, 27 Sep 2006, Lukas Kahwe Smith wrote: Dave Page wrote: I have now moved the wiki installation to: http://developer.postgresql.org/ BTW: I am wondering if there is an RSS feed of the changes? On my wiki I have an RSS feed for every page, subwiki (aka area) and the entire wiki

Re: [HACKERS] Developer's Wiki

2006-09-27 Thread Magnus Hagander
I have now moved the wiki installation to: http://developer.postgresql.org/ BTW: I am wondering if there is an RSS feed of the changes? There is. http://developer.postgresql.org/index.php?title=Special:Recentchangesfe ed=rss //Magnus ---(end of

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

2006-09-27 Thread Claudio Natoli
Magnus Hagander writes: Now, I still twist my head around the lines: if ((fd = _open_osfhandle((long) h, fileFlags O_APPEND)) 0 || (fileFlags (O_TEXT | O_BINARY) (_setmode(fd, fileFlags (O_TEXT | O_BINARY)) 0))) With the _setmode() call deep in the if

Ignore that mail (was: [HACKERS] jar in repository)

2006-09-27 Thread Markus Schaber
Hi, Markus Schaber wrote: [something about a postgis.jar] Please ignore that mail, it got to the wrong list. Thanks, Markus -- Markus Schaber | Logical TrackingTracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Bruce Momjian
Heikki Linnakangas wrote: Jim C. Nasby wrote: Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do that anyway right now? You mean _index_ tuples marked dead? Sure, no problem there. Granted, you'd want to periodically ensure that you scan the entire index, but that

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Heikki Linnakangas
Bruce Momjian wrote: Heikki Linnakangas wrote: Jim C. Nasby wrote: Granted, you'd want to periodically ensure that you scan the entire index, but that shouldn't be horribly hard to set up. Well, it seems to be. A vacuum can't evaluate index expressions because it's not in a real transaction.

Re: [HACKERS] Cross-table statistics idea

2006-09-27 Thread Simon Riggs
On Tue, 2006-09-26 at 21:27 -0500, Jim C. Nasby wrote: Since I don't recall any ideas ever having been thrown out on how to do this... ISTM that we could gain additional insight on how many rows would likely result from a join One thing we can do is to use cross-column relationships to

Re: [HACKERS] Faster StrNCpy

2006-09-27 Thread Strong, David
Tom, Let us know when you've added strlcpy () and we'll be happy to run some tests on the new code. David From: [EMAIL PROTECTED] on behalf of Tom Lane Sent: Tue 9/26/2006 7:25 PM To: josh@agliodbs.com Cc: pgsql-hackers@postgresql.org; Neil Conway; Martijn

Re: [HACKERS] Please to technical check of upcoming release

2006-09-27 Thread Chris Mair
http://pgfoundry.org/docman/view.php/147/233/release82.zip is a zip file of a draft of the PostgreSQL 8.2 release and accompanying press kit. Please check if the technical details are correct, and get back to me with any corrections by Thursday. Hi :) I still see Theo Scholossenagle

Re: [HACKERS] Faster StrNCpy

2006-09-27 Thread Andrew Dunstan
Tom Lane wrote: Josh Berkus josh@agliodbs.com writes: What I'd like to do immediately is put in strlcpy() and hit the two or three places I think are performance-relevant. Immediately? Presumably you mean for 8.3? No, I mean now. This is a performance bug and it's still

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Zdenek Kotala
Andrew Dunstan napsal(a): Tom Lane wrote: Zdenek Kotala [EMAIL PROTECTED] writes: But the question is if the -fast flag is good for postgres. The -fast flag sets brutal floating point optimization and some operation should have less precision. Is possible verify that floating point

Re: [HACKERS] Faster StrNCpy

2006-09-27 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: What I'd like to do immediately is put in strlcpy() and hit the two or three places I think are performance-relevant. What are the other hotspots? The ones I can think of offhand are set_ps_display and use of strncpy as a HashCopyFunc.

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Tom Lane
Zdenek Kotala [EMAIL PROTECTED] writes: The problem was generated, because -fast option was set only for the compiler and not for the linker. Linker takes wrong version of libraries. If -fast is set for both then horology test is OK, but question was if float optimalization should

Re: [HACKERS] Buildfarm alarms

2006-09-27 Thread Andrew Dunstan
I wrote: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: It could certainly be done. In general, I have generally taken the view that owners have the responsibility for monitoring their own machines. Sure, but providing them tools to do that seems within buildfarm's

Re: [HACKERS] Faster StrNCpy

2006-09-27 Thread Strong, David
We sometimes see TupleDescInitEntry () taking high CPU times via OProfile. This does include, amongst a lot of other code, a call to namestrcpy () which in turn calls StrNCpy (). Perhaps this is not a good candidate right now as a name string is only 64 bytes. David

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Tom Lane
Heikki Linnakangas [EMAIL PROTECTED] writes: AFAICS, we could disable the optimization and use a full-blown transaction when vacuuming a table with a functional block index. No, we couldn't, or at least it's not merely a matter of reversing a recent optimization. The fundamental issue with

Re: [HACKERS] Buildfarm alarms

2006-09-27 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Dunstan Sent: 27 September 2006 14:56 To: [EMAIL PROTECTED] Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Buildfarm alarms If some intrepid buildfarm owner wants to test this

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Zdenek Kotala
Tom Lane napsal(a): Zdenek Kotala [EMAIL PROTECTED] writes: The problem was generated, because -fast option was set only for the compiler and not for the linker. Linker takes wrong version of libraries. If -fast is set for both then horology test is OK, but question was if float

[HACKERS] psql service parameter

2006-09-27 Thread Andrew Dunstan
I have just noticed that there does not seem to be a psql command line switch to specify a pg_service.conf name to connect to. I know we can use a PGSERVICE environment setting instead, but I think we should have a command line switch too. Small 8.3 TODO item? cheers andrew

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Heikki Linnakangas [EMAIL PROTECTED] writes: Also, now that we have concurrent CREATE INDEX, we could implement concurrent REINDEX as well, I believe. That's probably more easily said than done --- in particular, I don't understand what the committed

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: That's probably more easily said than done --- in particular, I don't understand what the committed state after the first transaction would look like. I think you build a whole new index named something like

Re: [HACKERS] psql service parameter

2006-09-27 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: I have just noticed that there does not seem to be a psql command line switch to specify a pg_service.conf name to connect to. I know we can use a PGSERVICE environment setting instead, but I think we should have a command line switch too. Small 8.3

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Csaba Nagy
I think you build a whole new index named something like .temp-reindex and then as the last step of the second transaction delete the old idnex and rename the new index. That would require getting exclusive lock on the table. Just out of curiosity, creating a new index concurrently (or

Re: [HACKERS] psql service parameter

2006-09-27 Thread Albe Laurenz
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: I have just noticed that there does not seem to be a psql command line switch to specify a pg_service.conf name to connect to. I know we can use a PGSERVICE environment setting instead, but I think we should have a command line

Re: [HACKERS] psql service parameter

2006-09-27 Thread Martijn van Oosterhout
On Wed, Sep 27, 2006 at 04:54:35PM +0200, Albe Laurenz wrote: I think that both would be nice. Indeed, I wanted to suggest a switch for PGSERVICE myself. It some point I was wondering about using the @ symbol. If you have a service entry called testserver, you could do: psql @testserver But

Re: [HACKERS] Block B-Tree concept

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 05:38:38AM -0400, Bruce Momjian wrote: Heikki Linnakangas wrote: Jim C. Nasby wrote: Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do that anyway right now? You mean _index_ tuples marked dead? Sure, no problem there. Granted, you'd

Re: [HACKERS] Buildfarm alarms

2006-09-27 Thread Kris Jurka
On Wed, 27 Sep 2006, Andrew Dunstan wrote: The settings are in hours, so this says that if we haven't seen a HEAD build in 1 day or a stable branch build in 1 week, alert the owner by email, and keep repeating the alert in each case every 2 days. How does this know if there wasn't a

Re: [HACKERS] Cross-table statistics idea

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 12:30:43PM +0100, Simon Riggs wrote: On Tue, 2006-09-26 at 21:27 -0500, Jim C. Nasby wrote: Since I don't recall any ideas ever having been thrown out on how to do this... ISTM that we could gain additional insight on how many rows would likely result from a

[HACKERS] Buildfarm cvsignore files

2006-09-27 Thread Rocco Altier
I noticed that the build farm is only looking for the cvs-ignore'd files for a vpath build. Attached is a patch that will stop at the CVS stage if there are any cvs-ignore'd files in the clean repository. Its not triggered by a from-source build, only what should have been a clean check out.

Re: [HACKERS] psql service parameter

2006-09-27 Thread David Fetter
On Wed, Sep 27, 2006 at 10:23:13AM -0400, Andrew Dunstan wrote: I have just noticed that there does not seem to be a psql command line switch to specify a pg_service.conf name to connect to. I know we can use a PGSERVICE environment setting instead, but I think we should have a command line

Re: [HACKERS] Buildfarm alarms

2006-09-27 Thread Andrew Dunstan
Kris Jurka wrote: On Wed, 27 Sep 2006, Andrew Dunstan wrote: The settings are in hours, so this says that if we haven't seen a HEAD build in 1 day or a stable branch build in 1 week, alert the owner by email, and keep repeating the alert in each case every 2 days. How does this know if

Re: [PATCHES] [HACKERS] large object regression tests

2006-09-27 Thread Jeremy Drake
On Sun, 24 Sep 2006, Jeremy Drake wrote: On Thu, 21 Sep 2006, Tom Lane wrote: I suggest that instead of testing the server-side lo_import/lo_export functions, perhaps you could test the psql equivalents and write and read a file in psql's working directory. snip In the mean time, I will

Re: [HACKERS] String Similarity

2006-09-27 Thread Pang Zaihu
Hello! Would you like to give me a simple introduction of Levenshtein distence function? Thank you! On2006-05-1919:54,MartijnvanOosterhoutwrote: OnFri,May19,2006at04:00:48PM-0400,MarkWoodwardwrote: (3)IstherealsoadesireforaLevenshteindistencefunctionfortext

Re: [PATCHES] [HACKERS] large object regression tests

2006-09-27 Thread Jeremy Drake
On Mon, 25 Sep 2006, Tom Lane wrote: Jeremy Drake [EMAIL PROTECTED] writes: I just tried using the \lo_import command in a regression test, and I think I figured out why this will not work: ... Yes, that's the large object OID in the output there, and it is different each run (as I

[HACKERS] Transaction is read-only in auto commit mode

2006-09-27 Thread Asok Chattopadhyay
Hi,My application based on Java servlets was running fine with version PostgreSQL 7.x, but started giving error: "transaction is read-only", in version 8.0 and 8.1. I am using Suse Linux 9.3/PostgreSQL 8.0 or Suse Linux 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers and all connections are in

[HACKERS] PostgreSQL HA questions

2006-09-27 Thread Dragan Zubac
Hello We're looking for HA PostgreSQL solution,so have a couple of questions: 1. Is it possible for multiply PostgreSQL instances (engines,cores) to use same DATA space? For example,to have two PostgreSQL processes which will use same data directory,same files,and same data ? So,if You update

Re: [HACKERS] DROP FUNCTION IF EXISTS

2006-09-27 Thread Benny Amorsen
CN == Csaba Nagy [EMAIL PROTECTED] writes: CN The full story is that I typed 'ΓΌ' (u-umlaut if it won't render CN correctly) and backspace before the '1'. I guess the backspace CN will delete byte-wise and will so fail to delete properly CN multi-byte characters. Backspace deletes

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Kenneth Marshall
On Wed, Sep 27, 2006 at 04:09:18PM +0200, Zdenek Kotala wrote: Tom Lane napsal(a): Zdenek Kotala [EMAIL PROTECTED] writes: The problem was generated, because -fast option was set only for the compiler and not for the linker. Linker takes wrong version of libraries. If -fast is set for

Re: [HACKERS] PostgreSQL HA questions

2006-09-27 Thread Andrew Sullivan
First, I'm moving this to -general, because this is way off topic for -hackers as near as I can tell. On Tue, Sep 26, 2006 at 10:39:18PM +0200, Dragan Zubac wrote: 1. Is it possible for multiply PostgreSQL instances (engines,cores) to use same DATA space? No. In fact, this is a very good

Re: [HACKERS] [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

2006-09-27 Thread Magnus Hagander
This brings up something that I may have asked before, but I may also have just thought I should: Should/could we have the error message somehow reflect if the connection used pgpass.conf to pick up the password? //Magnus -Original Message- From: [EMAIL PROTECTED]

Re: [HACKERS] Buildfarm cvsignore files

2006-09-27 Thread Andrew Dunstan
Rocco Altier wrote: I noticed that the build farm is only looking for the cvs-ignore'd files for a vpath build. Attached is a patch that will stop at the CVS stage if there are any cvs-ignore'd files in the clean repository. Its not triggered by a from-source build, only what should have been

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-27 Thread Thomas Hallgren
[EMAIL PROTECTED] wrote: On Tue, Sep 19, 2006 at 11:21:51PM -0400, Alvaro Herrera wrote: [EMAIL PROTECTED] wrote: On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote: On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: I would not use a 100% random number generator

Re: [Pgbuildfarm-members] [HACKERS] Buildfarm alarms

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 01:55:21PM -0400, Andrew Dunstan wrote: Kris Jurka wrote: On Wed, 27 Sep 2006, Andrew Dunstan wrote: The settings are in hours, so this says that if we haven't seen a HEAD build in 1 day or a stable branch build in 1 week, alert the owner by email, and

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Tom Lane
Jon Lapham [EMAIL PROTECTED] writes in pgsql-general: If I run... sleep 3; echo starting; createdb bar ...and power off the VM while the createdb bar is running. Upon restart, about 50% of the time I can reproduce the following error message: [EMAIL PROTECTED] ~]$ psql bar psql: FATAL:

Re: [Pgbuildfarm-members] [HACKERS] Buildfarm alarms

2006-09-27 Thread Andrew Dunstan
Jim C. Nasby wrote: Another possibility is just having the client report no CVS changes detected to the server, as a form of a ping. I am not going to re-architect the buildfarm client and server for this. I think what I have done will be quite sufficient. I suspect most people will only

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 04:13:34PM -0400, Tom Lane wrote: Jon Lapham [EMAIL PROTECTED] writes in pgsql-general: If I run... sleep 3; echo starting; createdb bar ...and power off the VM while the createdb bar is running. Upon restart, about 50% of the time I can reproduce the following

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Tom Lane
Jim C. Nasby [EMAIL PROTECTED] writes: Then again, if we're doing that, we could probably just nuke 'em... This has been considered and rejected before, on the grounds that removing files you don't know the source of is a good way to lose data. Come to think of it, that argument bears on the

Re: [HACKERS] PostgreSQL HA questions

2006-09-27 Thread Chris Browne
[EMAIL PROTECTED] (Andrew Sullivan) writes: It isn't clear to me why you think you need to do this: vacuum doesn't block your queries anyway. If the idea is that you have a table that you'd rather TRUNCATE and not have to vacuum, however, that makes sense. There are several strategies for

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 04:52:51PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: Then again, if we're doing that, we could probably just nuke 'em... This has been considered and rejected before, on the grounds that removing files you don't know the source of is a good way to

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-27 Thread Matteo Beccati
Stefan Kaltenbrunner wrote: too bad - however any idea on one of the other troubling querys (q21) I mentioned in the mail I resent to the list (after the original one got lost)? http://archives.postgresql.org/pgsql-hackers/2006-09/msg02011.php What happens if you increase statistics for

Re: [HACKERS] Faster StrNCpy

2006-09-27 Thread mark
On Wed, Sep 27, 2006 at 07:08:05AM -0700, Strong, David wrote: We sometimes see TupleDescInitEntry () taking high CPU times via OProfile. This does include, amongst a lot of other code, a call to namestrcpy () which in turn calls StrNCpy (). Perhaps this is not a good candidate right now as a

[HACKERS] Can i see server SQL commands ?

2006-09-27 Thread Adnan DURSUN
Hi all I wanna know what is going on while a DML command works. For example ; Which commands are executed by the core when we send an UPDATE tab SET col = val1... in case there is a foreing key or an unique constraint on table tab. How can i see that ?

Re: [HACKERS] String Similarity

2006-09-27 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Sep 26, 2006 at 09:09:33AM +0800, Pang Zaihu wrote: Hello! Would you like to give me a simple introduction of Levenshtein distence function? Better than I could explain: http://en.wikipedia.org/wiki/Levenshtein_distance Thank you!