[PERFORM] Partitioning

2004-09-15 Thread J. Andrew Rogers
and association is the ugly part when rolling your own. Intercepting DML when necessary and making it behave correctly is already pretty easy, but could probably be streamlined. j. andrew rogers ---(end of broadcast)--- TIP 9: the planner will ignore

Re: [PERFORM] ill-planned queries inside a stored procedure

2004-08-28 Thread andrew
I use EXECUTE inside a stored procedure for just this purpose. This is not the same as PREPARE/EXECUTE, it lets you send an arbitrary string as SQL within the procedure. You have to write the query text on the fly in the procedure, which can be a little messy with quoting and escaping. Gaetano

Re: [PERFORM] Query performance issue with 8.0.0beta1

2004-08-27 Thread andrew
Is it possible (to mix two threads) that you had CLUSTERed the table on the old database in a way that retrieved the records in this query faster? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] Anyone familiar with Apple Xserve RAID

2004-08-26 Thread Andrew Rawnsley
of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast

Re: [PERFORM] Equivalent praxis to CLUSTERED INDEX?

2004-08-26 Thread J. Andrew Rogers
on heavily used tables with tens of millions of rows, we frequently got a 10x or better performance improvement on queries against those tables. It is only really useful for tables with vast quantities of relatively small rows, but it can be a lifesaver in those cases. J. Andrew Rogers

Re: [PERFORM] Anyone familiar with Apple Xserve RAID

2004-08-26 Thread Andrew Rawnsley
over the river, and rest under the shade of the trees. --T. J. Jackson, 1863 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Andrew Rawnsley President The Ravensfield Digital Resource

Re: [PERFORM] Equivalent praxis to CLUSTERED INDEX?

2004-08-26 Thread J. Andrew Rogers
of those options that needs to be used knowledgeably; it is not a general architectural improvement that you would want to apply to every table all the time. J. Andrew Rogers ---(end of broadcast)--- TIP 3: if posting/reading through Usenet

Re: [PERFORM] best way to fetch next/prev record based on index

2004-07-27 Thread andrew
Merlin Moncure [EMAIL PROTECTED] wrote .. [snip] select * from t where a = a1 and (a a1 or b = b1) and (a a1 or b b1 or c c1) I don't see why this is guaranteed to work without an ORDER BY clause, even if TABLE t is clustered on the correct index. Am I missing

Re: [PERFORM] Unbearably slow cascading deletes

2004-07-20 Thread andrew
PREPARE c(int4) AS DELETE FROM childtable WHERE fk=$1; EXPLAIN EXECUTE c(-1); gives an index scan. PREPARE c2(int4) AS DELETE FROM parenttable WHERE key=$1; EXPLAIN EXECUTE c2(1); gives a seq scan on the parent table (itself a little curious) and no explanation of what the triggers are doing.

Re: [PERFORM] Unbearably slow cascading deletes

2004-07-20 Thread andrew
I FOUND IT! A second trigger that doesn't belong.. OK, we're set now, and thanks for showing me some ways to check what the planner is up to. Is there a way of seeing what the triggers will do? ---(end of broadcast)--- TIP 4: Don't 'kill -9'

[PERFORM] Wierd issues

2004-07-16 Thread Andrew Matthews
I lost the email that had the fix for this and now I need it again can someone or tom let me know what the fix was, I cant find it in any of my emails or archived on the internet This is what I got Two servers, one debian, one fedora Debain dual 3ghz, 1 gig ram, ide, PostgreSQL

Re: [PERFORM] Seq scan vs. Index scan with different query

2004-07-05 Thread Andrew McMillan
. Regards, Andrew McMillan - Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/PHYS: Level 2, 150-154 Willis St DDI: +64(4)803

Re: [PERFORM] postgresql and openmosix migration

