Re: [ADMIN] Performance problems with Postgresql

2003-03-20 Thread Andrew Biagioni
I didn't see a response to your question yet, so I'll throw in my 2 cents. I had similar questions as yours;  I found my answers in section 3.5 of  the Administrator's Guide (I looked at v.7.2.x, but it's also in v7.3.1).  They are all available at         http://www.us.postgresql.org/users-l

Re: [ADMIN] Problems tuning shared_buffers value

2003-03-20 Thread Bill Moran
Tom Lane wrote: Bill Moran <[EMAIL PROTECTED]> writes: curious about some things, so I set shared_buffers to 16 (which the config file claims is the lowest allowable value) The result was that Postgre refused to start. I upped it to 32 and the result was the same. I looked in both /var/log/messa

[ADMIN] Problems tuning shared_buffers value

2003-03-20 Thread Bill Moran
I'm new to this list. This morning I was experimenting with some tunings for PostgreSQL. (I currently have 7.3.1 installed ... it's behind a firewall so I've been using that as an excuse not to worry about 7.3.2 yet) I was curious about some things, so I set shared_buffers to 16 (which the config

[ADMIN] 7.3.2 strange behavior (long)

2003-03-20 Thread andrea suisani
Hello, Firstly I apologise for my terrible english. we are using postgresql 7.2.x (currently 7.2.4) on our production server for last year (and also we are on suse 7.2). Last night i was working on the project for porting our application on pgsql 7.3.2 when a strange thing happen. The machine han