Re: [ADMIN] How to optimize Postgres Database

2005-09-04 Thread Alvaro Herrera
On Tue, Aug 30, 2005 at 09:45:52AM +0530, Hemant Pandey wrote: I am running an application, which connects to the postgres database at initialization time and perform the database operations like Select/Update. Database queries are very simple. On analyzing my application through

[ADMIN] statistics not shown up

2005-09-04 Thread huaxin zhang
I start postgres using the -s parameter to track the number of hits to buffer. I also set both stats_start_collector, stats_block_level to true in /usr/local/pgsql/data/postgresql.conf However, I get (typeid = 700, len = 4, typmod = -1, byval = f) after running each query. Apparently this is

[ADMIN] pgfoundry administration

2005-09-04 Thread Guido Barosio
Seems that the guys @ pgfoundry are in problems but they do use postgresql ;) An error occured in the logger. ERROR: could not extend relation activity_log: No space left on device HINT: Check free disk space. :(

Re: [ADMIN] statistics not shown up

2005-09-04 Thread Michael Fuhr
On Sun, Sep 04, 2005 at 08:00:21PM -0400, huaxin zhang wrote: I start postgres using the -s parameter to track the number of hits to buffer. I assume you're running postgres in single-user mode since that's where the -s option means print statistics. Is that what you're doing? I also set

Re: [ADMIN] pgfoundry administration

2005-09-04 Thread Marc G. Fournier
Nope, just moved the database server(s) to a faster server, and didn't realize that I hadn't cleared out enough disk space before doing so :( Already fixed, and 20+Gig of free space (and growing) to play with now) ... On Mon, 5 Sep 2005, Guido Barosio wrote: Seems that the guys @