2004-06-23 Thread Andrew Hammond
memory. There are dozens of options for the disk array. For the processing platform, I'd recommend looking at Opteron. I've heard only good things and their price is much more reasonable than the other options. - -- Andrew Hammond416-673-4138[EMAIL PROTECTED] Database Administrator, Afilias

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-22 Thread Andrew Rawnsley
PROTECTED] (Andrew Rawnsley) transmitted: On Jun 21, 2004, at 2:02 PM, Andrew Hammond wrote: We're looking for an alternative to fiber-channel disk arrays for mass storage. One of the ideas that we're exploring would involve having the cluster on an NFS mounted filesystem. Another technology we're

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-22 Thread Andrew Hammond
it on server B and start postgres instance on server B. It gives me some fail-over capability as well as scalability and a lot of flexibility in balancing load over multiple servers. Avoid: paying for brutally expensive FC gear. - -- Andrew Hammond416-673-4138[EMAIL PROTECTED] Database

[PERFORM] Postgres over Linux NBD or NFS

2004-06-21 Thread Andrew Hammond
Device). Has anyone had any experience with running postgres over either of these technologies? What issues do we need to know about / pay attention to? - -- Andrew Hammond416-673-4138[EMAIL PROTECTED] Database Administrator, Afilias Canada Corp. CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF

Re: [PERFORM] Pl/Pgsql Functions running simultaneously

2004-06-21 Thread Andrew Hammond
are not responding. You seem like an intelligent guy and you asked an interesting question, but... | cold feet presents emma | | email marketing for discriminating | ^^^ | organizations everywhere | | visit www.myemma.com - -- Andrew Hammond416-673-4138[EMAIL PROTECTED] Database

Re: [PERFORM] Postgres over Linux NBD or NFS

2004-06-21 Thread Andrew Rawnsley
On Jun 21, 2004, at 2:02 PM, Andrew Hammond wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We're looking for an alternative to fiber-channel disk arrays for mass storage. One of the ideas that we're exploring would involve having the cluster on an NFS mounted filesystem. Another technology

Re: [PERFORM] Slow vacuum performance

2004-06-18 Thread Andrew McMillan
, Andrew McMillan shared_buffers = 2000 # min 16, at least max_connections*2, 8KB each sort_mem = 12288# min 64, size in KB # - Free Space Map - max_fsm_pages = 10 # min max_fsm_relations*16, 6 bytes each #max_fsm_relations = 1000 # min 100, ~50

Re: [PERFORM] JOIN order, 15K, 15K, 7MM rows

