mapping a class hierarchy to
> table(s). A few techniques are described in Fowler's
> Patterns of Enterprise Application Architecture.
>
> hope this helps,
>
> Eugene
>
>
> --- Edmund Dengler <[EMAIL PROTECTED]> wrote:
>
> > Greetings!
> >
> &
Greetings!
I have already increased the stats from 10 to 100. In addition, if I
specify individual tables, then the indexes are used. However, when I go
through the , then indexes are not used. I will try and expand
the statistics, but suspect it is not the root cause of the problem.
Regards!
Ed
causes the
indexes to be used - still trying to make sure it is a legitimate method).
Regards!
Ed
-- Forwarded message --
Date: Fri, 29 Jul 2005 14:23:29 -0400 (EDT)
From: Edmund Dengler <[EMAIL PROTECTED]>
To: Postgresql-General
Subject: Re: [GENERAL] Failure to use i
set to compare against), I get sequential scanning,
event though the set size is only a single element.
Regards!
Ed
On Fri, 29 Jul 2005, Edmund Dengler wrote:
> Greetings!
>
> I am using to partition several tables. When I perform a query
> on another table, and then try to join against
Greetings!
I am using to partition several tables. When I perform a query
on another table, and then try to join against an inherited table set, the
optimizer does not use any indexes to perform the join.
This is 8.0.1. Is this fixed in 8.0.2 or 8.0.3?
The query:
explain
select *
from (
se
e delete was taking less than a second.
>
> Hope it help
> /David
>
>
>
> >Regards!
> >Ed
> >
> >
> >On Fri, 10 Jun 2005, Richard Huxton wrote:
> >
> >
> >
> >>Edmund Dengler wrote:
> >>
> >>
> >&
, I would expect I/O issues/bounds
and not CPU.
Regards!
Ed
On Fri, 10 Jun 2005, Richard Huxton wrote:
> Edmund Dengler wrote:
> > Greetings!
> >
> > We have a table with more than 250 million rows. I am trying to delete the
> > first 100,000 rows (based on a bigint
Greetings!
We have a table with more than 250 million rows. I am trying to delete the
first 100,000 rows (based on a bigint primary key), and I had to cancel
after 4 hours of the system not actually finishing the delete. I wrote a
script to delete individual rows 10,000 at a time using transaction
Greetings!
Is there an issue when a large number of INHERITS tables exist for
planning?
We have 2 base tables, and use INHERITS to partition the data. When we get
around 2000-2200 sub-tables (approx 1000-1100 per base table), planning a
SELECT statement on the base table (ie, to search all sub-ta
Greetings!
Does anybody know how well the optimizer works when dealing with inherited
tables? I am currently using 8.0.1.
I have a table called eventlog.record_main, and a number of inherited
tables to partition the data (called
eventlog_partition.___record_main). is the primary key (all
tables
(Sorry, wrong subject line got sent)
Greetings!
Does anybody know how well the optimizer works when dealing with inherited
tables? I am currently using 8.0.1.
I have a table called eventlog.record_main, and a number of inherited
tables to partition the data (called
eventlog_partition.___record_m
Hi Tom!
Yep, there are a large number of host_luid/log_luid combinations (there
are approximatly 5-10 hosts and 1-3 logs per system we are running).
Thanks for the recommended workaround, I'll have a try at it at some point
tomorrow.
Regards!
Ed
On Sat, 15 Jan 2005, Tom Lane wrote:
>
Greetings!
I have a technical question concerning multi-column indexes and their
implementation. I tried looking for the answr in the docs but couldn't
find anything.
I have the following table:
eventlog=> \d agent.record
Table "agent.record"
Colu
Greetings!
On Fri, 2 Jul 2004, Mike Rylander wrote:
> I find that experience does not bear this out. There is a saying a coworker
> of mine has about apps that try to solve problems, in this case caching,
> that are well understood and generally handled well at other levels of the
> "software st
Hi folks!
A query I am running does not seem to use indexes that are available
(running version 7.4.2). I have the following table:
=> \d replicated
Table "public.replicated"
Column | Type |
Modifiers
-+
s not in the specification)?
Performance? No support from the back-end? Something else?
Regards,
Ed
On Wed, 15 Oct 2003, Tom Lane wrote:
> Edmund Dengler <[EMAIL PROTECTED]> writes:
> > ... I have no real choice in this as there is no way to specify that
> > NULL == NULL.
>
The problem I would face is that this still needs to be a sequential scan
in the table rather than an index lookup.
Regards,
Ed
On Tue, 14 Oct 2003, Arthur Ward wrote:
> > Is the rewrite only for the literal 'X = NULL' or will it do a test
> > against a value such as 'X = OLD.X' (and rewrite is
dummy value for the 'Not a valid value', but it seems to be quite awkward
when I really do want the NULL.
Regards!
Ed
On Mon, 13 Oct 2003, Bruno Wolff III wrote:
> On Mon, Oct 13, 2003 at 21:16:33 -0400,
> Edmund Dengler <[EMAIL PROTECTED]> wrote:
> >
> > I
Hi all!
I am doing some trigger functions that need to find a tuple in another
table. The problem is that this second table is doing some summarization
work, and I need nulls to equal each other.
Basically, in the trigger I do a:
SELECT INTO ... x
FROM table1
WHERE ...(some straightforward
ble amount of time, and of doing it.
Regards!
Ed
On Thu, 21 Aug 2003, Andrew Sullivan wrote:
> On Thu, Aug 21, 2003 at 12:05:28PM -0400, Edmund Dengler wrote:
> > Well, if they are locked waiting on vacuum, then vacuum should upgrade
> > it's priority to the highest waiting proce
Wasn't there a feature in some SQL database which was the equivalent of
UPDATE OR INSERT ... based on the primary key? Would this accomplish what
you want (I know that I have a desire for this feature a couple of times,
as I simply have code or triggers to essentially do the equivalent)? Is
this a
Well, if they are locked waiting on vacuum, then vacuum should upgrade
it's priority to the highest waiting process (priority inheritance).
This way, vacuum will be running at a priority level equivalent to who is
waiting on it.
Regards,
Ed
On Thu, 21 Aug 2003, Andrew Sullivan wrote:
> On Wed, A
What about the use of priority inheritance to deal with the issue of
priority inversion (a standard methodology within the real-time world)?
Then we could have priorities, but still have low priority processes
bumped up if a high level one is waiting on them.
Regards,
Ed
On Wed, 20 Aug 2003, Tom
You need to convert the int's to bigints.
select id where col1 = 1::bigint and col2 = 1::bigint
Regards,
Ed
-Original Message-
From: Tim McAuley <[EMAIL PROTECTED]>
Date: Wed, 30 Jul 2003 13:46:46
To:[EMAIL PROTECTED]
Subject: [GENERAL] Unused Indexes
Hi,
I have a table which I have p
24 matches
Mail list logo
