WG: AW: [GENERAL] Index on geometry and timestamp

> Thank you Oleg, > > It works. glad to hear that. You might submit this to posgis faq. > > Greetings > Jens > > -Urspr?ngliche Nachricht- > Von: Oleg Bartunov [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 7. Dezember 2004 12:20 > An: Werdin Jens >

Re: [GENERAL] Performance

Werdin Jens wrote: > Hello, > > Ich have a big performance problem. > I'm running postgres 7.4.2 on Suse Linux 9.0 on a dual Xeon 3.0 GHz with 3 > Gbyte Ram. > In postgres.conf I'm using the defaults. That's the place to start. See the guide at: http://ww

Re: [GENERAL] Index on geometry and timestamp

The Problem is, that I need the milliseconds and the information of the Timezone. -Ursprüngliche Nachricht- Von: Pierre-Frédéric Caillaud [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 7. Dezember 2004 09:48 An: Werdin Jens; [EMAIL PROTECTED] Betreff: Re: [GENERAL] Index on geometry and

[GENERAL] Index on geometry and timestamp

Title: Index on geometry and timestamp Hi, I need an index on a postgis-point and a timestamp. I'm using an GiST index on the geometry. But the creation of an GiST index on geometry and timestamp seems to be impossible, because GiST doesn't support Timestamps. Is there a possibility to solv

[GENERAL] Performance

Title: Performance Hello, Ich have a big performance problem. I'm running postgres 7.4.2 on Suse Linux 9.0 on a dual Xeon 3.0 GHz with 3 Gbyte Ram. In postgres.conf I'm using the defaults. Filesystem is ext3 with writeback journaling I have 3 tables with ca 10 million entries with a gist