Re: [GENERAL] PostGIS in a commercial project

be glad to discuss this further on the postgis-users mailing list. Kind regards, Mark. (Member of the PostGIS PSC) -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Problems building from source

even fully supported on 64-bit today? The mingw-w64 fork is fairly mature at the moment, and the devs are really helpful if you do happen to find something that doesn't work. The orignal mingw project 64-bit support is not that great. http://mingw-w64.sourceforge.net/ ATB, Mark. -- Mark Cave

Re: [GENERAL] server-side extension in c++

a few other open source GIS packages, I'd say quite small unless it was a very minimal change. I also should point out that I have very little C++ experience, and so would be the wrong person to ask ;) ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius

Re: [GENERAL] server-side extension in c++

caller to retrieve the related error string. While it does seem quite inelegant, I don't believe any problems linking between C/C++ have been reported on any compiler/platform since this was put into place. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS

[GENERAL] Re: Error during make when installing geos for postgis install...still trying

. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Out of memory error

-leak fixes IIRC. HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?

is present? AFAICT the planner should favour the index scan on file_id given that the estimated cost in the second query is much lower than the one estimated for the revision_id index on the first query. Many thanks, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http

Re: [GENERAL] PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?

have to stick with it. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] R-tree, order by, limit

). It implements the OGC SFS for geometries and is compatible with a large number of open source viewers/tools such as Mapserver, Geoserver, QGIS, OGR etc... ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 -- Sent via pgsql

Re: [GENERAL] R-tree, order by, limit

://postgis.refractions.net/support/wiki/ is a good starting point for code examples. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Various intermittent bugs/instability - how to debug?

, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Query using cursors using 100% CPU

what you mention above, it's likely that what you're seeing is a bad query plan choice anyway. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ---(end of broadcast)--- TIP

Re: [GENERAL] Query using cursors using 100% CPU

and sends its queries over the network? If so, the extra CPU usage may be involved with sending/receiving large datasets across the network. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ---(end

Re: [GENERAL] How to extract a substring using Regex

On Thu, 2007-08-23 at 19:08 -0700, Postgres User wrote: On 8/23/07, Michael Glaesemann [EMAIL PROTECTED] wrote: On Aug 23, 2007, at 20:01 , Postgres User wrote: Yes, I read the manual. I think I had a problem because of the special chars ( / ) that I'm trying to search for... Still

Re: [GENERAL] Postgres scalability and performance on windows

Hi all, I have a postgres installation thats running under 70-80% CPU usage while an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load. Here's the scenario, 300 queries/second Server: Postgres 8.1.4 on win2k server CPU: Dual Xeon 3.6 Ghz, Memory: 4GB RAM

[GENERAL] PostgreSQL and SAN/NAS technologies

Hi everyone, We're looking at investing in a new storage system in order to run PostgreSQL and the advice we are getting is to move away from our current SAN solution to a NAS solution. Can anyone offer any advice/experience on using NAS devices to run a PostgreSQL database? I have seen posts on

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

Hi everyone, I've just got back from LinuxWorld in London and seeing this thread thought I would share my experience of the MySQL stand - if you are of a delicate dispostion, please look away now. I basically asked them straight up why I should use MySQL instead of PostgreSQL and was quite

Re: [GENERAL] Recursive PLPGSQL function?

-Original Message- From: DeJuan Jackson [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 17:56 To: Mark Cave-Ayland Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Recursive PLPGSQL function? If I'm not mistaken you have an infinit recursion because you are always pulling

[GENERAL] Recursive PLPGSQL function?

'; If this is not possible, can anyone else suggest a way of getting the required result? Many thanks, Mark. --- Mark Cave-Ayland Webbased Ltd. Tamar Science Park Derriford Plymouth PL6 8BX England Tel: +44 (0)1752 764445 Fax: +44 (0)1752 764446 This email and any attachments are confidential to the intended

Re: [GENERAL] indexing with lower(...) - queries are not optimised very well - Please Help

-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 16 January 2004 21:50 To: Martin Hampl Cc: [EMAIL PROTECTED]; Mark Cave-Ayland Subject: Re: [GENERAL] indexing with lower(...) - queries are not optimised very well - Please Help Martin Hampl [EMAIL PROTECTED