Re: [PERFORM] An "obvious" index not being used

2008-07-18 Thread Francisco Reyes
Daniele Varrazzo writes: I suspect the foo.account_id statistical data are not used at all in query: the query planner can only estimate the number of accounts to look for, not You mentioned you bumped your default_statistics_target. What did you increase it to? My data sets are so "strange"

Re: [PERFORM] 3ware vs Areca

2008-07-18 Thread Francisco Reyes
Jeffrey Baker writes: Their firmware is, frankly, garbage. In more than one instance we have had the card panic when a disk fails, which is obviously counter to the entire purpose of a RAID. I have had simmilar problems with 3ware 9550 and 9650 cards. Undre FreeBSD I have seen constant crashe

Re: [PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Glyn Astill
> Glyn Astill wrote: > > Most likely just a forged header or something, hardly hacked > > though is it. > > Yes, hack is the correct term. The bad guys have hacked into the major email > systems, including gmail, which was the origin of this spam: > > http://www.theregister.co.uk/2008/02/25/

Re: [PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Andrew Sullivan
On Fri, Jul 18, 2008 at 10:40:33AM -0700, Craig James wrote: > Yes, hack is the correct term. The bad guys have hacked into the major email > systems, including gmail, which was the origin of this spam: > > http://www.theregister.co.uk/2008/02/25/gmail_captcha_crack/ The simple fact is that, a

Re: [PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Craig James
Glyn Astill wrote: Most likely just a forged header or something, hardly hacked though is it. Yes, hack is the correct term. The bad guys have hacked into the major email systems, including gmail, which was the origin of this spam: http://www.theregister.co.uk/2008/02/25/gmail_captcha_crack

Re: [PERFORM] long transaction

2008-07-18 Thread Lennin Caro
have you use VACUMM? --- On Fri, 7/18/08, Sabin Coanda <[EMAIL PROTECTED]> wrote: > From: Sabin Coanda <[EMAIL PROTECTED]> > Subject: [PERFORM] long transaction > To: pgsql-performance@postgresql.org > Date: Friday, July 18, 2008, 3:34 PM > Hi there, > > I have a script which includes 3 call

Re: [PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Glyn Astill
Most likely just a forged header or something, hardly hacked though is it. I think you need to do some training: http://www2.b3ta.com/bigquiz/hacker-or-spacker/ - Original Message > From: Craig James <[EMAIL PROTECTED]> > To: pgsql-performance@postgresql.org > Sent: Friday, 18 July,

Re: [PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Alvaro Herrera
Steve Atkins wrote: > > On Jul 18, 2008, at 4:02 PM, Craig James wrote: > >> I've never gotten a single spam from the Postgres mailing list ... >> until today. A Chinese company selling consumer products is using >> this list. I have my filters set to automatically trust this list >> becaus

[PERFORM] long transaction

2008-07-18 Thread Sabin Coanda
Hi there, I have a script which includes 3 called functions within a single transaction. At the beginning, the functions runs fast enough (about 60 ms each). In time, it begins to run slower and slower (at final about one per 2 seconds). I check the functions that runs slowly outside the s

Re: [PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Steve Atkins
On Jul 18, 2008, at 4:02 PM, Craig James wrote: I've never gotten a single spam from the Postgres mailing list ... until today. A Chinese company selling consumer products is using this list. I have my filters set to automatically trust this list because it has been so reliable until now

[PERFORM] Mailing list hacked by spammer?

2008-07-18 Thread Craig James
I've never gotten a single spam from the Postgres mailing list ... until today. A Chinese company selling consumer products is using this list. I have my filters set to automatically trust this list because it has been so reliable until now. It would be really, really unfortunate if this lis

[PERFORM] query plan, index scan cost

2008-07-18 Thread Stefan Zweig
hi list, i have a problem with time consuming query. first of all my table structure: CREATE TABLE nw_tla_2008_4_deu ( "ID" bigint NOT NULL, "NET2CLASS" smallint, "FOW" smallint, CONSTRAINT nw_tla_2008_4_deu_pkey PRIMARY KEY ("ID"), ) WITHOUT OIDS; CREATE INDEX nw_tla_2008_4_deu_fow_idx ON nw_t

Re: [PERFORM] log_statement at postgres.conf

2008-07-18 Thread Pomarede Nicolas
On Fri, 18 Jul 2008, System/IJS - Joko wrote: I added the following to FreeBSD: /etc/newsyslog.conf: /var/log/postgresql 600 7 *@T00 JC make new file? /etc/syslog.conf: local0.*/var/log/postgresql /usr/local/pgsql/data/po