2004-06-08 Thread andrew
EXPLAIN INSERT INTO public.historical_price ( security_serial_id, [7 fields of proprietary data]) SELECT public.security_series.security_serial_id, [7 fields of data], FROM obsolete.datadb_fix INNER JOIN (obsolete.calcdb INNER JOIN public.security_series ON

Re: [PERFORM] Hardware opinions wanted

2004-06-02 Thread Andrew Hammond
aware of offer quad Opteron solutions with SATA raid: http://www.quatopteron.com/ http://alltec.com/home.php Andrew Hammond DBA - Afilias -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

Re: [PERFORM] DB Design

2004-05-19 Thread Andrew McMillan
, there are some SQL databases that would load the entire database into RAM from static files, and then allow query against this. This can obviously give huge performance improvements in situations where volatility is not a problem. Cheers, Andrew

Re: [PERFORM] Quad processor options

2004-05-13 Thread Andrew McMillan
well with PostgreSQL 7.4.2 under Debian woody (using Oliver Elphick's backported packages from http://people.debian.org/~elphick/debian/). Regards, Andrew. - Andrew @ Catalyst .Net .NZ

Re: [PERFORM] Quad processor options

2004-05-11 Thread J. Andrew Rogers
and the Tyan quad motherboard, and the sum comes out to a very reasonable number for what you are getting. j. andrew rogers ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs

Re: [PERFORM] Configuring PostgreSQL to minimize impact of

2004-05-11 Thread J. Andrew Rogers
-through, and IIRC, three different algorithms for reading (none, read-ahead, adaptive). Plenty of configuration options. It is a pretty mature and feature complete hardware RAID implementation. j. andrew rogers ---(end of broadcast)--- TIP 6

Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL

2004-05-05 Thread J. Andrew Rogers
of workloads that it doesn't do so well on, but for many normal DBMS loads it scales quite well. j. andrew rogers ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do

Re: [PERFORM] Wierd context-switching issue on Xeon patch for 7.4.1

2004-04-25 Thread Andrew McMillan
would usually be considered against security procedures, and would get a black mark when the auditors came through. Regards, Andrew McMillan - Andrew @ Catalyst .Net .NZ Ltd, PO Box 11

Re: [PERFORM] Wierd context-switching issue on Xeon

2004-04-20 Thread J. Andrew Rogers
I verified problem on a Dual Opteron server. I temporarily killed the normal load, so the server was largely idle when the test was run. Hardware: 2x Opteron 242 Rioworks HDAMA server board 4Gb RAM OS Kernel: RedHat9 + XFS 1 proc: 10-15 cs/sec 2 proc: 400,000-420,000 cs/sec j. andrew

Re: [PERFORM] Wierd context-switching issue on Xeon

2004-04-19 Thread J. Andrew Rogers
database hardware in general for us. j. andrew rogers ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PERFORM] linux distro for better pg performance

2004-04-15 Thread J. Andrew Rogers
your disk system hard (like we do). For databases with low disk I/O intensity, stay with IDE/SATA and save a little money. For databases that have high disk I/O intensity, use SCSI. The price premium for SCSI is about 50%, but the performance difference is an integer factor under load. j. andrew

Re: [PERFORM] Wierd issues

2004-04-09 Thread Andrew Matthews
user_pwds where password_type = upper(p_pwd_type) and user_id = l_user_id; return l_passwd; else return null; end if; end; ' LANGUAGE 'plpgsql' VOLATILE; -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 8:02 AM To: Andrew

Re: [PERFORM] good pc but bad performance,why?

2004-04-07 Thread Andrew McMillan
sure most of the people on this list have systems that regularly do way more than 50 inserts / second on server hardware. Regards, Andrew McMillan - Andrew @ Catalyst .Net .NZ Ltd, PO

[PERFORM] Wierd issues

2004-04-06 Thread Andrew Matthews
..5.63 rows=1 width=4) (actual time=0.00..0.00 rows=0 loops=72182) Index Cond: (email_id = $0) Total runtime: 2279869.08 msec (20 rows) Any suggestions? I cant figure this out. There is no reason it should be that much of a difference, Its all the same values, Thanks in advanced. Andrew

Re: [PERFORM] column size too large, is this a bug?

2004-03-28 Thread Andrew Rawnsley
Well, I don't know if I would use it in an insert-heavy environment (at least the way I implemented it), but for select-heavy stuff I don't know why you would want to use anything else. Hard to beat the performance of a simple BETWEEN. On Mar 28, 2004, at 2:25 PM, Josh Berkus wrote: Andrew, I

Re: [PERFORM] column size too large, is this a bug?

2004-03-26 Thread Andrew Rawnsley
, is that this is an actual bug in the patch and not just incorrect installation. I'm not interested enough to investigate though. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Andrew Rawnsley President

Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux

2004-03-23 Thread Andrew Sullivan
, at least when it comes to managing the largish number of processes that Postgres requires. If pure speed is what you're after, I have found that 2-way, 32 bit Linux on P-IIIs compares very favourably to 4 way 64 bit Ultra SPARC IIs. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact

Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux

2004-03-23 Thread Andrew Sullivan
a bad batch of Dell hardware recently, which makes me second this opinion. I should say, also, that my initial experience of AIX has been extremely good. I can't comment on the fun it might involve in the long haul, of course. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary

Re: [PERFORM] rapid degradation after postmaster restart

