Re: [PERFORM] log_statement at postgres.conf

2008-07-20 Thread System/IJS - Joko
Thx a lot Nicolas, I finaly success to log query statement because of your simple explanation. I have other question: 1. Is there posibility to automatically logging that statement to table? 2. All of that statement is come from every database on my server, could I know from which database that

Re: [PERFORM] Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)

2008-07-20 Thread Greg Smith
On Sat, 19 Jul 2008, Stephane Bailliez wrote: OS is Ubuntu 7.10 x86_64 running 2.6.22-14 Note that I've had some issues with the desktop Ubuntu giving slower results in tests like this than the same kernel release using the stock kernel parameters. Haven't had a chance yet to see how the s

Re: [PERFORM] 3ware vs Areca

2008-07-20 Thread Greg Smith
On Tue, 15 Jul 2008, Jeffrey Baker wrote: Debian "etch", which has a 2.6.18 kernel. I have contacted Areca support (as well as the linux-scsi mailing list) and their responses are usually either 1) upgrade the driver and/or firmware even though I have the latest drivers and firmware Well, tec

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

2008-07-20 Thread Daniele Varrazzo
Tom Lane ha scritto: Daniele Varrazzo <[EMAIL PROTECTED]> writes: In my problem I had 2 tables: a small one (accounts), a large one (foo). The way the query is written doesn't allow the stats from the large table to be used at all, unless the records from the small table are fetched. This is i