pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres query is very slow
3+ messages / 3 participants
[nested] [flat]
* postgres query is very slow
@ 2010-06-22 17:23 donghe@caltech.edu
0 siblings, 1 reply; 3+ messages in thread
From: donghe@caltech.edu @ 2010-06-22 17:23 UTC (permalink / raw)
To: pgsql-admin
Hi,
I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but the
query is still slow.
Has anybody an idea ?
Thanks
Dong
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres query is very slow
@ 2010-06-22 17:33 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: donghe@caltech.edu
0 siblings, 1 reply; 3+ messages in thread
From: Kevin Grittner @ 2010-06-22 17:33 UTC (permalink / raw)
To: donghe@caltech.edu; pgsql-admin
<donghe@caltech.edu> wrote:
> I built a database on postgres8.1, then I did VACUUM FULL ANALYZE,
> but the query is still slow.
> Has anybody an idea ?
I recommend you re-post to the pgsql-performance list, after reading
this:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
The one thing I can say based on the information you've provided so
far is that you can expect major performance improvements if you
upgrade to a new major release of PostgreSQL.
Well, there is one other thing -- it's almost never a good idea to
run VACUUM FULL. You may have bloated your indexes. You could try
a REINDEX on the database.
-Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgres query is very slow
@ 2010-06-30 21:03 Dai, Tino <tdai@loc.gov>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 3+ messages in thread
From: Dai, Tino @ 2010-06-30 21:03 UTC (permalink / raw)
To: pgsql-admin
<donghe@caltech.edu> wrote:
> I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but
> the query is still slow.
> Has anybody an idea ?
When I had performance problems, what I did was go through the specific
queries that we presenting the performance problem and used an analyze on
those queries. I found that there was a significant performance issues
with the way that some queries were fashioned. What I ended up doing was
switching to 8.2.
-Tino
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-06-30 21:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-22 17:23 postgres query is very slow donghe@caltech.edu
2010-06-22 17:33 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-30 21:03 ` Dai, Tino <tdai@loc.gov>
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