Re: [PERFORM] Advice on RAID card

, 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

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? -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development

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

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?)

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 ... ?

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 controller. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES

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

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 ---(end of broadcast

Re: [PERFORM] Tsearch2 performance on big database

fetch cost # fast drives, and tons of RAM -- 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] queries on huge tables

-- 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

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)--- TIP 2: you can get off all lists at once

Re: [PERFORM] LIMIT causes SEQSCAN in subselect

... :) Thanks for all your comments. Pretty much what I expected, but I thought I'd raise a use case. I'll just have to give the query builder more smarts. -- Josh Berkus Aglio Database Solutions San Francisco -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http

[PERFORM] LIMIT causes SEQSCAN in subselect

=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.032 rows=7 loops=1) Index Cond: (source = 10) Total runtime: 0.069 ms (4 rows) -- Mike Rylander [EMAIL PROTECTED

Re: [PERFORM] Alternatives to Dell?

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 Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end

Re: [PERFORM] VACUUM ANALYZE downgrades performance

://archives.postgresql.org/pgsql-hackers/2004-11/msg01080.php) for an ongoing discussion of the issue. -- Mike Rylander [EMAIL PROTECTED] GPLS -- PINES Development Database Developer http://open-ils.org ---(end of broadcast)--- TIP 6: Have you

Re: [PERFORM] memcached and PostgreSQL

, get_user_info_by_session('123456789') WHERE f.userid = u.userid; Any thoughts? -- greg ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Mike Rylander [EMAIL

[PERFORM] int4 in a GiST index

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] 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 GiST opclass for INT4 the index creation

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

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 table feature. Is

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, and reimport