Re: [PERFORM] log_statement at postgres.conf

2008-07-18 Thread System/IJS - Joko
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/postgresql.conf: log_destination = 'syslog'

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

[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

[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

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

[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

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 because it has

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

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 called

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:

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

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:

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

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