Re: [PERFORM] atrocious update performance

exed in both cases. Have you added indexes for the custid column for tables account.acct accunt.orgacct and note? I haven't followed the entire thread but it you have cascading FK on those tables without an index on the column that could cause your delay. Kevin Barnard SpeedFC --

Re: [PERFORM] Basic Postgresql Performance Question

sense to split them across different nodes if they're accessing the same memory- every memory access would have to be checked) like the PostgreSQL server. Look at www.linuxlabs.com they have a clustering system.  Not exactly the same thing but close to what I think you are looking for. -- Kevin Barnard

Re: [PERFORM] Timestamp-based indexing

ex will be used. If you assign a range the planner can fiqure out what you are looking for. -- Kevin Barnard Speed Fulfillment and Call Center [EMAIL PROTECTED] 214-258-0120 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PERFORM] Anyone familiar with Apple Xserve RAID

between performance and storage size for the drives. -- Kevin Barnard Speed Fulfillment and Call Center [EMAIL PROTECTED] 214-258-0120

Re: [PERFORM] Table UPDATE is too slow

Do all of the commands to swap tables in a transaction.  The table gets locked briefly but should have a lot less impact then the update command. On Mon, 06 Sep 2004 01:28:04 +0200, Marinos J. Yannikos <[EMAIL PROTECTED]> wrote: > > That said, I'm not entirely sure how well postgres' client libr

Re: [PERFORM] This query is still running after 10 hours...

What does observations_trigger do? On Tue, 28 Sep 2004 08:19:57 -0600, Robert Creager <[EMAIL PROTECTED]> wrote: > > Help? > > Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's > been running for more than 10 hours. > > Can it be helped? > > UPDATE obs_v > SET m

Re: [PERFORM] This query is still running after 10 hours...

On Tue, 28 Sep 2004 20:21:40 -0600, Robert Creager <[EMAIL PROTECTED]> wrote: > > The trigger keeps another table (catalog) up to date with the information from the > obs_v and obs_i tables. There are no direct insert/update/delete's on the catalog > table, only though the trigger. > It's pos

[PERFORM] Increasing number of PG connections.

most everything else fits in a T1 with a single DB server handling multiple sites. Does anybody with experence in this realm have any suggestions? Thank you in advance for whatever help you can provide. -- Kevin Barnard ---(end of broadcast)--- TIP

Re: [PERFORM] Increasing number of PG connections.

up to load. For most of the time the sytem sits around 100-300 connections. Once it ramps up it ramps up hard. Top starts cycling at 0 and 133% CPU for irq, softirq and iowait. The system stays at 700 connections until users give up. I can watch bandwidth utilization drop to almost noth

Re: [PERFORM] Increasing number of PG connections.

t until the afternoon before I see system load start to max out. Thanks for the tips I'm crossing my fingers. -- Kevin Barnard ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] FreeBSD config

On 26 Feb 2004 at 13:58, Dror Matalon wrote: > > which brings me back to my question why not make Freebsd use more of its > memory for disk caching and then tell postgres about it. > I think there is some confusion about maxbufsize and hibufspace.  I looking at a comment in the FreeBSB  s