2004-03-17 Thread Andrew Sullivan
is not notoriously useful. You may want to have a look at what the example stuff in the SE Toolkit tells you, or what you get from sar. I believe you have to use a special kernel setting on Solaris to mark shared memory as being ineligible for swap. A -- Andrew Sullivan | [EMAIL PROTECTED] This work

Re: [PERFORM] Scaling further up

2004-03-15 Thread Andrew Sullivan
? How do I configure that, for knowledge? You don't. It'll automatically be in memory if (a) you have enough memory, (b) you don't have anything else on the machine using the memory, and (c) it's been read at least one time. A -- Andrew Sullivan | [EMAIL PROTECTED

Re: [PERFORM] Drop Tables Very Slow in Postgresql 7.2.1

2004-03-14 Thread Andrew Sullivan
a VACUUM FULL and a complete REINDEX of the system tables next. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin

Re: [PERFORM] [ADMIN] syslog slowing the database?

2004-03-14 Thread Andrew Sullivan
, if anyone thinks it'll be worth having around. FWIW, we use ours in production. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 8: explain analyze is your

Re: [PERFORM] compiling 7.4.1 on Solaris 9

2004-03-11 Thread Andrew Sullivan
On Wed, Mar 10, 2004 at 11:07:28AM -0500, Andrew Sullivan wrote: At work, we have been doing a number of tests on 7.4. The performance is such an improvement over 7.2 that the QA folks thought there must be something wrong. So I suppose the defaults are ok. I know, I know, replying

Re: [PERFORM] compiling 7.4.1 on Solaris 9

2004-03-10 Thread Andrew Sullivan
now. Again, this is on 8, not 9. At work, we have been doing a number of tests on 7.4. The performance is such an improvement over 7.2 that the QA folks thought there must be something wrong. So I suppose the defaults are ok. A -- Andrew Sullivan | [EMAIL PROTECTED

Re: [PERFORM] Using bigint needs explicit cast to use the index

2004-03-08 Thread Andrew Sullivan
far nobody's come up with a solution. There was a proposal to put in a special-case automatic fix for int4/int8 in 7.4, but I don't know whether it made it in. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them

Re: [PERFORM] Scaling further up

2004-03-03 Thread Andrew Sullivan
disposal. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [PERFORM] compiling 7.4.1 on Solaris 9

2004-03-01 Thread Andrew Sullivan
On Thu, Feb 26, 2004 at 12:46:23PM +, teknokrat wrote: I've read about the place. Would using -O3 be an improvement? In my experience, it's not only not an improvement, it sometimes breaks the code. That's on 8, though, not 9. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural

Re: [PERFORM] Slow in morning hours

2004-02-20 Thread Andrew Sullivan
on the machine during those hours? Maybe VACUUM is sucking up all your bandwidth. Or your backups. Or some other cron job. Note that 7.2 is pretty old. There are several performance improvements in subsequent versions. A -- Andrew Sullivan ---(end of broadcast

Re: [PERFORM] Disappointing performance in db migrated from MS SQL Server

2004-02-13 Thread Andrew Sullivan
the cache or when doing cache maintenance. A -- Andrew Sullivan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PERFORM] High Performance/High Reliability File system on SuSE64

2004-01-23 Thread Andrew Sullivan
gave me fits. But XFS was nice. -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland ---(end of broadcast

Re: [PERFORM] High Performance/High Reliability File system on SuSE64

2004-01-23 Thread Andrew Sullivan
be about the degree of testing the filesystem has received on Linux. On the other hand, I wouldn't be surprised if it were no worse than the other options. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace

Re: [PERFORM] 100 simultaneous connections, critical limit?

2004-01-14 Thread Andrew McMillan
potentially make things worse (depending on implementation) through double-handling of the data. As others have said too: 100 is just a configuration setting in postgresql.conf - not an implemented limit. Cheers, Andrew McMillan

[PERFORM] annoying query/planner choice

2004-01-11 Thread Andrew Rawnsley
? Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [PERFORM] annoying query/planner choice

2004-01-11 Thread Andrew Rawnsley
Low (1000). I'll fiddle with that. I just noticed that the machine only has 512MB of ram in it, and not 1GB. I must have raided it for some other machine... On Jan 11, 2004, at 10:50 PM, Dennis Bjorklund wrote: On Sun, 11 Jan 2004, Andrew Rawnsley wrote: 20-25% of the time. Fiddling

[PERFORM] failures on machines using jfs

2004-01-07 Thread Andrew Sullivan
, on the principle of better safe than sorry. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] Tuning for mid-size server

2003-12-14 Thread Andrew Sullivan
buffers under certain perverse loads is lousy database performance _precisely_ when we need it. I expect some testing of this type some time in January. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL

Re: [PERFORM] tuning questions

2003-12-04 Thread Andrew Sullivan
patterns -- and at that very moment, the power goes away -- the data that was reported to have been on the disk, but which was actually _not_ on the disk, is no longer anywhere. (Well, except in the past. But time travel was disabled some versions ago. ;-) A -- Andrew Sullivan

Re: [PERFORM] Various Questions

2003-12-01 Thread Andrew Sullivan
and pg_attribute more frequently than you might have thought. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304

[PERFORM] strange estimate for number of rows

2003-11-13 Thread Andrew Sullivan
. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast

Re: [PERFORM] strange estimate for number of rows

2003-11-13 Thread Andrew Sullivan
. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast

Re: [PERFORM] strange estimate for number of rows

2003-11-13 Thread Andrew Sullivan
On Thu, Nov 13, 2003 at 04:37:03PM -0500, Andrew Sullivan wrote: Actually, this one's on an internal box, and I think 1.5 is too low -- it's really just a pair of mirrored SCSI disks on a PCI controller in this case. That does the trick, though, so maybe I'm just being too conservantive. I

Re: [PERFORM] Response time

2003-11-05 Thread Andrew Sullivan
On Wed, Nov 05, 2003 at 11:35:22AM -0600, [EMAIL PROTECTED] wrote: The \timing psql command gives different time for the same query executed repeatedly. Why do you believe that the same query will always take the same time to execute? A -- Andrew Sullivan 204

Re: [PERFORM] Pg+Linux swap use

2003-10-31 Thread Andrew Sullivan
? A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast

Re: [PERFORM] vacuum locking

2003-10-23 Thread Andrew Sullivan
On Wed, Oct 22, 2003 at 09:27:47PM -0400, Tom Lane wrote: trace. What is causing that? Not VACUUM I don't think. It doesn't have any huge memory demand. But swapping out processes could account for What about if you've set vacuum_mem too high? A -- Andrew Sullivan

Re: [PERFORM] vacuum locking

2003-10-23 Thread Andrew Sullivan
didn't know if the memory was actually taken by vacuum at the beginning (like shared memory is) or what-all happened. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P

Re: [PERFORM] index file bloating still in 7.4 ?

2003-10-21 Thread Andrew Sullivan
on query echoing. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] Tuning for mid-size server

2003-10-21 Thread Andrew Sullivan
similar is at work here. Not that I've had a reason to play with 4G ix86 machines, anyway. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8

Re: [PERFORM] Tuning for mid-size server

2003-10-21 Thread Andrew Sullivan
Bruce's 2-way machine is within that threshold. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] Tuning for mid-size server

2003-10-21 Thread Andrew Sullivan
heavily on what you're trying to optimise for and what platform you have. But I'm glad to hear (again) that people seem to think the 25% too high for most cases. I don't feel so much like I'm tilting against windmills. A -- Andrew Sullivan 204-4141 Yonge Street

Re: [PERFORM] Tuning for mid-size server

2003-10-21 Thread Andrew Sullivan
started taking a long time. The buffer algorithm is just not that clever, was my conclusion. (Standard disclaimer: not a long, controlled test. It's just a bit of gossip.) A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario

Re: [PERFORM] PostgreSQL vs. MySQL

2003-10-09 Thread Andrew Sullivan
with the new probe-to-set-shared-buffers bit at install time, I think the reports of 400 billion times worse performance than MySQL will probably diminish. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL

Re: [PERFORM] Sun performance - Major discovery!

2003-10-09 Thread Andrew Sullivan
with the concern. I'd rather have slow'n'stable than fast-but-broken. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8

Re: [HACKERS] [PERFORM] Sun performance - Major discovery!

2003-10-09 Thread Andrew Sullivan
didn't work for gcc at the time. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] Sun performance - Major discovery!

2003-10-08 Thread Andrew Sullivan
than 5 connections). It might be worth trying again, though, since we moved to Sol 8. Thanks for the result. -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8

Re: [PERFORM] reindex/vacuum locking/performance?

2003-10-05 Thread Andrew Sullivan
your database is small. So you'll end up expiring potentially useful data in the buffer. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8

Re: [PERFORM] reindex/vacuum locking/performance?

2003-10-05 Thread Andrew Sullivan
idea how to give it such intelligence. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] reindex/vacuum locking/performance?

