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 table
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 wro
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
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
I have the following query that is a part of a function:
select order_details.tpv_success_id, order_details.tpv_id,
order_details.ver_code, order_details.app_id,
order_details.acct_id, order_details.first_name || ' ' ||
order_details.last_name as customer_name,
order_details.order_
l time=0.009..0.017 rows=2 loops=1)
Total runtime: 2.084 ms
With nested loops enabled does it choose to use them because it sees the estimated start up cost with loops as less? Does it not know that the total query would be faster with the Hash Joins? This query is in development right now, and as such there are not many rows. When it goes to production the reconciliation table will grow by about 50 – 100 rows per day where the transferred_date is NULL (this is the driving criteria behind this query.) As the table grows can I expect Pg to realize the the nested loops will be slower and will it switch to the Hash Joins? If not how would I force it to use the Hash Joins without just turning off nested loops completely? Is it a good idea to turn off nested loops completely?
Statistics collecting and auto vacuum is enabled btw. I have an erd diagram showing the table structures if anyone is interested in looking at it, just let me know.
Thanks,
Ketema
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?
13 matches
Mail list logo
