Re: [PERFORM] One or more processor ?

2003-10-13 Thread James Rogers
ned tables tend to be huge almost by definition. Offhand, it would seem that this would be a feature largely restricted to threaded database kernels for a couple different pragmatic reasons. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)---

Re: [PERFORM] PostgreSQL Scalable ?

2003-10-10 Thread James Rogers
I've found. A lot of scalability is how you set the parameters and design the system if the underlying engine is reasonably competent. For the vast majority of purposes, you'll find that PostgreSQL scales just fine. Cheers, -James Rogers [EMAIL PROTECTED] --

[PERFORM] Seqscan buffer promotion (was: reindex/vacuum locking/performance?)

2003-10-06 Thread James Rogers
add that I don't know what PostgreSQL actually does in this regard, but from the thread it appears as though seqscans are handled like the default case. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/rea

[PERFORM] Uses for Index/Function organizing

2003-10-04 Thread James Rogers
need to understand the limitations, nonetheless when tables and databases get really big it becomes an important tool in the tool belt. Cheers, -James Rogers [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])