2003-10-04 Thread Andrew Sullivan
On Fri, Oct 03, 2003 at 02:24:42PM -0600, Rob Nagler wrote: I've read some posts that says vacuum doesn't lock, but my experience today indicates the opposite. It seemed that vacuum full analyze VACUUM doesn't. VACUUM FULL does. -- Andrew Sullivan 204-4141 Yonge

Re: [PERFORM] reindex/vacuum locking/performance?

2003-10-04 Thread Andrew Sullivan
On Fri, Oct 03, 2003 at 11:49:03PM -0400, Tom Lane wrote: What if said SELECTs are using the index in question? That's a good reason to build a new index and, when it's done, drop the old one. It still prevents writes, of course. A -- Andrew Sullivan 204-4141

Re: [PERFORM] reindex/vacuum locking/performance?

2003-10-04 Thread Andrew Sullivan
_way_ cheaper than it used to be, though. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] TPC-R benchmarks

2003-09-29 Thread Andrew Sullivan
On Mon, Sep 29, 2003 at 05:43:26PM -, [EMAIL PROTECTED] wrote: Anyone have a rough idea of the costs involved? I did a back-of-an-envelope calculation one day and stopped when I got to $10,000. A -- Andrew Sullivan 204-4141 Yonge Street Afilias Canada

