On Thursday 18 August 2005 10:16 am, [EMAIL PROTECTED] wrote:
> BTW, the default postgresql settings are WAY too conservative.
The archives are full of discussion on this issue. PG runs on several
operating systems and is installed on machines ranging from slow
single-cpu multi-service machines
al@postgresql.org
> Subject: Re: [GENERAL] Same database, different query plans
>
> On Thu, Aug 18, 2005 at 12:03:59PM +0300, WireSpot wrote:
> > The actual SELECT results (ie. non EXPLAIN) are identical in both
> > cases. The indexes and so on are identical. I've done a
On Thu, Aug 18, 2005 at 12:03:59PM +0300, WireSpot wrote:
> The actual SELECT results (ie. non EXPLAIN) are identical in both
> cases. The indexes and so on are identical. I've done a reindexing and
> vacuuming on both of them just to be sure.
>
> As you can see, there's quite a bit of a differenc
