On Fri, 31 Jul 2009 19:04:52 +0200, Tom Lane wrote:
Greg Stark writes:
On Thu, Jul 30, 2009 at 11:30 PM, Tom Lane wrote:
I did some tracing and verified that pg_dump passes data to deflate()
one table row at a time. I'm not sure about the performance
implications of that, but it does seem l
Greg Stark writes:
> On Thu, Jul 30, 2009 at 11:30 PM, Tom Lane wrote:
>> I did some tracing and verified that pg_dump passes data to deflate()
>> one table row at a time. I'm not sure about the performance
>> implications of that, but it does seem like it might be something to
>> look into.
> I
On Thu, Jul 30, 2009 at 10:07 AM, Rauan Maemirov wrote:
> Unfortunately had to downgrade back to 8.3. Now having troubles with
> that and still solving them.
>
> For future upgrade, what is the basic steps?
>
>>Was the database analyzed recently?
> Hm... there was smth like auto analyzer in serverl
Chris:
There are a number of solutions on the market. A company called Soasta
has a cloud based testing solution, my company has a product/solution
that's highly customizable called StressWalk. On another computer I
have a larger list with some ranking info I can send if you are interested.
The query:
select events_events.id FROM events_events
left join events_event_types on events_events.eventType_id=
events_event_types.id
where events_event_types.severity=70
and events_events.cleared='f'
order by events_events.dateTime DESC
The main problem seems to be lack of a suitabl
On Fri, Jul 31, 2009 at 1:11 PM, Kees van Dieren wrote:
> It takes 155ms to run this query (returning 2 rows)
>
> Query plan: without limit:
> "Sort (cost=20169.62..20409.50 rows=95952 width=16)"
Could you send the results of EXPLAIN ANALYZE for both queries?
Evidently the planner is expecting a
Hi folks,
We have problems with performance of a simple SQL statement.
If we add a LIMIT 50, the query is about 6 times slower than without a limit
(query returns 2 rows).
I have read this discussion:
http://archives.postgresql.org/pgsql-performance/2008-09/msg5.php but
there seems to be no