, 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 23:11, Scott Marlowe wrote:
On Thu, 2005-05-12 at 00:33, Jerome Macaranas wrote
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 problems
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 time
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
i
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 about a year
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 ago. See
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 processing
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
with this. In oracle you
can just assign tables on a diff partition.
You could use tablespaces in postgresql 8.0..
Check this
http://developer.postgresql.org/docs/postgres/sql-createtablespace.html
http://developer.postgresql.org/docs/postgres/sql-createtable.html
HTH
Shridhar
--
Jerome
)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Jerome Macaranas
Systems/Network Administrator
GMA New Media, Inc.
Phone: (632) 9254627 loc 202
Fax: (632) 9284553
Mobile: (632) 918-9336819
[EMAIL PROTECTED
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
