Thank you very much for great sample.
I tried to create testcase from this to match production db:
1.2 million orders
3.5 million order details
13400 products with char(20) as primary keys containing ean-13 codes
mostly
3 last year data
every order has usually 1..3 detail lines
same product
Gregory,
I would suggest running ANALYZE
idtellUued at some point before the problematic query.
Thank you.
After adding analyze all is OK.
Is analyze command required in 8.3 also ?
Or is it better better to specify some hint at create temp table time since
I know the number of rows before r
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Andrus" <[EMAIL PROTECTED]> writes:
>> There are indexes on rid(dokumnr) and dok(dokumnr) and dokumnr is int.
>> Instead of using single key index, 8.1.4 scans over whole rid table.
>> Sometimes idtelluued can contain more than single row so replacing
"Andrus" <[EMAIL PROTECTED]> writes:
> There are indexes on rid(dokumnr) and dok(dokumnr) and dokumnr is int.
> Instead of using single key index, 8.1.4 scans over whole rid table.
> Sometimes idtelluued can contain more than single row so replacing join with
> equality is not possible.
>
> How
--- On Sat, 22/11/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> I had an old workstation with a 4 port SATA card (no raid) running
> software raid and it handily stomps this 8 disk machine into the ground.
Yeah, I think this machine will be going that route.
> We had a bunch of 18xx series serv
Both queries return same result (19) and return same data.
Pattern query is a much slower (93 sec) than equality check (13 sec).
How to fix this ?
Using 8.1.4, utf-8 encoding, et-EE locale.
Andrus.
SELECT sum(1)
FROM dok JOIN rid USING (dokumnr)
JOIN toode USING (toode)
WHERE rid.toode =
There are indexes on rid(dokumnr) and dok(dokumnr) and dokumnr is int.
Instead of using single key index, 8.1.4 scans over whole rid table.
Sometimes idtelluued can contain more than single row so replacing join with
equality is not possible.
How to fix ?
Andrus.
CREATE TEMP TABLE idtellUu
You could perhaps run a little check on the performance of the RAID, is
it better than linux software RAID ?
Does it leverage NCQ appropriately when running queries in parallel ?
I was told that this RAID is software RAID.
I have no experience what to check.
This HP server was installed 3 years
On Sat, Nov 22, 2008 at 9:59 AM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> --- On Sat, 22/11/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
>> You really have two choices. First is to try and use it as
>> a plain
>> SCSI card, maybe with caching turned on, and do the raid in
>> software.
>> Second
On Fri, 21 Nov 2008 21:07:02 +0100, Tom Lane <[EMAIL PROTECTED]> wrote:
PFC <[EMAIL PROTECTED]> writes:
Index on orders_products( product_id ) and orders_products( order_id ):
=> Same plan
Note that in this case, a smarter planner would use the new index to
perform a BitmapAn
--- On Sat, 22/11/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> You really have two choices. First is to try and use it as
> a plain
> SCSI card, maybe with caching turned on, and do the raid in
> software.
> Second is to cut it into pieces and make jewelry out of it.
Haha, I'm not really into
On Sat, Nov 22, 2008 at 7:18 AM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> Hi chaps,
>
> I've had this old card sitting on my desk for a while. It appears to be a
> U160 card with 128Mb BBU so I thought I'd wang it in my test machine (denian
> etch) and give it a bash.
>
> I set up 4 36Gb drives i
Hi chaps,
I've had this old card sitting on my desk for a while. It appears to be a U160
card with 128Mb BBU so I thought I'd wang it in my test machine (denian etch)
and give it a bash.
I set up 4 36Gb drives in raid 0+1, but I don't seem to be able to get more
than 20MB/s write speed out of
13 matches
Mail list logo
