Is there a way to make the query planner consider pulling inner appends
outside joins?
Example:
natural_person inherits from person (obviously)
admpostgres3=# explain analyze select u.name, p.name from users u, person p
where p.user_id = u.id and u.name = 's_ohl';
--On Mittwoch, August 24, 2005 16:26:40 -0400 Chris Hoover
<[EMAIL PROTECTED]> wrote:
On 8/24/05, Merlin Moncure <[EMAIL PROTECTED]> wrote:
Linux does a pretty good job of deciding what to cache. I don't think
this will help much. You can always look at partial indexes too.
Yes, but won't
The correct strategy IMHO would
be applying the order by and limit for each child table (which results
in an index scan, if possible), appending, then finally sorting a bunch
of rows, and limiting again.
This would be a win in some cases, and in many others a loss (ie, wasted
sort steps). The h
--On Freitag, Oktober 21, 2005 03:40:47 + "Christian Paul B. Cosinas"
<[EMAIL PROTECTED]> wrote:
I am having a confusion to the memory handling of postgreSQL.
I rebooted my Server which is a PostgreSQL 8.0 Running on Redhat 9, which
is a Dual Xeon Server and 6 gig of memory.
Of course there
Is it possible to have the planner consider the second plan instead of the
first?
admpostgres4=> explain analyze select * from users where id in (select
user_id from user2user_group where user_group_id = 769694);
QUERY PLAN
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I have the following query:
explain analyze
SELECT
(cast((
SELECT cast(row(1, o.id, NULL, NULL, NULL, NULL) as something)
FROM ONLY object o WHERE o.id = l.e
UNION ALL
SELECT cast(row(2, l2.id, l2.s, l2.e, l2.intensity, N
er. So I tried the
query in the original post, and found the execution plan to be suboptimal.
Today I tried to do it with OUTER JOINs
but failed utterly. So what is the best way to get the results? The original
query is exactly what I need, only the plan
is bad. Any Ideas?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a two relevant tables:
fastgraph=# \d object
Table "public.object"
Column | Type | Modifiers
- ++--
id | bigint | not null default nextval
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
how hard would it be to give users the ability to
configure different random_page and seq_page costs per tablespace?
Obviously this does not match with random_page_cost being a GUC variable
but nonetheless I think it'd make a nice feature.
I jus
