pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWorking slow
3+ messages / 3 participants
[nested] [flat]
* Working slow
@ 2009-09-21 13:58 Judith Altamirano <jaltamirano@lux.com.mx>
0 siblings, 2 replies; 3+ messages in thread
From: Judith Altamirano @ 2009-09-21 13:58 UTC (permalink / raw)
To: pgsql-sql
hello every body, I'm having a data base in a point of sale that is
getting frozen, I already have run a vacuum -z -d to reindex the data
base and nothing happens...... Some suggestions to speed the process, Do
you guys think that the data base is nearly to broke?
--
luxcorreoseguro
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Working slow
@ 2009-09-22 01:56 Scott Marlowe <scott.marlowe@gmail.com>
parent: Judith Altamirano <jaltamirano@lux.com.mx>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2009-09-22 01:56 UTC (permalink / raw)
To: Judith Altamirano <jaltamirano@lux.com.mx>; +Cc: pgsql-sql
On Mon, Sep 21, 2009 at 7:58 AM, Judith Altamirano
<jaltamirano@lux.com.mx> wrote:
> hello every body, I'm having a data base in a point of sale that is getting
> frozen, I already have run a vacuum -z -d to reindex the data base and
> nothing happens...... Some suggestions to speed the process, Do you guys
> think that the data base is nearly to broke?
vacuumdb does not reindex, reindexdb does that.
Hard to say with so little evidence.
What does top, or vmstat 1, or iostat 10 or
select datname, current_query, waiting, (now()-query_start)::time(0) as runtime
from pg_stat_Activity
where current_query not ilike '%idle%'
order by query_start limit 10
have to say?
Is the database already bloated? If so, how big is /data/base
compared to usual?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Working slow
@ 2009-09-22 02:45 Rob Sargent <robjsargent@gmail.com>
parent: Judith Altamirano <jaltamirano@lux.com.mx>
1 sibling, 0 replies; 3+ messages in thread
From: Rob Sargent @ 2009-09-22 02:45 UTC (permalink / raw)
To: Judith Altamirano <jaltamirano@lux.com.mx>; +Cc: pgsql-sql
Judith Altamirano wrote:
> hello every body, I'm having a data base in a point of sale that is
> getting frozen, I already have run a vacuum -z -d to reindex the data
> base and nothing happens...... Some suggestions to speed the process,
> Do you guys think that the data base is nearly to broke?
>
>
As well as the good points Scott Marlow raised, does the application
perform well immediately after a reboot and then slowdown or do all
queries take longer than they should (and by how much)?
Do you have the sql for typical queries and can you run them with ANALYSE?
PS. (Based on the post time vs clock time, I suspect the you machine's
clock is out of sync)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-09-22 02:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-09-21 13:58 Working slow Judith Altamirano <jaltamirano@lux.com.mx>
2009-09-22 01:56 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-09-22 02:45 ` Rob Sargent <robjsargent@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox