[PERFORM] What's better: Raid 0 or disk for seperate pg_xlog

theoretically better? 1) OS and pg_xlog on one disk, rest of postgresql on the other? (if I understand the above correctly) 2) Everything striped Raid 0? 3) some answer from someone smarter than me TIA, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural

Re: [PERFORM] What's better: Raid 0 or disk for seperate pg_xlog

- next 2 disks: RAID 0 across the above Do I grok it? Thanks again, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile: (928) 699-9221

Re: [PERFORM] Hardware questions

://archives.postgresql.org/pgsql-performance/2005-03/msg00177.php http://archives.postgresql.org/pgsql-performance/2005-03/msg00238.php http://archives.postgresql.org/pgsql-performance/2005-03/msg00406.php HTH, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural

[PERFORM] Delete query takes exorbitant amount of time

here: http://ccl.cens.nau.edu/~kan4/testing/long-delete Where do I go from here? Thanks in advance, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile

Re: [PERFORM] Delete query takes exorbitant amount of time

On Thu, 2005-03-24 at 19:52 -0500, Tom Lane wrote: Karim Nassar [EMAIL PROTECTED] writes: Here is the statement: orfs=# explain analyze DELETE FROM int_sensor_meas_type WHERE id_meas_type IN (SELECT * FROM meas_type_ids); QUERY

Re: [PERFORM] Delete query takes exorbitant amount of time

timestamp with time zone NOT NULL DEFAULT now(), created_by TEXT NOT NULL REFERENCES public.person(id_person)); CREATE INDEX measurement__id_int_sensor_meas_type_idx ON measurement(id_int_sensor_meas_type); Regards, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering

Re: [PERFORM] Delete query takes exorbitant amount of time

rows=0 loops=1) Filter: (id_int_sensor_meas_type = $1) Total runtime: 11608.441 ms (3 rows) -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868

Re: [PERFORM] Delete query takes exorbitant amount of time

On Sat, 2005-03-26 at 15:18 -0800, Stephan Szabo wrote: On Sat, 26 Mar 2005, Karim Nassar wrote: On Sat, 2005-03-26 at 07:55 -0800, Stephan Szabo wrote: That seems like it should be okay, hmm, what does something like: PREPARE test(int) AS SELECT 1 from measurement where

Re: [PERFORM] [BUGS] BUG #1552: massive performance hit between 7.4

why those recommendations are good ones - but they are clear. Simon, this begs the question: what changed from 7.4-8.0 to require he modify his script? TIA, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University

Re: [PERFORM] Delete query takes exorbitant amount of time

if there is other general tuning advice for such large table indexes such as increasing statistics, etc. Thanks, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868

Re: [PERFORM] Delete query takes exorbitant amount of time

create integer columns TIA, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile: (928) 699-9221 ---(end of broadcast

[PERFORM] VACUUM on duplicate DB gives FSM and total pages discrepancies

maintenance_work_mem 262144 16384 shared_buffers 3 1000 Thanks, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile: (928) 699-9221

Re: [PERFORM] Index ot being used

out. if ($do_db_optimization == 1) { $DB-do(SET ENABLE_SEQSCAN TO OFF) || die... } else { # do nothing -- postgresql will figure it out } -- Karim Nassar [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [PERFORM] Performance Tuning Article

above. Your probably only display active employees throughout the majority of the application... Do you mean You're probably only displaying? HTH, -- Karim Nassar [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

[PERFORM] What's a lot of connections?

. -- Karim Nassar [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Performance problems testing with Spamassassin 3.1.0

On Wed, 2005-07-27 at 14:35 -0800, Matthew Schumacher wrote: I put the rest of the schema up at http://www.aptalaska.net/~matt.s/bayes/bayes_pg.sql in case someone needs to see it too. Do you have sample data too? -- Karim Nassar Collaborative Computing Lab of NAU Office: (928) 523 5868

[PERFORM] Two queries are better than one?

= '343B'::bpchar) AND (ord_id = '12-645'::bpchar)) - Index Scan using client_pkey on client (cost=0.00..5.98 rows=1 width=51) (actual time=0.023..0.026 rows=1 loops=1) Index Cond: (outer.ord_client = client.cli_code) Total runtime: 0.328 ms (6 rows) -- Karim Nassar [EMAIL PROTECTED

Re: [PERFORM] Two queries are better than one?

, and only one client to associate. Clearer? -- Karim Nassar [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [PERFORM] Performance problems testing with Spamassassin

at this point. If you need to support a massive initial data load, further time savings are to be had by doing COPY instead of 126,000 inserts. Please do keep us updated. Thanking all the gods and/or developers for spamassassin, -- Karim Nassar [EMAIL PROTECTED] ---(end

Re: [PERFORM] gist indexes for distance calculations

Thanks a lot for all the help, if you can lead me to any docs/articles, I'll gladly read them. I found this: http://en.wikipedia.org/wiki/R-tree http://en.wikipedia.org/wiki/R-treeLooks like what Tom was talking about, ja? Karim