Re: [GENERAL] linking access using ODBC driver with geometric data

"Jeff D. Hamann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sorry for the seemingly novice posting, but I could find a solution for > this on the web so far... > > I've been developing a database using postgresql (and loving it) and have > started running into problems with attem

Re: [GENERAL] tsearch2: very slow queries

On Sun, 7 Aug 2005, Joshua D. Drake wrote: Marc G. Fournier wrote: 'k, I'm obviously doing something wrong, since my experiences with sites like fts.postgresql.org indicate things should be *alot* faster then I'm getting ... Well the first thing I would ask is are you running 8.0? My testi

Re: [GENERAL] tsearch2: very slow queries

Marc G. Fournier wrote: 'k, I'm obviously doing something wrong, since my experiences with sites like fts.postgresql.org indicate things should be *alot* faster then I'm getting ... Well the first thing I would ask is are you running 8.0? My testing shows that Tsearch is pretty abysmal if y

[GENERAL] tsearch2: very slow queries

'k, I'm obviously doing something wrong, since my experiences with sites like fts.postgresql.org indicate things should be *alot* faster then I'm getting ... I have a *very* simple table: =# \d article_tsearch Table "public.article_tsearch" Column | Type | Modifiers +-

Re: [GENERAL] postgresql Secure Mode

> Hi, > > i have a probem,. > > I am trying to configure postgresql in sure way, I have made the > following thing: > > 1. - I have created the certificate and put this in the directory it data > 2. - given him privileges to the user postgresql for the certificate > 3. - in the file postgre

Re: [GENERAL] Remopte connection to POstgreSQL via ODBC

Google is your friend, follow this http://archives.postgresql.org/pgsql-odbc/2004-02/msg00029.php Poul Zlatko Matić wrote: Hello.   I just read all about TCP/IP, pg_hba.conf, listen_adresses and similar topics regarding remote TCP/IP connections, but where can I find explan

Re: [GENERAL] timestamp default values

On Sun, Aug 07, 2005 at 12:47:19AM -0400, Tom Lane wrote: > BTW: at least with our current interpretation of these datatypes, the > only type that is sensible for a now()-like function to return is > timestamptz. Not plain timestamp; that cannot be considered to > represent a well-defined instant

[GENERAL] Remopte connection to POstgreSQL via ODBC

Hello.   I just read all about TCP/IP, pg_hba.conf, listen_adresses and similar topics regarding remote TCP/IP connections, but where can I find explanations about how to remotely connect using ODBC and DSN-less connection string. For example, how to connect to PostgreSQL server from remote

[GENERAL] postgresql Secure Mode

Hi, i have a probem,. I am trying to configure postgresql in sure way, I have made the following thing: 1. - I have created the certificate and put this in the directory it data 2. - given him privileges to the user postgresql for the certificate 3. - in the file postgresql.conf, modify t

Re: [GENERAL] Querry and SMP mechine

On Sun, Aug 07, 2005 at 02:15:50PM +0300, Michael Ben-Nes wrote: > >Yep, PostgreSQL uses a single backend for each client, so if you want > >to use all four processors, you need to be running four queries > >simultaneously... > > > > > You mean select 1, select 2 & sleect 3 will run on the same cp

Re: [GENERAL] Querry and SMP mechine

Martijn van Oosterhout wrote: On Sun, Aug 07, 2005 at 01:04:51PM +0300, Michael Ben-Nes wrote: Hello Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). I noticed that when im runing a big query only one of th

Re: [GENERAL] Querry and SMP mechine

> Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. > > doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). > > I noticed that when im runing a big query only one of the > CPUs become loaded. > > Is it normal behavior ? am i missing something ? Yes, that is normal.

[GENERAL] Querry and SMP mechine

Hello Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). I noticed that when im runing a big query only one of the CPUs become loaded. Is it normal behavior ? am i missing something ? Thanks -- ---

Re: [GENERAL] Querry and SMP mechine

On Sun, Aug 07, 2005 at 01:04:51PM +0300, Michael Ben-Nes wrote: > Hello > > Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. > > doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). > > I noticed that when im runing a big query only one of the CPUs become > loaded.