I am trying to build a very Robust DB server that will support 1000+
concurrent users (all ready have seen max of 237 no pooling being
used). i have read so many articles now that I am just saturated. I
have a general idea but would like feedback from others.
I understand query tuning and
I am definitely interested in upgrading.
Is there a guide out there that perhaps was created to explain the
changes in the config files from 8.1 to 8.2 ?
Migration guide I guess?
On Oct 30, 2007, at 11:39 AM, Tom Lane wrote:
Richard Huxton <[EMAIL PROTECTED]> writes:
Ketema wrote:
5)Upg
On Oct 30, 2007, at 9:31 AM, Michael Glaesemann wrote:
On Oct 30, 2007, at 7:18 , Ketema wrote:
here is the execution plan:
I've put this online here:
http://explain-analyze.info/query_plans/1259-ketema-2007-10-30
I have attached an erd of the tables used in this query. If it is
stripp
On Oct 30, 2007, at 9:23 AM, Richard Huxton wrote:
Ketema wrote:
I have the following query that is a part of a function:
Yikes! Difficult to get a clear view of what this query is doing.
It seems complicated because you only have a small subset of the
schema these tables tie into.
Be hap
Title: Nested Loops vs. Hash Joins or Merge Joins
I am attempting to learn more about the way Pg decides what operators to use in its query planning and executions. I have moderately complicated table layout, but it is mostly normalized I recently created a query:
select account.acct_name as "
The SAN has the snapshot capability.
On 4/27/06 9:31 AM, "Bruno Wolff III" <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 27, 2006 at 09:06:48 -0400,
> Ketema Harris <[EMAIL PROTECTED]> wrote:
>> Yes, your right, I meant not have to do the backups from the db serve
You all. I will keep researching this and the more input the better.
Thank You.
On 4/27/06 9:24 AM, "Michael Stone" <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 27, 2006 at 08:57:51AM -0400, Ketema Harris wrote:
>> OK. My thought process was that having non local storage as sa
wrote:
> On Thu, Apr 27, 2006 at 08:57:51 -0400,
> Ketema Harris <[EMAIL PROTECTED]> wrote:
>> performance from the db. I also would hopefully then not have to do
>> periodic backups from the db server to some other type of storage. Is this
>> not a good idea? How
igabit
backbone.
On 4/27/06 8:44 AM, "Michael Stone" <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 27, 2006 at 08:38:55AM -0400, Ketema Harris wrote:
>> I am looking for the best solution to have a large amount of disk storage
>> attached to my PostgreSQL 8.1 server.
&
2006 at 10:06:58PM -0400, Ketema Harris wrote:
>>> I was wondering if there were any performance issues with having a data
>>> directory that was an nfs mounted drive? Say like a SAN or NAS device? Has
>>> anyone done this before?
>>
>> My understanding is that NF
Title: Running on an NFS Mounted Directory
I was wondering if there were any performance issues with having a data directory that was an nfs mounted drive? Say like a SAN or NAS device? Has anyone done this before?
11 matches
Mail list logo
