On Tuesday 24 May 2005 21:38, Scott Marlowe wrote:
> 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 t
On Tuesday 24 May 2005 22:33, Tom Lane wrote:
> Jerome Macaranas <[EMAIL PROTECTED]> writes:
> > LOG: query: SELECT * FROM phpbb_smilies
> > LOG: duration: 0.005410 sec
> > LOG: duration: 390.731807 sec
> > -- this table has only 295 rows
>
> I think this is an artifact of your lack-of-vacuuming
Jerome Macaranas <[EMAIL PROTECTED]> writes:
> LOG: query: SELECT * FROM phpbb_smilies
> LOG: duration: 0.005410 sec
> LOG: duration: 390.731807 sec
> -- this table has only 295 rows
I think this is an artifact of your lack-of-vacuuming problems;
the table has become hugely bloated and it takes
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 co
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?
tcpip_socket = true
max_connections = 260
superuser_rese
On Thu, 2005-05-12 at 00:33, Jerome Macaranas wrote:
> On Tuesday 10 May 2005 22:00, Scott Marlowe wrote:
> > On Mon, 2005-05-09 at 23:35, Jerome Macaranas wrote:
> > > i didnt set fsm... the config i paste is all that i put into place...
> >
> > OK, that's likely a part of your problem.
> >
> > Di
On Tuesday 10 May 2005 22:00, Scott Marlowe wrote:
> On Mon, 2005-05-09 at 23:35, Jerome Macaranas wrote:
> > i didnt set fsm... the config i paste is all that i put into place...
>
> OK, that's likely a part of your problem.
>
> Did you run the vacuumdb -af I recommended? Did it help? If so, you
On Mon, 2005-05-09 at 23:35, Jerome Macaranas wrote:
> i didnt set fsm... the config i paste is all that i put into place...
OK, that's likely a part of your problem.
Did you run the vacuumdb -af I recommended? Did it help? If so, you
likely need to run plain (i.e. lazy) vacuums more often, a
my data directory is just 1.7G
On Tuesday 10 May 2005 14:33, Frank Finner wrote:
> On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> > im using RH9
> >
> > postgres 7.3.4
>
> Maybe you ran into the same problem I had about a year ag
Hi,
what fix did you do? go for 7.4?
tia,
On Tuesday 10 May 2005 14:33, Frank Finner wrote:
> On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]>
thought long, then sat down and wrote:
> > im using RH9
> >
> > postgres 7.3.4
>
> Maybe you ran into the same problem I had abou
On Tue, 10 May 2005 12:19:43 +0800 Jerome Macaranas <[EMAIL PROTECTED]> thought
long, then sat down and wrote:
> im using RH9
>
> postgres 7.3.4
Maybe you ran into the same problem I had about a year ago. See
http://archives.postgresql.org/pgsql-general/2004-03/msg00810.php and thread.
My dat
i didnt set fsm... the config i paste is all that i put into place...
is there a way to look at the query that's eating too much process
without starting the DB and redirect stdout out to a file?
process ID 32082..
32082 pts/3S 0:08 postgres: mydbuser mydb 10.10.10.1 SELECT
if i do top
On Monday 09 May 2005 23:28, Scott Marlowe wrote:
> On Mon, 2005-05-09 at 08:55, JM wrote:
> > Hi ALL,
> >
> > we have a site that uses postgres as a backend for a forum. this forum
> > does a lot of deletes, selects and inserts. just recently for some
> > reason postgres eats a lot of proces
On Mon, 2005-05-09 at 08:55, JM wrote:
> Hi ALL,
>
> we have a site that uses postgres as a backend for a forum. this forum
> does a lot of deletes, selects and inserts. just recently for some reason
> postgres eats a lot of processing power..
>
> here are some tech-details:
>
>
14 matches
Mail list logo
