Hi,
Another "funny" thing: I have a query which runs
on (Linux) PostgreSQL 7.4.x under 10 sec. I tried
to run it on (Windows) PostgreSQL 8.0 yesterday.
It didn't finished at all! (I shoot it down after 10 minutes)
I made various tests and I figured out something interesting:
The same query with:
-huh-
A lot of High-Tech ideas. But there is another way:
Simply measure the current IO load (pro DB if you must),
make an estimation how it could change in the future
(max. 3 years) and make a worst case scenario.
Than you should make a new array each time the
worst case scenario hits the IO b
On Fri, Feb 25, 2005 at 03:41:58PM +0800, SpaceBallOne wrote:
> Our dual opteron has been performing well for many weeks now (after some
> simple tuning) when all of a sudden the queries have slowed right down!
Are you running regular VACUUMs? Looks like you have a lot of dead rows or
something.
Given some recent posts / irc issues with dead tuple bloat..
And given that a lot of these people have at least been smart enough to
explain analyze would it be A. possible B. useful C. None of the above
to have various "scan" nodes of explain analyze also report how many
invisible / dead tuples
On Fri, 25 Feb 2005, Vig, Sandor (G/FI-2) wrote:
> Hi,
>
> Another "funny" thing: I have a query which runs
> on (Linux) PostgreSQL 7.4.x under 10 sec. I tried
> to run it on (Windows) PostgreSQL 8.0 yesterday.
> It didn't finished at all! (I shoot it down after 10 minutes)
> I made various tests
Jeff <[EMAIL PROTECTED]> writes:
> Given some recent posts / irc issues with dead tuple bloat..
> And given that a lot of these people have at least been smart enough to
> explain analyze would it be A. possible B. useful C. None of the above
> to have various "scan" nodes of explain analyze also
On Wed, Feb 23, 2005 at 01:37:28PM -0500, Tom Lane wrote:
> "Bruno Almeida do Lago" <[EMAIL PROTECTED]> writes:
> > Is there a real limit for max_connections? Here we've an Oracle server with
> > up to 1200 simultaneous conections over it!
>
> [ shrug... ] If your machine has the beef to run 1200
Hi, Gaetano,
Gaetano Mendola schrieb:
> Yes, I'm aware about it indeed I need the analyze because usualy I do on that
> table select regarding last 24 ours so need to analyze it in order to
> collect the statistics for this period.
If you tend to do lots of queries for the last 24 hours, and th
