Re: What is the right way to deal with a table with rows that are not in a random order?
От | Simon Riggs |
---|---|
Тема | Re: What is the right way to deal with a table with rows that are not in a random order? |
Дата | |
Msg-id | 1243547570.24860.691.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Re: What is the right way to deal with a table with rows that are not in a random order? (Douglas Alan <darkwater42@gmail.com>) |
Ответы |
Re: What is the right way to deal with a table with rows
that are not in a random order?
|
Список | pgsql-general |
On Thu, 2009-05-28 at 15:03 -0400, Douglas Alan wrote: > The application in question is a kind of data warehousing thing (of > astronomical stars), and there's an ORM in the middle, so it's not > easy for us to hand-tune how individual queries are specified. > Instead, we have to structure the database and the indexes so that > things generally perform well, without having to tweak specific > queries. You should look at indexing solutions, or take professional advice on that. > Users can specify fairly arbitrary search criteria. All of the > queries should perform well. By "well", I mean within 10 seconds or > so. That's an unrealistic expectation, unfortunately. Fast search requires some form of preparatory action and without any clue as to what that should be you cannot guarantee response times. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
В списке pgsql-general по дате отправления: