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 so
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, ev
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)
The URL of the result is
http://98.129.214.99/bonnie/report.html
(sorry if this was a repost)
On Tue, Feb 17, 2009 at 2:04 AM, Rajesh Kumar Mallah
wrote:
> BTW
>
> our Machine got build with 8 15k drives in raid10 ,
> from bonnie++ results its looks like the machine is
> able to do 400 Mbyte
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 /
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?
On Sun, Feb 15, 2009 at 6:35 PM, Greg Smith 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 you.
Alexander
Arjen van der Meijden 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 too many comparable r
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 onl
