Re: Slow PG after upgrade to 8.2.9!!
This is a discussion on Re: Slow PG after upgrade to 8.2.9!! within the Pgsql General forums, part of the PostgreSQL category; --> On 8/28/08, Andreas Kretschmer <akretschmer@spamfence.net> wrote: > > Please show us a EXPLAIN ANALYSE for this query. Btw, why ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
08-29-2008, 09:59 AM
| ||||
| ||||
 Re: Slow PG after upgrade to 8.2.9!! On 8/28/08, Andreas Kretschmer <akretschmer@spamfence.net> wrote: > > Please show us a EXPLAIN ANALYSE for this query. Btw, why > random_page_cost=2? (your other post) The EXPLAIN ANALYZE shows that it's using an INDEX and getting one row! So I know the SQL is right. Could it be that the SQL queries become slow because some other background operation is running, like pg_dumpall or vaccuum? How would I test this hypothesis if the log does have mentioned of "vaccuum analyze" being slow? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general      |
 |
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mouse slow after upgrade | Peter Doering | VMWARE Guest Windows2000 | 3 | 06-14-2008 08:33 AM |
| Slow upgrade to AIX 5.3 ML/TL 08 | Henrik Goldman | AIX Operating System | 0 | 05-11-2008 09:36 PM |
| Re: hyper slow after upgrade to 8.1.4 | Medora Schauer | Pgsql Performance | 0 | 04-19-2008 09:07 AM |
| 'apt-get upgrade' Over Slow Connection | Kenneth Jacker | Debian Linux Users forum | 3 | 01-17-2008 08:48 AM |
| Slow rlogin after upgrade to 5.2. | Hemant Shah | AIX Operating System | 9 | 01-04-2008 08:58 PM |
All times are GMT. The time now is 10:13 PM.
