ult, as it is in production and the
customer has a very low tolerance for downtime.
Just a dump of my thought process from someone who's been spending too
much time tuning his SAN and postgres lately.
Thanks for all the suggestions, John. I'll keep trying to follow s
Scott Marlowe wrote:
On Thu, 2006-06-15 at 16:50, Tim Allen wrote:
We have a customer who are having performance problems. They have a
large (36G+) postgres 8.1.3 database installed on an 8-way opteron with
8G RAM, attached to an EMC SAN via fibre-channel (I don't have details
of the EM
Jeff Trout wrote:
On Jun 16, 2006, at 5:11 AM, Tim Allen wrote:
One curious thing is that some postgres backends seem to spend an
inordinate amount of time in uninterruptible iowait state. I found a
posting to this list from December 2004 from someone who reported
that very same thing. For
Tim Allen wrote:
We have a customer who are having performance problems. They have a
large (36G+) postgres 8.1.3 database installed on an 8-way opteron with
8G RAM, attached to an EMC SAN via fibre-channel (I don't have details
of the EMC SAN model, or the type of fibre-channel card a
We have a customer who are having performance problems. They have a
large (36G+) postgres 8.1.3 database installed on an 8-way opteron with
8G RAM, attached to an EMC SAN via fibre-channel (I don't have details
of the EMC SAN model, or the type of fibre-channel card at the moment).
They're runn
of the query planner, in
that it doesn't realise that the partial index is all it needs here? Or
is something else going on that is leading the cost estimation astray?
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 6: explain analyze is your friend
which is hosted on the same
database server.
I don't know what "70 lac" means.
One lac (also spelt "lakh") is one hundred thousand. And one crore is
ten million. Indians count differently from the rest of the world :-).
Tim
--
--------
