Re: [ADMIN] downgrading to 7.3.2 from 7.4.1 under Cygwin

2003-12-03 Thread Janko Richter
You can choose the PG version using cygwin installer. If you have already PG 7.4 installed, you can select -keep, -reinstall, -source, -7.3.4-2 <-- what you need -Uninstall Regards, Janko Richter Együd Csaba wrote: Hi Folks, I've refreshed my Cygwin distribution and haven't noticed that postg

Re: [ADMIN] Cast text to bytea

2003-12-03 Thread Alvar Freude
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, uups, why I wrote the originating mail to pgsql-admin? Sorry! - -- Godshall Michael <[EMAIL PROTECTED]> wrote: > Have you seen this? > http://www.postgresql.org/docs/current/static/datatype-binary.html yes, but this only describe the bytea

[ADMIN] Index problems

2003-12-03 Thread Ferdinand Smit
Hi, When trying to explain a developer of our organisation the reson why the index was'nt used, i was confused my self. The simple question is: Why does the analyzer only use the index when the table has a few differend values ? As you can see, when de seqscan is off, the query is mutch faster

Re: [ADMIN] Index problems

2003-12-03 Thread Stephan Szabo
On Wed, 3 Dec 2003, Ferdinand Smit wrote: > Hi, > > When trying to explain a developer of our organisation the reson why the index > was'nt used, i was confused my self. > > The simple question is: Why does the analyzer only use the index when the There are a fiew things going on: First, the st

[ADMIN] tuning questions

2003-12-03 Thread Jack Coates
Hi, I'm having trouble optimizing PostgreSQL for an admittedly heinous worst-case scenario load. testbed: dual P3 1.3 GHz box with 2GB RAM two IDE 120G drives on separate channels (DMA on), OS on one, DB on the other, some swap on each (totalling 2.8G). RH Linux 8. I've installed PG 7.3.4 from s