Hi All,
I have these indexes on a table:
CREATE INDEX uidx_product_partno_producer_id
ON product
USING btree
(partno, producer_id);
CREATE INDEX idx_product_partno
ON product
USING btree
(partno);
Can I safely delete the second one? Will postgresql use
(partno,producer_id) when it
Arjen van der Meijden acmmail...@tweakers.net writes:
When we purchased our Perc 5/e with MD1000 filled with 15 15k rpm sas disks,
my
colleague actually spend some time benchmarking the PERC and a ICP Vortex
(basically a overclocked Adaptec) on those drives. Unfortunately he doesn't
have
On Sun, Feb 15, 2009 at 6:35 PM, Greg Smith gsm...@gregsmith.com wrote:
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm goes over
this topic, with Appendix B: pg_stat_bgwriter sample analysis covering a
look at what to do based on a pg_stat_bgwriter snapshot.
Wonderful, thank
Laszlo Nagy wrote:
Hi All,
I have these indexes on a table:
CREATE INDEX uidx_product_partno_producer_id
ON product
USING btree
(partno, producer_id);
CREATE INDEX idx_product_partno
ON product
USING btree
(partno);
Can I safely delete the second one?
You can safely
BTW
our Machine got build with 8 15k drives in raid10 ,
from bonnie++ results its looks like the machine is
able to do 400 Mbytes/s seq write and 550 Mbytes/s
read. the BB cache is enabled with 256MB
sda6 -- xfs with default formatting options.
sda7 -- mkfs.xfs -f -d sunit=128,swidth=512
Recently I've been working on improving the performance of a system that
delivers files stored in postgresql as bytea data. I was surprised at
just how much a penalty I find moving from a domain socket connection to
a TCP connection, even localhost. For one particular 40MB file (nothing
outragous)
On Feb 17, 2009, at 12:04 AM, Ross J. Reedstrom wrote:
Recently I've been working on improving the performance of a system
that
delivers files stored in postgresql as bytea data. I was surprised at
just how much a penalty I find moving from a domain socket
connection to
a TCP connection,
On Tue, 17 Feb 2009, Rusty Conover wrote:
On Feb 17, 2009, at 12:04 AM, Ross J. Reedstrom wrote:
Recently I've been working on improving the performance of a system that
delivers files stored in postgresql as bytea data. I was surprised at
just how much a penalty I find moving from a domain