On 11/26/2008 06:44 PM, [EMAIL PROTECTED] wrote:
> Try running EXPLAIN ANALYZE - that gives much more information. For
> example it may show differences in number of rows between the two
> machines, that the statistics are not up to date, etc.
Thanks a lot for this tip
--
[ Clemens Schwaighofer
Try running EXPLAIN ANALYZE - that gives much more information. For
example it may show differences in number of rows between the two
machines, that the statistics are not up to date, etc.
regards
Tomas
> Hi,
>
> I have system here with Debian/Testing and the latest 8.2 and 8.3
> database install
On 11/26/2008 03:20 PM, Scott Marlowe wrote:
> On Tue, Nov 25, 2008 at 10:22 PM, Clemens Schwaighofer
> <[EMAIL PROTECTED]> wrote:
>> On 11/26/2008 02:15 PM, Scott Marlowe wrote:
>>> Are there more rows in the 8.2 table you're testing on? Or is the
>>> whole table small enough to fit on a few page
On Tue, Nov 25, 2008 at 10:22 PM, Clemens Schwaighofer
<[EMAIL PROTECTED]> wrote:
> On 11/26/2008 02:15 PM, Scott Marlowe wrote:
>>
>> Are there more rows in the 8.2 table you're testing on? Or is the
>> whole table small enough to fit on a few pages?
>
> I highly doubt that. I have right now in o
On 11/26/2008 02:15 PM, Scott Marlowe wrote:
> On Tue, Nov 25, 2008 at 10:07 PM, Clemens Schwaighofer
> <[EMAIL PROTECTED]> wrote:
>> On 11/26/2008 02:04 PM, Scott Marlowe wrote:
>>> On Tue, Nov 25, 2008 at 8:39 PM, Clemens Schwaighofer
>>> <[EMAIL PROTECTED]> wrote:
but on the 8.3 version i g
On Tue, Nov 25, 2008 at 10:07 PM, Clemens Schwaighofer
<[EMAIL PROTECTED]> wrote:
> On 11/26/2008 02:04 PM, Scott Marlowe wrote:
>> On Tue, Nov 25, 2008 at 8:39 PM, Clemens Schwaighofer
>> <[EMAIL PROTECTED]> wrote:
>>> but on the 8.3 version i get this back
>>>
>>> # explain select * from foo f, b
On 11/26/2008 02:04 PM, Scott Marlowe wrote:
> On Tue, Nov 25, 2008 at 8:39 PM, Clemens Schwaighofer
> <[EMAIL PROTECTED]> wrote:
>> but on the 8.3 version i get this back
>>
>> # explain select * from foo f, bar b where f.foo_id = b.foo_id;
>>QUERY PLAN
>> -
On Tue, Nov 25, 2008 at 8:39 PM, Clemens Schwaighofer
<[EMAIL PROTECTED]> wrote:
> but on the 8.3 version i get this back
>
> # explain select * from foo f, bar b where f.foo_id = b.foo_id;
>QUERY PLAN
> --
