[PERFORM] Battery Backed Cache for RAID

when it's not actually committed. My question is, if the power goes off, and the drives stop, how does the battery backed cache save things out to the dead drives? Is there another component that is implied that will provide power to the drives that I should be looking into as well? Tha

Re: [PERFORM] Possibly slow query

have human readable/editable tables. Thanks, Peter Darley -Original Message- From: Manfred Koizar [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 3:06 AM To: Peter Darley Cc: Richard Huxton; Pgsql-Performance Subject: Re: [PERFORM] Possibly slow query On Wed, 26 Jan 2005 07:

Re: [PERFORM] Possibly slow query

s likely to be faster than a distinct, tho I can't really recall where I got that idea from. Thanks for your suggestions! Peter Darley -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 1:36 AM To: Peter Darley Cc: Pgsql-Performan

[PERFORM] Possibly slow query

ctual time=0.033..0.040 rows=2 loops=1) Filter: ((user_id IS NOT NULL) AND ((subplan) IS NULL)) SubPlan -> Seq Scan on assignment_settings (cost=0.00..0.00 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=2) Filter: (((setti

Re: [PERFORM] PgPool changes WAS: PostgreSQL clustering VS MySQL

servers, at which point we won't even be getting requests from the same machine, much less the same connection. Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Josh Berkus Sent: Monday, January 24, 2005 3:46 PM To: Ragnar Hafsta

Re: [PERFORM] PostgreSQL clustering VS MySQL clustering

Tatsuo, What would happen with SELECT queries that, through a function or some other mechanism, updates data in the database? Would those need to be passed to pgpool in some special way? Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Re: [PERFORM] Data type to use for primary key

All, Well, you should still escape any strings you're getting from a web page so you can ensure you're not subject to a SQL insert attack, even if you're expecting integers. Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] B

[PERFORM] View columns calculated

f I have 5 columns in a view but only select 1 column, is the system smart enough to not calculate the unused columns, or am I taking a performance hit over a smaller view that doesn't have the extra 4 columns? Thanks, Peter Darley ---(end of broadcast)--

Re: [PERFORM] Forcing filter/join order?

Josh, I'm sure the big brains have a better suggestion, but in the mean time could you do something as simple as: SELECT * FROM (select * from events where event_date BETWEEN 'date1' AND 'date2') e LEFT OUTER JOIN cases ON e.case_id = cases.case_id; Thanks, Pe

Re: [PERFORM] Odd problem with performance in duplicate database

Josh, I'm sure that you've thought of this, but it sounds like you may not have done an analyze in your new DB. Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Josh Berkus Sent: Monday, August 11, 2003 3:48 PM To: R