Hi Scott,
I think it would be nice to log the reasons why an explain analyze chooses a
specific way or another for an execution plan. This would avoid wasting time
to find the source of these decisions from the existing logs.
Is it possible ?
TIA,
Sabin
--
Sent via pgsql-performance
I use postgresql-8.2-506.jdbc3.jar, maybe helps
Sabin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Hi again,
Should I use gjournal on FreeBSD 7? Or just soft updates?
Here is my opinion: I suspect that gjournal would be much slower than
soft updates. Also gjournal is relatively new code, not very well
tested. But gjournal is better when the system crashes. Although I have
heard that
Should I use gjournal on FreeBSD 7? Or just soft updates?
Here is my opinion: I suspect that gjournal would be much slower than
soft updates. Also gjournal is relatively new code, not very well
tested. But gjournal is better when the system crashes. Although I have
heard that sometimes
On Wed, Sep 24, 2008 at 1:18 PM, Laszlo Nagy [EMAIL PROTECTED] wrote:
Here is my opinion: I suspect that gjournal would be much slower than
soft updates. Also gjournal is relatively new code, not very well
tested.
In some cases it's much faster than SU, in other a bit slower. :)
gjournal is
On Wed, 24 Sep 2008, Sabin Coanda wrote:
I think it would be nice to log the reasons why an explain analyze chooses a
specific way or another for an execution plan. This would avoid wasting time
to find the source of these decisions from the existing logs.
That would probably fill up the logs
Scott Carey wrote:
A fantastic review on this issue appeared in July:
http://www.alternativerecursion.info/?p=106
And then the same tests on a RiData SSD show that they are the same
drive with the same characteristics:
http://www.alternativerecursion.info/?p=276
Most blamed it on MLC being
Am 24.09.2008 um 12:18 schrieb Laszlo Nagy:
Should I use gjournal on FreeBSD 7? Or just soft updates?
I'm using gjournal for 5 weeks now on my production server.
There are 4 journaled filesystems on a raid controller with
BBU. pg uses 23GB out of 1.6TB. I can't see any performance impact or
On Tue, Sep 23, 2008 at 3:57 PM, Richard Broersma
[EMAIL PROTECTED] wrote:
SELECT A.dimension_book.call, SUM( B.dimension_book.call ) AS
OrderedRowNbr
FROM ( your_above_query_without_the_limits ) AS A
INNER JOIN ( your_above_query_without_the_limits ) AS B
ON A.dimension_book.call =