> On Mon, 30 Aug 2004, Martin Sarsale wrote:
> > "Multicolumn indexes can only be used if the clauses involving the
> > indexed columns are joined with AND. For instance,
> >
> > SELECT name FROM test2 WHERE major = constant OR minor = constant;
>
> You can use DeMorgan's Theorem to transform an O
Michael,
> I am sorry that my question is out of line with this
> group(performance) but I need
>
> an urgent help :-( .pls .. I need to know how to change the length of the
> column.
In the future, try to provide more detail on your problem.Fortunately, I
think I know what it i
On Mon, 30 Aug 2004, Martin Sarsale wrote:
> "Multicolumn indexes can only be used if the clauses involving the
> indexed columns are joined with AND. For instance,
>
> SELECT name FROM test2 WHERE major = constant OR minor = constant;
You can use DeMorgan's Theorem to transform an OR clause to an
Thanks for the reply,
Been reading hackers of Aug 2004 and found the threads. It's a common habit to
create two lines on the configuration files, in order to maintain the copy of the
default conf file. I guess this should be the worst scenery for a freshly incoming DBA
trying to put things in
This issue was resently discussed on hackers. It is a known issue, not very
convinient for the user. Nevertheless it is not fixed in 8.0, but will
perhaps be addressed in the next major release.
(Remembering, it was a non-trivial thing to change.)
Best Regards,
Michael Paesold
G u i d o B a r o s
Hi Greg, Tom, etal
It's true that oracle only peeks during a hard parse, and this can have good or bad
results
depending on the situation. Basically, the first value used in that query will
determine the plan
until that query is bumped from the sql cache or the server is restarted. As far as I
G u i d o B a r o s i o wrote:
Conclusion:
If you comment a line on the conf file, and reload it, will remain in
the last state. (either wast true or false, while I expected a
default)
Yes, that's correct. No, you're not the only one to have been caught out
by this.
--
Richard Huxton
Archonet
Again me,
To make it easier.
Situation A:
log_something = true
Situation B:
# log_something =
Situation C:
log_something = false
After the pg_ctl reload:
Situation B = Situation A
Situation C <> (Situation A || Situation B)
Is this the expected behavior?
Conclusion:
If you comment a
The solution appeared as something I didn't know
On the .conf file
Previous situation:
#log_something=false
log_something=true
Worst situation
#log_something=false
#log_something=true
Nice situation
log_something=false
#log_something=true
Ok, the problem was that I assumed that commentin
On Wednesday 01 Sep 2004 3:36 pm, G u i d o B a r o s i o wrote:
> Dear all,
>
> I am currently experiencing troubles with the performance of my
> critical's database.
>
> The problem is the time that the postgres takes to perform/return a
> query. For example, trying the \d command takes betw
Dear all,
I am currently experiencing troubles with the performance of my critical's database.
The problem is the time that the postgres takes to perform/return a query. For
example, trying the \d command takes between 4 or 5 seconds. This table is
very big, but I am not asking for the row
Server HP: Intel(R) Pentium(R) 4 CPU 2.26GHz
RAM 1GB
OS: RedHat 8
And the disk:
kernel: megaide: driver version 05.04f (Date: Nov 11, 2002; 18:15 EST)
kernel: megaide: bios version 02.06.07221605
kernel: megaide: LD 0 RAID1 status=ONLINE sectors=156297343
capacity=76317 MB drives=2
From: "Michael Ryan S. Puncia" <[EMAIL PROTECTED]>
> I am sorry that my question is out of line with this
> group(performance) but I need
-general might be more appropriate
>
> an urgent help :-( .pls .. I need to know how to change the length of the
> column.
add a new column, use
- Original Message -
From: "Stefano Bonnin" <[EMAIL PROTECTED]>
To: "Josh Berkus" <[EMAIL PROTECTED]>
Sent: Monday, August 30, 2004 4:13 PM
Subject: Re: [PERFORM] Query performance issue with 8.0.0beta1
> This is my postgres.conf, I have changed only the work_mem and
> shared_buffers pa
14 matches
Mail list logo
