Re: [PERFORM] Huge Data sets, simple queries

process. I can confirm this behavior after looking at my multipathed fibre channel SAN. To the best of my knowledge, the multipathing code uses the same underlying I/O code as the Linux SW RAID logic. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http

Re: [PERFORM] Advice on RAID card

ingly low overhead. My $0.02, hope it helps. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PERFORM] Postgresql on an AMD64 machine

642 pages swapped 128 Swap performance: 0 attempts 0 successes -- Semaphore Status used arrays = 7 allocated semaphores = 119 -- Messages: Status allocated queues = 0 used headers = 0 used space = 0 bytes Did you perhaps disable spinlocks when compiling PG? -- Mi

Re: [PERFORM]

larly load several table totaling around 50M rows with a single COPY per table. I drop (actually, this is during DB reload, so I don't yet create...) all fkeys, constraints and indexes and the data loads in a matter of 5 minutes or so. Hope that helps! -- Mike Rylander [EMAIL PROTECT

Re: [PERFORM] Table Partitioning: Will it be supported in Future?

n any list wander on so aimlessly for so long. Please, mommy, make it stop! -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Opteron vs Xeon (Was: What to do with 6 disks?)

L585 with 16G of RAM and an HP SCSI array, and I have absolutely zero complaints. :) -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Sustained inserts per sec ... ?

ated to various tasks? shared buffers: 15000 > What else is happening on your system? Nothing on mine. > Tell us more about disk set-up and other hardware related things. 6-disk RAID10 on a Compaq SmartArray 6404 with 256M BB cache, WAL on 2-disk mirror on built in SmartArray5 controlle

Re: [PERFORM] How to speed up word count in tsearch2?

shrink the time for the first query on any particular set of words, and it would make everything else faster as a nice side effect. What does your disk layout look like now? -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org --

Re: [PERFORM] Tsearch2 performance on big database

at your settings are, howmuch memory you have and such? 16G of RAM on a dedicated machine. shared_buffers = 15000 # min 16, at least max_connections*2, 8KB each work_mem = 10240# min 64, size in KB maintenance_work_mem = 100 # min 1024, size in KB # big m_w_m for load

Re: [PERFORM] Tsearch2 performance on big database

know. Unless I'm mistaken, he (co)wrote tsearch2. Other than shared buffers, I can't imagine what could be causing that kind of slowness. EXPLAIN ANALYZE, please? As an example of what I think you *should* be seeing, I have a similar box (4 procs, but that doesn't matter for one q

Re: [PERFORM] queries on huge tables

ind of anoyes me a bit :) > > Does anyone of you have some good ideas on how speed up such queries on > huge tables? > > regards > rune > > > > -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PERFORM] Performance Tuning

e stats :( > 3. Continue to tweak the sql behind our app. Short of an Opteron based system, this is by far your best bet. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--

Re: [PERFORM] LIMIT causes SEQSCAN in subselect

L generator will toss the preplanned ones into subselects and join them in the outer query instead of having to rip them apart and calculate the join syntax. And yes, I know that view will take care of most of that for me... :) Thanks for all your comments. Pretty much what I expected, but I tho

[PERFORM] LIMIT causes SEQSCAN in subselect

--- Limit (cost=0.00..16.19 rows=9 width=87) (actual time=0.026..0.035 rows=7 loops=1) -> Index Scan using metarecord_field_entry_source_idx on metarecord_field_entry (cost=0.00..16.19 rows=9 width=87) (actual time=0.025..0

Re: [PERFORM] Alternatives to Dell?

; > I don't know this for a fact, it is just what one of their > "ahem" sales guys told me. > At least in that case they were being accurate. ;) -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org -

Re: [PERFORM] Alternatives to Dell?

ute, PG with linux-amd64 on HP/Opterons, as opposed to the E20K monster that was originally spec'd out. Mail me direct if you want the full spec list on this beast. And if there is a ready-made benchmark anyone would like me to run, just drop me a note. -- Mike Ryland

Re: [PERFORM] VACUUM ANALYZE downgrades performance

lyze each 5 > seconds'. > See this thread (http://archives.postgresql.org/pgsql-hackers/2004-11/msg00985.php and http://archives.postgresql.org/pgsql-hackers/2004-11/msg01080.php) for an ongoing discussion of the issue. -- Mike Rylander [EMAIL PROTECTED] GPLS -- P

Re: [PERFORM] memcached and PostgreSQL

; -- > greg > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faqs/FAQ.html > -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database

Re: [PERFORM] int4 in a GiST index

On Wed, 10 Nov 2004 18:50:28 -0800 (PST), George Essig <[EMAIL PROTECTED]> wrote: > Mike Rylander wrote: > > > I want to create a multi-column index across the tsvector and classification > > columns as that should help with selectivity. But because there is no >

[PERFORM] int4 in a GiST index

done before, but I've note found the magic spell. Of course, I may just be barking up the wrong tree altogether... Thanks in advance! -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PERFORM] Does PostgreSQL run with Oracle?

On Fri, 15 Oct 2004 11:54:44 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > My basic question to the community is "is PostgreSQL approximately as fast > as Oracle?" My personal experience comparing PG to Oracle is across platforms, Oracle on Sun/Solaris (2.7, quad-proc R440) and PG on Intel

Re: [PERFORM] Partitioning

On 15 Sep 2004 23:55:24 -0400, Greg Stark <[EMAIL PROTECTED]> wrote: > > "J. Andrew Rogers" <[EMAIL PROTECTED]> writes: > > > We do something very similar, also using table inheritance > > I have a suspicion postgres's table inheritance will end up serving as a good > base for a partitioned tabl

Re: [PERFORM] vacuum full 100 mins plus?

Tom Lane wrote: > Christopher Browne <[EMAIL PROTECTED]> writes: >> A long time ago, in a galaxy far, farpliers [EMAIL PROTECTED] (Patrick >> Hatcher) wrote: >>> Answered my own question. I gave up the vacuum full after 150 mins. I >>> was able to export to a file, vacuum full the empty table, a