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
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
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 yo
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 th
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 recomme
= -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
On Thursday 12 May 2005 2
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 th
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
th mobile_num columns.
>
> Chris
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
--
Jerome Macaranas
Systems/Network Administrator
GMA
p://developer.postgresql.org/docs/postgres/sql-createtable.html
>
> HTH
>
> Shridhar
--
Jerome Macaranas
Systems/Network Administrator
GMA New Media, Inc.
Phone: (632) 9254627 loc 202
Fax: (632) 9284553
Mobile: (632) 918-9336819
[EMAIL PROTECTED]
DISCLAIMER: This Message may conta
Is there a way in postgres to view current client connections? including
statistics.. how long did it take for him to connect and disconnect.. etc
TIA
---(end of broadcast)---
TIP 8: explain analyze is your friend
11 matches
Mail list logo