Re: [PERFORM] Query on Postgresql performance

2003-09-04 Thread Andrew Sullivan
. The 7.2 branch is no longer being maintained, so you really probably should use the 7.3 branch. I'm unaware of others having stability problems with 7.3.4, so if you see them, you should find your core dump and talk to the people on -hackers. A -- Andrew Sullivan 204

Re: [PERFORM] PostgreSQL is slow...HELP

2003-09-03 Thread Andrew Sullivan
On Wed, Sep 03, 2003 at 06:08:57AM -0700, Azlin Ghazali wrote: I find that PostgreSQL runs up to 10 times slower than MySQL. For small records Have you done any tuning on PostgreSQL? Have you vacuumed, c.? All the usual questions. A -- Andrew Sullivan 204-4141

Re: [PERFORM] opinion on RAID choice

2003-09-02 Thread Andrew Sullivan
On Thu, Aug 28, 2003 at 03:26:14PM -0600, scott.marlowe wrote: My experience has been that once you get past 6 disks, RAID5 is faster than RAID1+0. Also depends on your filesystem and volume manager. As near as I can tell, you do _not_ want to use RAID 5 with Veritas. A -- Andrew

Re: [PERFORM] opinion on RAID choice

2003-09-02 Thread Andrew Sullivan
. Nobody's ever been able/willing to tell me. A Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] Hardware recommendations to scale to silly load

