Re: Need input on postgres used for phpBB - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Need input on postgres used for phpBB
Date
Msg-id 1116941926.31821.255.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Need input on postgres used for phpBB  (Jerome Macaranas <jerome@gmanmi.tv>)
Responses Re: Need input on postgres used for phpBB
List pgsql-general
On Tue, 2005-05-24 at 07:19, Jerome Macaranas wrote:
> hi,
>
>     I enabled logging for a while just to see what statement is taking too much
> time.. listed below are some parts of the log.. im wondering why this sql
> takes to much time.. they have indexes in place.. or it might be my config?

SNIP

> LOG:  query: SELECT * FROM phpbb_smilies
> LOG:  duration: 0.005410 sec
> LOG:  duration: 390.731807 sec
> -- this table has only 295 rows

That you can see.  I still think there's got to be a bunch of dead
tuples for it to be this slow, or there's something very wrong with your
I/O subsystem.

> ....
> LOG:  query: SELECT *
>         FROM phpbb_config
> LOG:  duration: 50.752599 sec
> .......

Indexes won't help here, as they're asking for the shole table in each
time.  What does 'explain analyze select * From phpbb_config' from the
psql command prompt say?  What does vacuum verbose phpbb_config say?
Are you getting any weird messages in the system logs when this is
happening, like maybe disk timeouts?

How long does it take to copy a hundred or so megabytes on this same
drive.

> LOG:  query: UPDATE phpbb_sessions
>                 SET session_user_id = -1, session_start = 1116932825,
> session_time = 1116932825, session_page = 1, session_l
> ogged_in = 0
>                 WHERE session_id = '8a7fe41e58077d2f8cececdc23ab9f80'
>                         AND session_ip = 'd2d58db2'
> LOG:  duration: 86.218839 sec



pgsql-general by date:

Previous
From: James Croft
Date:
Subject: PostgreSQL release schedule
Next
From: Chris Kratz
Date:
Subject: Re: pg_dump in a production environment