Re: [GENERAL] sloooow query
| От | Martijn van Oosterhout |
|---|---|
| Тема | Re: [GENERAL] sloooow query |
| Дата | |
| Msg-id | 20021008000308.GA28930@svana.org обсуждение |
| Ответ на | sloooow query ("Marie G. Tuite" <marie.tuite@edisonaffiliates.com>) |
| Список | pgsql-performance |
On Mon, Oct 07, 2002 at 02:22:09PM -0500, Marie G. Tuite wrote: > Hello all, > > I am experiencing slow db performance. I have vacuumed, analyzed, reindexed > using the force option and performance remains the same - dog-slow :( If I > drop and recreate the database, performance is normal, so this suggests a > problem with the indexes? I also took a look at the postgresql.conf and all > appears fine. There are many instances of the same database running on > different servers and not all servers are experiencing the problem. We need more details if you wish to receive useful answers. Query/EXPLAIN output/schema, etc -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > There are 10 kinds of people in the world, those that can do binary > arithmetic and those that can't.
В списке pgsql-performance по дате отправления: