Mark Kirkwood [EMAIL PROTECTED] writes:
I spent today looking at getting this patch into a self contained state.
Working against HEAD I'm getting bogged down in the PathKeyItem to
PathKey/EquivalenceClass/EquivalenceMember(s) change. So I figured I'd divide
and conquer to some extent, and
Hi.
We are using a HP DL 380 G5 with 4 sas-disks at 10K rpm. The
controller is a built in ciss-controller with 256 MB battery-backed
cache. It is partitioned as raid 1+0.
Our queries are mainly selects.
I will get four 72 GB sas-disks at 15K rpm. Reading the archives
suggest raid 1+0 for
Hi,
I am running postgres 8.2 on RH linux.
My daemon downloads files and then inserts the data into preliminary
tables, and finally calls a stored procedure which reads data from a
view and inserts into the final table.
I have a bit of a peculiar problem. (I understand this may not be the
right
On Nov 5, 2007, at 8:19 AM, Claus Guttesen wrote:
Is the ciss-controller found in HP-servers a better raid-controller
compared to the areca-raid-controller mentioned on this list?
I've had great success with the P600 controller (upgraded to 512MB
bbwc) plugged into an MSA70 with a pile
On Mon, 5 Nov 2007, Claus Guttesen wrote:
Is the ciss-controller found in HP-servers a better raid-controller
compared to the areca-raid-controller mentioned on this list?
If you search the archives for cciss you'll see a few complaints about
this controller not working all that well under
PostgreSQL:8.2.4
I am collecting statistics info now on my database. I have used the
following two queries:
select * from pg_stat_all_indexes;
select * from pg_statio_all_indexes;
How can I use the information from these two queries to better optimize
my indexes? Or maybe even get
PostgreSQL: 8.2.4
Does anyone have any companies they would recommend using for
performance tuning training of PostgreSQL for Linux? Or general DBA
training?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
On Nov 4, 2007, at 6:33 PM, Greg Smith wrote:
For those of you considering a move to the upcoming 8.3 release,
now in beta, I've written some documentation on the changes made in
checkpoint and background writer configuration in the new version:
I have a question.
Consider this scenario.
Table customer (
customer_id int8,
customer_l_name varchar(35),
customer_f_name varchar(30),
customer_addr_1 varchar(100),\
customer_addr_2 varchar(100),
customer_city varchar(50),
customer_state char(2),
customer_zip varchar(9)
);
On this table, a
Chris Hoover [EMAIL PROTECTED] writes:
Is it better to create 3 indexes, or one index on the three columns?
This is covered in considerable detail in the fine manual:
http://www.postgresql.org/docs/8.2/static/indexes.html
See particularly sections 11.3 and 11.4
Chris Hoover wrote:
On this table, a customer can search by customer_id, customer_l_name,
and customer_f_name.
Is it better to create 3 indexes, or one index on the three columns?
I did some initial testing with index customer_test_idx(customer_id,
customer_l_name, customer_f_name) and
On 11/5/07, Radhika S [EMAIL PROTECTED] wrote:
Hi,
I am running postgres 8.2 on RH linux.
My daemon downloads files and then inserts the data into preliminary
tables, and finally calls a stored procedure which reads data from a
view and inserts into the final table.
I have a bit of a
If I do:
begin;
update some_table set foo = newvalue where a_bunch_of_rows_are_changed;
analyze some_table;
rollback;
does it roll back the statistics? (I think the answer is yes, but I need to be
sure.)
Thanks,
Craig
---(end of
Craig James [EMAIL PROTECTED] writes:
If I do:
begin;
update some_table set foo = newvalue where a_bunch_of_rows_are_changed;
analyze some_table;
rollback;
does it roll back the statistics? (I think the answer is yes, but I need to
be sure.)
Yes --- ANALYZE doesn't do anything
14 matches
Mail list logo