2003-08-29 Thread Andrew Sullivan
with how the shared memory is handled. You'll want to dig through the -general or -hackers archives from somewhere between 9 and 14 months ago, IIRC. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL

Re: [PERFORM] Force table to be permanently in cache?

2003-08-29 Thread Andrew Sullivan
in the archives of this list for thoughts on how big that should be. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1

Re: [PERFORM] PL/pgSQL functions - text / varchar - havy performance

2003-08-29 Thread Andrew Sullivan
syntactic sugar for text. In fact, text and varchar() are supposed to be exactly the same. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8

Re: [PERFORM] sourcecode for newly release eRServer?

2003-08-29 Thread Andrew Sullivan
On Fri, Aug 29, 2003 at 01:19:35PM -0400, george young wrote: Does anyone know how and when the actual release will happen? See the erserver project on gborg. It's out. There's a list, too; any problems, send 'em there. A Andrew Sullivan 204-4141 Yonge Street

Re: [PERFORM] Hardware recommendations to scale to silly load

2003-08-28 Thread Andrew Sullivan
write transactions per second is probably too much to ask for any standard hardware. But given that you are batching this once a week, and trying to avoid big expenses, are you use this is the right approach? Perhaps you should consider a redesign using COPY and such? A -- Andrew Sullivan

Re: [PERFORM] On Linux Filesystems

2003-08-14 Thread Andrew Sullivan
something like metadata journalling. Maybe others have more time to spare. perhaps even including performance metrics for *BSD. That, not Linux-baiting, is the answer... I didn't see anyone Linux-baiting. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS

Re: [PERFORM] Perfomance Tuning

2003-08-14 Thread Andrew Sullivan
have to have all sorts of nice tools to cope with the things that (for instance) fsck handles. I think the reaction of most developers has been, Why reinvent the wheel? A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario

Re: [PERFORM] How can I Improve performance in Solaris?

2003-08-14 Thread Andrew Sullivan
SELECTs, though, I can't see what exactly might be causing you so much difficulty. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8

Re: [PERFORM] Perfomance Tuning

2003-08-08 Thread Andrew Sullivan
usually write journalled or equivalent for this reason. I think UFS with soft updates is a good example of this. You also don't need complete journalling in most cases -- metadata is probably sufficient, given fsync. A -- Andrew Sullivan 204-4141 Yonge Street Liberty

Re: [PERFORM] Odd explain estimate

2003-07-31 Thread Andrew Sullivan
might want to investigate expainding the statistics on the indexed column, increasing the correlation through clustering, and other such tricks. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED

Re: [PERFORM] Mapping a database completly into Memory

2003-07-28 Thread Andrew Sullivan
at managing very large buffer sets. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110

Re: [PERFORM] Tuning PostgreSQL

2003-07-26 Thread Andrew McMillan
we get to choose. Good. Regards, Andrew. -- - Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI

Re: [PERFORM] Clearing rows periodically

2003-07-18 Thread Andrew Sullivan
want to increase your FSM settings. See the docs. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304

Re: [PERFORM] Hardware performance

2003-07-17 Thread Andrew Sullivan
RAID boxes :-( ), putting WAL on a disk of its own yielded something like 30% improvement in throughput on high transaciton volumes. So it's definitely important in some cases. A Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario

Re: [PERFORM] Dual Xeon + HW RAID question

2003-07-14 Thread Andrew Sullivan
failure, you need 1 (or some combination of 0 and 1, or 5). A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-14 Thread Andrew Sullivan
of thing in the application come to regret it. You probably want to look somewhere else to solve your performance difficulties from FKs. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-14 Thread Andrew Sullivan
everytime a new release comes out would be way too much work. It's not clear that the RPMs will help you in ease of upgrade. More precisely, be real sure you dump your database before upgrading major versions (e.g. 7.3.x to 7.4.x). A -- Andrew Sullivan 204-4141 Yonge

<    1   2   3   4   5   >