Re: [PERFORM] vacuum full 100 mins plus?

2004-07-15 Thread Mike Rylander
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

Re: [PERFORM] Partitioning

2004-09-16 Thread Mike Rylander
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] Does PostgreSQL run with Oracle?

2004-10-15 Thread Mike Rylander
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

[PERFORM] int4 in a GiST index

2004-11-10 Thread Mike Rylander
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

2004-11-10 Thread Mike Rylander
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] memcached and PostgreSQL

2004-11-17 Thread Mike Rylander
, 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

Re: [PERFORM] VACUUM ANALYZE downgrades performance

2004-11-30 Thread Mike Rylander
://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] Alternatives to Dell?

2004-12-01 Thread Mike Rylander
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

[PERFORM] LIMIT causes SEQSCAN in subselect

2004-12-10 Thread Mike Rylander
=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] LIMIT causes SEQSCAN in subselect

2004-12-11 Thread Mike Rylander
... :) 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

Re: [PERFORM] Performance Tuning

2005-02-09 Thread Mike Rylander
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] queries on huge tables

2005-03-19 Thread Mike Rylander
-- 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] Tsearch2 performance on big database

2005-03-22 Thread Mike Rylander
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] How to speed up word count in tsearch2?

2005-04-01 Thread Mike Rylander
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] Sustained inserts per sec ... ?

2005-04-04 Thread Mike Rylander
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] Opteron vs Xeon (Was: What to do with 6 disks?)

2005-04-20 Thread Mike Rylander
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] Table Partitioning: Will it be supported in Future?

2005-04-26 Thread Mike Rylander
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] Postgresql on an AMD64 machine

2005-06-06 Thread Mike Rylander
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] Advice on RAID card

2005-09-25 Thread Mike Rylander
, 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] Huge Data sets, simple queries

2006-02-01 Thread Mike Rylander
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://open-ils.org