Re: [GENERAL] postgres/postgis eats memory

2011-10-21 Thread Craig Ringer
On 10/21/2011 09:05 PM, Martin Guether wrote: Hi guys, on a test maschine from my university i'm running into a weird problem. the issue (i attached detail info): The running query eats more and more memory.(seen in htop) It'll start using virtual memory and after eating up that one, too, postg

[GENERAL] postgres/postgis eats memory

2011-10-21 Thread Martin Guether
Hi guys, on a test maschine from my university i'm running into a weird problem. the issue (i attached detail info): The running query eats more and more memory.(seen in htop) It'll start using virtual memory and after eating up that one, too, postgres will crash with: psql:/home/mguether/sql/be

Re: [GENERAL] postgres/postgis indexes

2009-07-13 Thread Simon Riggs
On Mon, 2009-07-13 at 12:11 +0200, Antonio Muñoz wrote: > Can you tell me if Postgres/Postgis can use both spatial and > alfanumeric indexes, at the same time, in the same query? Yes, it can. Postgres will use all and any indexes available to it. In some cases, multiple indexes of different type

[GENERAL] postgres/postgis indexes

2009-07-13 Thread Antonio Muñoz
Hi all. Can you tell me if Postgres/Postgis can use both spatial and alfanumeric indexes, at the same time, in the same query? Thanks in advance.

Re: [GENERAL] postgres/postgis

2008-10-07 Thread Devrim GÜNDÜZ
Hi, On Tue, 2008-10-07 at 09:23 -0500, Eduardo Arévalo wrote: > distro Centos 5.2 x64 Since you want to use 8.3 IIRC, then, run: rpm -Uvh \ http://yum.pgsqlrpms.org/reporpms/8.3/pgdg-centos-8.3-4.noarch.rpm and then use yum to install GeOS, PostGIS and PostgreSQL 8.3.4. All have 64-bit support.

Re: [GENERAL] postgres/postgis

2008-10-07 Thread Devrim GÜNDÜZ
On Mon, 2008-10-06 at 09:26 -0500, Eduardo Arévalo wrote: > hello is campatible install postgresql-8.3.4-1-linux-x64 with > postgis-1.3.3. > postgis there for 64-bit architecture?? > There are the libraries and proj4 GEOS arqitectura for 64-bit?? For which distro? Many distros has these stuff in

Re: [GENERAL] postgres/postgis

2008-10-06 Thread Brent Wood
You might try the Geo repository for OpenSUSE. This includes builds in 32 & 64 bit for several other distros as well as OpenSUSE for the GIS related applications, but you will probably need to compile Postgres (that version) from scratch. Which is unfortunate, as the default build by compiling Po

Re: [GENERAL] postgres/postgis

2008-10-06 Thread Dave Page
On Mon, Oct 6, 2008 at 3:26 PM, Eduardo Arévalo <[EMAIL PROTECTED]> wrote: > hello is campatible install postgresql-8.3.4-1-linux-x64 with > postgis-1.3.3. > postgis there for 64-bit architecture?? > There are the libraries and proj4 GEOS arqitectura for 64-bit?? You will need to build them yours

[GENERAL] postgres/postgis

2008-10-06 Thread Eduardo Arévalo
hello is campatible install postgresql-8.3.4-1-linux-x64 with postgis-1.3.3. postgis there for 64-bit architecture?? There are the libraries and proj4 GEOS arqitectura for 64-bit??