Rhaoni,
>Where can I find a plan-readinf tutorial ?
It's a little out of date, but is very well written and gives you the basics:
http://www.argudo.org/postgresql/soft-tuning.html
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
Hi List;
Where can I find a plan-readinf tutorial ?
Atenciosamente,
Rhaoni Chiu Pereira
Sistêmica Computadores
Visite-nos na Web: http://sistemica.info
Fone/Fax : +55 51 3328 1122
---(end of broadcast)---
TIP 9: the planner will ignore
The TPC-H/R rules allow only minor changes to the SQL that are necessary
due to SQL implementation differences. They do not allow changes made to
improve performance. It is their way to test optimizer's ability to
recognize an inefficient SQL statement and do the rewrite.
The rule makes sense for
[EMAIL PROTECTED] writes:
> sort_mem = 2048
2 meg sort_mem seems on the small side.
> Yes I have an index on actvars.product_level and an index on
> prodlevel.code_level.Both indices have character(12) data types.
Can you force an indexscan to be chosen by setting enable_seqscan off?
If so, what
>Damn.. Seq. scan for actvars? I would say half an hour is a good throughput.
>
>Are there any indexes on both actvars.product_level and prodlevel.code_level?
Are >they exactly compatible type? int2 and int4 are not compatible in
postgresql >lingo.
>
>That plan should go for index scan. Can you sho
[EMAIL PROTECTED] wrote:
Hi guys
Im running a Datawarehouse benchmark (APB-1) on PostgreSql. The objective is to
choose which of the to main db (PostgreSQL, MySQL) is fastest. I've run into a
small problem which I hope could be resolved here.
I'm trying to speed up this query:
select count(*) fr